Moving SCV Views for SCO from base template

The SCO model version used by Supply Planning analytical (OLAP) cycles is fixed to SCO version 21.2. However, the SCO model used by the Planning Engine continues to be extended with enhancements and new features.

The SCO mapping views in SCV (SP_V_* views) are used to provide the planning data to both applications. These views are delivered as part of the base template (base.zip). In order to synchronize the data mappings between SCV and these applications and to ensure further improvements to the PE SCO model, the SCO mapping views have been separated into two sets of views within their corresponding templates.

The SP_V_* views used by the Planning Engine are now delivered as part of the Planning Engine SCO template (aspco.zip). The views for Supply Planning analytical (OLAP) cycles have been renamed to SPLS_V_* and are now delivered as part of the Supply Planning template (spls.zip). All related configuration in Supply Planning, such as interface services, is updated to use the new view names.

These views have been created from their SP_V_* counterparts:

  • SPLS_V_CALENDARS
  • SPLS_V_CUSTOMERS
  • SPLS_V_CUSTOMER_ALLOCATIONS
  • SPLS_V_CUSTOMER_ORDERS
  • SPLS_V_EXPIRING_QTY_ON_HAND
  • SPLS_V_FIRM_DELIVERY
  • SPLS_V_FIRM_PRODUCTION
  • SPLS_V_FIRM_RECEIPTS
  • SPLS_V_FIRM_RELEASED_PRODUCTION
  • SPLS_V_FIRM_SHIFTED_PRODUCTION
  • SPLS_V_FIRM_SHIPMENTS
  • SPLS_V_FIXED_DELIVERY
  • SPLS_V_FIXED_DELIVERY_PLAN_FXD
  • SPLS_V_FIXED_PRODUCTION
  • SPLS_V_FIXED_PRODUCTION_PLAN_FXD
  • SPLS_V_FIXED_RECEIPTS
  • SPLS_V_FIXED_RECEIPTS_PLAN_FXD
  • SPLS_V_FIXED_SHIFTED_PRODUCTION
  • SPLS_V_FIXED_SHIFTED_PRODUCTION_PLAN_FXD
  • SPLS_V_FIXED_SHIPMENTS
  • SPLS_V_FIXED_SHIPMENTS_PLAN_FXD
  • SPLS_V_FORECASTS
  • SPLS_V_FORECASTS_PLAN_AGGR
  • SPLS_V_FORMULAS
  • SPLS_V_INITIAL_BACKORDERS
  • SPLS_V_IN_TRANSIT_INVENTORY_OLD
  • SPLS_V_LOCATIONS
  • SPLS_V_MAX_END_TOTAL_STOCK_SU
  • SPLS_V_MAX_PLANNED_PRODUCTION
  • SPLS_V_MAX_PURCHASE_QTY
  • SPLS_V_PROCESSES
  • SPLS_V_PROCESS_GROUPS
  • SPLS_V_PROCESS_GROUP_CALENDAR
  • SPLS_V_PRODUCTS
  • SPLS_V_PRODUCTS_AT_LOCATIONS
  • SPLS_V_PRODUCTS_AT_SUPPLIERS
  • SPLS_V_QTY_ON_HAND
  • SPLS_V_QTY_ON_HAND_WIP
  • SPLS_V_QUANTITY_ON_HAND_OLD
  • SPLS_V_RESOURCES
  • SPLS_V_RESOURCE_ALLOCATIONS
  • SPLS_V_RESOURCE_CALENDAR
  • SPLS_V_ROUTES
  • SPLS_V_ROUTES_IN
  • SPLS_V_ROUTES_OUT
  • SPLS_V_ROUTE_CALENDAR
  • SPLS_V_ROUTE_IN_CALENDAR
  • SPLS_V_ROUTE_OUT_CALENDAR
  • SPLS_V_SCHEDULED_DELIVERIES_OLD
  • SPLS_V_SCHEDULED_DELIVERY
  • SPLS_V_SCHEDULED_DELIVERY_PLAN_RSCH
  • SPLS_V_SCHEDULED_PRODUCTION
  • SPLS_V_SCHEDULED_PRODUCTION_OLD
  • SPLS_V_SCHEDULED_PRODUCTION_PLAN_RSCH
  • SPLS_V_SCHEDULED_RECEIPTS
  • SPLS_V_SCHEDULED_RECEIPTS_PLAN_RSCH
  • SPLS_V_SCHEDULED_RELEASED_PRODUCTION
  • SPLS_V_SCHEDULED_RELEASED_PRODUCTION_PLAN_RSCH
  • SPLS_V_SCHEDULED_SHIFTED_PRODUCTION
  • SPLS_V_SCHEDULED_SHIFTED_PRODUCTION_PLAN_RSCH
  • SPLS_V_SCHEDULED_SHIPMENTS
  • SPLS_V_SCHEDULED_SHIPMENTS_PLAN_RSCH
  • SPLS_V_SUPPLIERS
  • SPLS_V_SUPPLIERS_MIN_PURCHASE
  • SPLS_V_SUPPLIER_ALLOCATIONS
  • SPLS_V_TRANSFERS
  • SPLS_V_VARIABLES

These interface services have been updated to use the new SPLS_V_* views instead of SP_V_* views:

  • SPLS - SCV -Import SPLS_CalendarCodelist SPLS_V_CALENDARS
  • SPLS - SCV -Import SPLS_CalendarCodelist SP_V_CALENDARS
  • SPLS - SCV -Import Base Suppliers
  • SPLS - SCV -Import Current WIP on hand
  • SPLS - SCV -Import Customer Bucket Measures SC_DEMAND
  • SPLS - SCV -Import Customer Bucket Measures
  • SPLS - SCV -Import Customer Measures
  • SPLS - SCV -Import Forecast SC_DEMAND
  • SPLS - SCV -Import Forecast
  • SPLS - SCV -Import Item Supplier Calendar
  • SPLS - SCV -Import Item Supplier Measures
  • SPLS - SCV -Import Location Measures
  • SPLS - SCV -Import Processes
  • SPLS - SCV -Import Product Measures
  • SPLS - SCV -Import Product at Location Measures
  • SPLS - SCV -Import Product at Location Start Stock Expiring Plan
  • SPLS - SCV -Import Product at Location Stock on Hand
  • SPLS - SCV -Import Production Measures
  • SPLS - SCV -Import Resources Measures
  • SPLS - SCV -Import Resources Period Measures Conversion - Capacity
  • SPLS - SCV -Import Resources Period Measures Conversion - Efficiency
  • SPLS - SCV -Import Routings Inflow
  • SPLS - SCV -Import Routings Outflow
  • SPLS - SCV -Import Supplier Locations
  • SPLS - SCV -Import Supplier Measures
Note: This feature is enabled after loading the Supply Planning template (spls.zip) for this version. A new role or privilege is not required to access this feature.