Importing assortments from M3

Previously, M3 assortments have been imported from M3 for customers where the assortment check (ACHK) has value 2. These are the assortments directly connected to customers themselves. However, in some cases, assortments can be connected to customers using business chains. To support these cases, the M3 import have been extended to include assortments where customer’s assortment check is 1.

Additionally, two new application variables have been introduced to allow finer control of imported assortments:

  • m3_import_generated_assortments: When set to 0, only the item-customer combinations are imported for which the corresponding assortment in M3 exists. Default value is 0.
  • m3_import_current_assortments: When set to 1, only the item-customer combinations are imported for which the corresponding assortment in M3 is effective at the time of import. Default value is 1.

These new SCV entities have been added:

  • OIS038MI_LstBusChainCust
  • OIS038MI_LstBusChainStr

These new SCV tables have been registered:

  • ST_M3_IN_OIS038MI_LstBusChainCust
  • ST_M3_IN_OIS038MI_LstBusChainStr

These new SCV BOIs have been added:

  • OIS038MI_LstBusChainCust_ST_M3_IN_OIS038MI_LstBusChainCust
  • OIS038MI_LstBusChainStr_ST_M3_IN_OIS038MI_LstBusChainStr

This new SCV database view has been added:

  • ST_V_M3_ITEM_CUSTOMER_ASSM_BUSCHAIN

The new SCV mapping has been added.

  • BASE_ST_V_M3_ITEM_CUSTOMER_ASSM_BUSCHAIN-SI_ITEM_CUSTOMER

These macros have been updated:

  • SCV - M3 Import Master Full
  • SCV - M3 Import Demand Master Full
  • SCV - M3 Import Supply Master Full
  • SCV - M3 Transfer Master Staging to Inbox Full
  • SCV - M3 Transfer Demand Master Staging to Inbox Full
  • SCV - M3 Transfer Supply Master Staging to Inbox Full

This feature is enabled after appending the base for M3 template (base for M3.zip) for this version. By default, this feature is enabled. No additional role or privilege is required to access this feature.

Note: The default values for the newly introduced application variables change the import behavior; the previous import behavior can be reinstated by setting m3_import_generated_assortments to 1 and m3_import_current_assortments to 0.