Use new SCV Plan Entities

The SP_V_* views have been updated to read from imported data tables (instead of published plan tables) to align with the Order Loop introduced in SCP 20.7. In addition, all plans published to SCV are now saved in the new plan tables.

These existing views have been updated to remove the Not Exists check on the corresponding PLAN_RSCH table:

  • SP_V_FIRM_RELEASED_PRODUCTION
  • SP_V_FIRM_DELIVERY
  • SP_V_FIRM_SHIPMENTS
  • SP_V_FIRM_RECEIPTS
  • SP_V_FIRM_PRODUCTION
  • SP_V_FIRM_SHIFTED_PRODUCTION

These existing views have been updated to add a false condition to guarantee that no records are selected:

  • SP_V_SCHEDULED_RELEASED_PRODUCTION
  • SP_V_SCHEDULED_DELIVERY
  • SP_V_SCHEDULED_SHIPMENTS
  • SP_V_SCHEDULED_RECEIPTS
  • SP_V_SCHEDULED_PRODUCTION
  • SP_V_SCHEDULED_SHIFTED_PRODUCTION

These existing views have been updated to switch the main table to the corresponding PLND_TRX imported data table to select imported firm planned orders:

  • SP_V_FIXED_DELIVERY
  • SP_V_FIXED_SHIPMENTS
  • SP_V_FIXED_RECEIPTS
  • SP_V_FIXED_PRODUCTION
  • SP_V_FIXED_SHIFTED_PRODUCTION

These new views have been added where the query is a copy of the corresponding original FIXED/SCHEDULED view:

  • SP_V_FIXED_DELIVERY_PLAN_FXD
  • SP_V_FIXED_RECEIPTS_PLAN_FXD
  • SP_V_FIXED_SHIPMENTS_PLAN_FXD
  • SP_V_FIXED_PRODUCTION_PLAN_FXD
  • SP_V_FIXED_SHIFTED_PRODUCTION_PLAN_FXD
  • SP_V_SCHEDULED_RELEASED_PRODUCTION_PLAN_RSCH
  • SP_V_SCHEDULED_DELIVERY_PLAN_RSCH
  • SP_V_SCHEDULED_SHIPMENTS_PLAN_RSCH
  • SP_V_SCHEDULED_RECEIPTS_PLAN_RSCH
  • SP_V_SCHEDULED_PRODUCTION_PLAN_RSCH
  • SP_V_SCHEDULED_SHIFTED_PRODUCTION_PLAN_RSCH

These existing SCO interfaces have been updated to export plan results into the new SCV plan tables:

  • 600 - Export Suppliers Allocations Plan SCV: Now exporting to SC_PURCHASE_PLAN.
  • 610 - Export Transfers Plan SCV: Now exporting to SC_TRANSFER_PLAN.
  • 620 - Export Processes Plan SCV: Now exporting to SC_PRODUCTION_PLAN.
Note: This feature is enabled after appending the base template (base.zip) for this version and upgrading the SCO model to this version. You do not require to do anything to enable this feature.