Moving SCV views for SCO Mappings to Base Template

The SCO mapping views in SCV (SP_V_* views) are used by standalone AP, Planning Engine and Supply Planning to read the planning data from SCV. Previously these views have been delivered as part of the ApSco template (apsco.zip). In order to synchronize the data mappings between SCV and these applications and to reduce maintenance, these views have been moved to the base template (base.zip).

The SM_SCO_SUPPLIERS_MIN_PURCHASE table is manually maintained time-phased user data in SCV, loaded by the apsco or spls templates. Currently, manually maintained time-phased user data is saved in the recently introduced BUCKETS entities in SCV. The SM_SCO_SUPPLIERS_MIN_PURCHASE table has been replaced by the SM_SUPPLIER_BUCKETS new table to align the entities for time-phased user data. Few SP_V_* views are updated to consider planning period start date from planning calendar instead of current date.

All SP_V_* views are migrated to base template and are delivered as part of the base template.

These SP_V_* views are updated to consider planning period start date instead of current date to filter and fetch required information:

  • SP_V_CUSTOMER_ORDERS
  • SP_V_INITIAL_BACKORDERS
  • SP_V_QTY_ON_HAND
  • SP_V_EXPIRING_QTY_ON_HAND
  • SP_V_QTY_ON_HAND_WIP
  • SP_V_FIRM_RELEASED_PRODUCTION
  • SP_V_SCHEDULED_RELEASED_PRODUCTION
  • SP_V_FIXED_PRODUCTION
  • SP_V_FIRM_PRODUCTION
  • SP_V_SCHEDULED_PRODUCTION
  • SP_V_FIXED_SHIFTED_PRODUCTION
  • SP_V_FIRM_SHIFTED_PRODUCTION
  • SP_V_SCHEDULED_SHIFTED_PRODUCTION

This new SCV entity has been added:

  • SUPPLIER_BUCKETS

This new SCV table has been registered together with all related configuration (such as constraints, validation rules, datasheets):

  • SM_SUPPLIER_BUCKETS

These new macros have been added to validate and purge the new table:

  • SCV: Migrate Supplier Buckets Data (Planning Configuration)

This new macro and corresponding new mappings and view have been added to migrate data from deprecated table SM_SCO_SUPPLIERS_MIN_PURCHASE:

  • scv_use_order_split_process_custom_plan
  • scv_use_order_split_process_custom_table
Note: This feature is enabled after loading the base template (base.zip) for this version. You are not required a new role or privilege access to use this feature.

Action required prior to activation:

Review the changes to the SP_V_* views in the Release Notes. If required, remove the view definitions from base.zip before upgrading the base content.

Migrate the existing data from the deprecated SM_SCO_SUPPLIERS_MIN_PURCHASE table to the new SM_SUPPLIER_BUCKETS table, the following migrate macro must be executed:

  • SCV: Migrate Supplier Buckets Data (Planning Configuration)