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