Program scope

This is the scope of the TFORM_MAP_ROUTING_VERSION program:
  • The program processes these tables to generate new records:
    • SC_ROUTING
    • SC_ROUTING_INPUT_ITEM
    • SC_ROUTING_OUTPUT_ITEM
    • SC_ROUTING_OP
    • SC_ROUTING_OP_ALT
    • SC_ROUTING_RESOURCE_ALT
  • New routing versions are created in these tables:
    • SC_ROUTING
    • SC_ROUTING_INPUT_ITEM
    • SC_ROUTING_OUTPUT_ITEM
    • SC_ROUTING_OP
    • SC_ROUTING_OP_ALT
    • SC_ROUTING_RESOURCE_ALT
  • The program updates these tables with the new routing versions:
    • SC_ROUTING
    • SC_PROD_OPEN_TRX
    • SC_PROD_HIST_TRX
    • SC_PROD_CNCL_TRX
    • SC_PROD_PLND_TRX
  • The item and location data selection filters are determined as follows:
    • If the SZ_ROUTING_VERSION_MAP.<Item Data Selection> is specified:
      <item filter> = 
            AND  SZ_ROUTING_VERSION_MAP.<Item Selection Column> IN 
                        (SELECT SZ_ROUTING_VERSION_MAP.<Item Data Selection.column name> 
                         FROM SZ_ROUTING_VERSION_MAP.<Item Data Selection.table name> 
                         WHERE SZ_ROUTING_VERSION_MAP.<Item Data Selection.filter expression>)
    • If the SZ_ROUTING_VERSION_MAP.<Location Data Selection> is specified:
      location filter> = 
            AND  SZ_ROUTING_VERSION_MAP.<Location Selection Column> IN 
                        (SELECT SZ_ROUTING_VERSION_MAP.<Location Data Selection.column name> 
                         FROM SZ_ROUTING_VERSION_MAP.<Location Data Selection.table name> 
                         WHERE SZ_ROUTING_VERSION_MAP.<Location Data Selection.filter expression>)