C_ProcessOrderObjPg

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProcessOrderObjPg.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPRSORDOBJPG

CREATE VIEW C_ProcessOrderObjPg AS
SELECT
  ManufacturingOrder AS ProcessOrder,
  ManufacturingOrder,
  ManufacturingOrder AS OrderID,
  ProductionPlant,
  MfgOrderInternalID AS OrderInternalBillOfOperations,
  Material,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ProductionUnit,
  MfgOrderPlannedTotalQty AS TotalQuantity,
  ManufacturingOrderType,
  MRPArea,
  ManufacturingObject,
  PlanningPlant AS Plant,
  MfgOrderConfirmedYieldQty,
  MfgOrderPlannedStartDate,
  MfgOrderPlannedStartTime,
  MfgOrderPlannedEndDate,
  MfgOrderPlannedEndTime,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledStartTime,
  MfgOrderScheduledEndDate,
  MfgOrderScheduledEndTime,
  cast(_PlantProdOrder._StandardOrganizationAddress.AddressTimeZone as co_plant_timezone ) AS AddressTimeZone,
  ProductionVersion,
  SalesOrder,
  SalesOrderItem,
  _PlannedOrder._Customer.CustomerName AS CustomerName,
  PlannedOrder,
  cast( _WBSElement.WBSElement as rcpe_ps_posnr preserving type ) AS WBSElement,
  WBSElementInternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  CompanyCode,
  FunctionalArea,
  PlannedCostsCostingVariant,
  _PlannedCostingVariant._Text[1: Language=$session.system_language].CostingVariantName AS CostingVariantName,
  ActualCostsCostingVariant,
  _ActualCostingVariant._Text[1: Language=$session.system_language].CostingVariantName AS TargetCostVariantName,
  cast(OrderIsEventBasedPosting as mpe_ebpost) AS OrderIsEventBasedPosting,
  _MRPController.UserID AS UserID,
  MRPController,
  ProductionSupervisor,
  ManufacturingOrderCategory
FROM I_MfgOrderWithStatus
LEFT OUTER JOIN C_ProcessOrderObjPgOpr AS _MfgOrderOperations ON ProcessOrder = _MfgOrderOperations.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN C_MfgOrderObjPgComp AS _MfgOrderComponents ON ProcessOrder = _MfgOrderComponents.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN C_ProcessOrderObjPgItem AS _MfgOrderItems ON ProcessOrder = _MfgOrderItems.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN C_MfgOrderObjPgContacts AS _MfgOrderContactDetails ON ProcessOrder = _MfgOrderContactDetails.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderObjPgStatus AS _MfgOrderSystemStatus ON ProcessOrder = _MfgOrderSystemStatus.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN I_CostingVariant AS _PlannedCostingVariant ON PlannedCostsCostingVariant = _PlannedCostingVariant.CostingVariant  -- association [1..1]
LEFT OUTER JOIN I_CostingVariant AS _ActualCostingVariant ON ActualCostsCostingVariant = _ActualCostingVariant.CostingVariant  -- association [1..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0001 ON _StatusTextI0001.SystemStatus = 'I0001' AND _StatusTextI0001.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0002 ON _StatusTextI0002.SystemStatus = 'I0002' AND _StatusTextI0002.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0009 ON _StatusTextI0009.SystemStatus = 'I0009' AND _StatusTextI0009.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0010 ON _StatusTextI0010.SystemStatus = 'I0010' AND _StatusTextI0010.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0012 ON _StatusTextI0012.SystemStatus = 'I0012' AND _StatusTextI0012.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0013 ON _StatusTextI0013.SystemStatus = 'I0013' AND _StatusTextI0013.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0016 ON _StatusTextI0016.SystemStatus = 'I0016' AND _StatusTextI0016.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0028 ON _StatusTextI0028.SystemStatus = 'I0028' AND _StatusTextI0028.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0042 ON _StatusTextI0042.SystemStatus = 'I0042' AND _StatusTextI0042.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0045 ON _StatusTextI0045.SystemStatus = 'I0045' AND _StatusTextI0045.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0046 ON _StatusTextI0046.SystemStatus = 'I0046' AND _StatusTextI0046.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SystemStatusText AS _StatusTextI0076 ON _StatusTextI0076.SystemStatus = 'I0076' AND _StatusTextI0076.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _PlantProdOrder ON Plant = _PlantProdOrder.Plant  -- association [1..1]
;