Importing time-phased master data from M3

The SCV Inbox, Core and Planning Configuration (User Data) tables are grouped as follows:

  • Master data tables
  • Time-phased master data tables
  • Transactional data tables

One corresponding Table Group exists in SCV which is used during Inbox -> Core transfer to determine the applied delete modes and update modes. For example, master data in Core is logically deleted and new data from Inbox is merged into Core, while time-phased master data in Core is physically deleted and new data from Inbox is inserted into Core.

The Staging import tables populated by the M3 integration and the Staging -> Inbox transfers have been still grouped as Master and Transactional. To align the grouping of the SCV tables populated by the M3 integration with the rest of the generic processing in SCV, the macros that import planning data from M3 have been reorganized.

These imports have been removed from the macro SCV - M3 Import Master Full:

  • Calendar
  • Supplier day capacity
  • Price list
  • Currency rate
  • Promotion
  • Consumed forecast (transactional data but used in ST_V_M3_ITEM_SALES)
  • Material plan (transactional data but used in ST_V_M3_ITEM_SALES)

These imports have been added to the macro SCV - M3 Import Transactional Full:

  • Calendar
  • Supplier day capacity
  • Price list
  • Currency rate
  • Promotion

These macros have been updated in line with the above changes:

  • SCV - M3 Import Demand Master Full
  • SCV - M3 Import Demand Transactional Full
  • SCV - M3 Import Supply Master Full
  • SCV - M3 Import Supply Transactional Full
  • SCV - M3 Transfer Master Staging to Inbox Full
  • SCV - M3 Transfer Transactional Staging to Inbox Full
  • SCV - M3 Transfer Demand Master Staging to Inbox Full
  • SCV - M3 Transfer Demand Transactional Staging to Inbox Full
  • SCV - M3 Transfer Supply Master Staging to Inbox Full
  • SCV - M3 Transfer Supply Transactional Staging to Inbox Full
Note: This feature is enabled after loading the base for M3 template (base for M3.zip) for this version. A new role or privilege access is not required to use this feature.