Uploading Data

Report /BTI/TE_TP_LIST_UPLOAD_UTILITY has been created to populate en-masse the Lock, Scope and Allow tables.

It can also be run using transaction /BTI/TE_TP_LUPL.

It accepts an Excel spreadsheet with the following header.

• Source = Source system. Mandatory field.
• PGMID = Program ID. Mandatory field.
• OBJECT = Object ID. Mandatory field. Technical object type.
• OBJECTNAME = Object name.
• TABKEY = Table key.

Example:

!Wildcards are ONLY accepted in fields OBJECTNAME and TABKEY

If a table is specified, and TP Key Locking is enabled for that Source, a wildcard must be inserted in TABKEY, eg:

Example:

A spreadsheet document is available to be downloaded as a template.