Program logic

The TFORM_GENERATE_VALID_COMBINATIONS program uses the following logic to generate valid item-location-customer combinations:
  1. Process the data, only from the SCV Core tables, which is supported. This table lists the Core table supported by the program:
    Available table list Time phased
    SC_ITEM_AVAILABILITY Yes
    SC_ITEM_CUSTOMER Yes
    SC_ITEM_LOCATION No
    SC_ITEM_NPI Yes
    SC_ITEM_SALES No
    SC_ITEM_SUPERSESSION No
    SC_SALES_HIST_AGGR No
    SC_SALES_HIST_TRX No
  2. Applies the Cartesian product to the missing dimension, using these SCV Core tables:
    • SC_CUSTOMER
    • SC_LOCATION (type=Warehouse)
  3. Saves the generated valid combinations in the SC_VALID_COMBINATIONS table.
  4. Generates valid item-location-customer combinations as follows:
    • Clean up the results from the previous execution. See, Cleanup for more details.
    • Generate valid combinations of item, location, or customer. See, Generate for more details.