Generation of valid combinations

The TFORM_GENERATE_VALID_COMBINATIONS program generates valid item-location-customer combinations from a specific list of SCV Core tables. This program can process only a fixed list of SCV Core tables. You can select a subset of SCV Core tables and modify the processing order.

Only specific SCV tables contain time-phased data. When processing the data from non-time-phased input tables, the combinations are generated for the entire horizon. the combinations are specified in the SCP_DEFAULT_START_DATE and SCP_DEFAULT_END_DATE SCV configuration parameters. SCV tables that are supported can be available at item-location, item-customer, or item-location-customer level.

The TFORM_GENERATE_VALID_COMBINATIONS program generates combinations at item-location-customer level from the selected tables, which are potentially at different levels. When processing the data from input tables with a higher level compared to the item-location-customer level, the combinations are generated for all records in the missing dimension. For example, a Cartesian product is applied to warehouses in the SC_LOCATION table or customers in the SC_CUSTOMER table.

The specified processing order of the selected input tables is significant. Therefore, when processing a table, the matching item-location-customer combinations from the previous table in the list are overwritten by the records from the next table. All data for the matching item-location-customer combination is overwritten, including the effective periods, and spreading factor.

Note: When the input table does not contain the spreading factor column, the column value defaults to 1 in the generated combinations.