Program scope
The EXECUTE_TRANSFER program determines the scope as follows:
- If the MAPPING_ID or MAPPING_NAME parameter is specified, the program executes only the specified mapping, if the mapping is active.
- If the TARGET_TABLE_NAME parameter is specified:
- The program uses the active mapping regardless of the Default Mapping flag setting if only one active mapping exists for the table.
- The program uses the active Default Mapping flag setting if multiple active mappings exist.
- If the TARGET_TABLE_GROUP_ID or TARGET_TABLE_GROUP_NAME parameter is specified, the program executes each target table in the specified table group, using the mapping selection logic defined for TARGET_TABLE_NAME in ascending order of processing_sequence.
Note: If processing_sequence on table group tables is not defined, the program uses the default_processing_sequence defined in SZ_REG_TABLE.
- If the TARGET_TABLE_AREA is specified, the program executes each target table in the SZ_REG_TABLE registry for the specified table area, using the mapping selection logic defined for TARGET_TABLE_NAME in ascending order of default_processing_sequence.
- If multiple tables exist in scope, the program determines the processing sequence as follows:
- Generates a dependency tree for the tables in scope using foreign key references between the tables.
- Determines the processing sequence as follows:
If TABLE_GROUP_ID or TABLE_GROUP_NAME is specified If processing_sequence is defined for all tables in the specified table group, then the processing_sequence from the table group is used in ascending order Else the tables in scope are processed using the generated dependency tree: Tables with no dependencies or tables depending only on already processed tables are processed first