Improvements to current period calculation in database views

In SCP 21.1 several PE SCO database views (SP_V_* views) and PE interface services have been updated to support the current planning period. In this release, the same changes are applied to the remaining PE views and interface services.

These PE SCO database views are updated:
  • SP_V_CUSTOMER_ORDERS
  • SP_V_EXPIRING_QTY_ON_HAND
  • SP_V_FIRM_DELIVERY
  • SP_V_FIRM_PRODUCTION
  • SP_V_FIRM_RECEIPTS
  • SP_V_FIRM_RELEASED_PRODUCTION
  • SP_V_FIRM_SHIFTED_PRODUCTION
  • SP_V_FIRM_SHIPMENTS
  • SP_V_FIXED_DELIVERY
  • SP_V_FIXED_DELIVERY_PLAN_FXD
  • SP_V_FIXED_PRODUCTION
  • SP_V_FIXED_PRODUCTION_PLAN_FXD
  • SP_V_FIXED_RECEIPTS
  • SP_V_FIXED_RECEIPTS_PLAN_FXD
  • SP_V_FIXED_SHIFTED_PRODUCTION
  • SP_V_FIXED_SHIFTED_PRODUCTION_PLAN_FXD
  • SP_V_FIXED_SHIPMENTS
  • SP_V_FIXED_SHIPMENTS_PLAN_FXD
  • SP_V_INITIAL_BACKORDERS
  • SP_V_PRODUCTS_AT_SUPPLIERS
  • SP_V_QTY_ON_HAND
  • SP_V_QTY_ON_HAND_WIP
  • SP_V_SCHEDULED_DELIVERY_PLAN_RSCH
  • SP_V_SCHEDULED_PRODUCTION
  • SP_V_SCHEDULED_PRODUCTION_PLAN_RSCH
  • SP_V_SCHEDULED_RECEIPTS_PLAN_RSCH
  • SP_V_SCHEDULED_RELEASED_PRODUCTION
  • SP_V_SCHEDULED_RELEASED_PRODUCTION_PLAN_RSCH
  • SP_V_SCHEDULED_SHIFTED_PRODUCTION
  • SP_V_SCHEDULED_SHIFTED_PRODUCTION_PLAN_RSCH
  • SP_V_SCHEDULED_SHIPMENTS_PLAN_RSCH
  • SP_V_SUPPLIER_ALLOCATIONS
  • SP_V_TRANSFERS
These interface services are updated:
  • SP - SCV - SCO - Import In Transit Inventory - Fixed Shipments
  • SP - SCV - SCO - Import In Transit Inventory - Firm Shipments
  • SP - SCV - SCO - Import In Transit Inventory - Scheduled Shipments
  • SP - SCV - SCO - Import In Transit Inventory - Fixed Receipts
  • SP - SCV - SCO - Import In Transit Inventory - Firm Receipts
  • SP - SCV - SCO - Import In Transit Inventory - Scheduled Receipts
  • SP - SCV - SCO - Import Locked Deliveries - Fixed
  • SP - SCV - SCO - Import Locked Deliveries - Firm
  • SP - SCV - SCO - Import Locked Deliveries - Scheduled
Note: The related content is available after loading the Base template (base.zip) and the Planning Engine SP SCO template (apsco.zip) for this release. You are not required to have a new role or privilege access to use this feature.