C_ProcessOrderPopOver

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_ProcessOrderPopOver.
-- 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.

CREATE VIEW C_ProcessOrderPopOver AS
SELECT
  ManufacturingOrder,
  ManufacturingOrderItem,
  mfgorder.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  mfgorder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  mfgorder.ProductionPlant AS ProductionPlant,
  mfgorder.Material AS Material,
  MaterialName,
  _StatusText.StatusName AS StatusName,
  ProductionMilestoneStatus,
  mfgorder.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  ManufacturingOrderType,
  ManufacturingOrderTypeName,
  mfgorder.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  mfgorder.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  mfgorder.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  mfgorder.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  mfgorder.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  mfgorder.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  mfgorder.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  mfgorder.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  mfgorder.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  mfgorder.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  MaterialGoodsReceiptDuration,
  ProductionUnit,
  MfgOrderItemProductionUnit,
  _ProdItemUnitBaseUnit.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _ProdItemUnitBaseUnit.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  _ProdItemUnitBaseUnit._Text[1: Language = $session.system_language ].UnitOfMeasureCommercialName AS UnitOfMeasureCommercialName,
  MfgOrderPlannedTotalQty,
  MfgOrderItemPlannedTotalQty,
  MfgOrderPlannedScrapQty,
  MfgOrderItemPlannedScrapQty,
  ActualDeliveredQuantity,
  MfgOrderItemGoodsReceiptQty,
  ExpectedDeviationQuantity,
  cast(OpenQuantity as abap.quan(13, 3)) AS OpenQuantity,
  ProductionVersion,
  ProductionVersionText,
  ProductionLine,
  WorkCenterText,
  case _ProdnOrdMaterialMissing.MaterialComponentIsMissing when 'X' then _ProdnOrdMissingMaterial.MissingMaterial else '' end as MissingMaterial AS MissingMaterialelseendasMissingMaterial,
  cast(_ProdnOrdMaterialMissing.MaterialComponentIsMissing as xfehl preserving type) AS MaterialComponentIsMissing,
  OrderExecutionStartIsLate,
  OrderExecutionEndIsLate,
  mfgorder.MRPPlant AS MRPPlant,
  MRPController,
  MRPControllerName,
  ProductionSupervisor,
  ProductionSupervisorName,
  case when OrderStatus = 'I0012' or OrderStatus = 'I0076' then '' else _CurOp.CurOperation end as CurOperation AS CurOperationendasCurOperation,
  case when OrderStatus = 'I0012' or OrderStatus = 'I0076' then '' else _CurOp.CurOperationText end as CurOperationText AS CurOperationTextendasCurOperationText,
  case when OrderStatus = 'I0012' or OrderStatus = 'I0076' then cast('' as abap.unit) else _CurOp.CurOperationUnit end as CurOperationUnit AS CurOperationUnitendasCurOperationUnit,
  case when OrderStatus = 'I0012' or OrderStatus = 'I0076' then _CurOp.CurOperationQty * 0 else _CurOp.CurOperationQty end as CurOperationQty AS CurOperationQtyendasCurOperationQty,
  case when OrderStatus = 'I0012' or OrderStatus = 'I0076' then '' else _NextOp.NextOperation end as NextOperation AS NextOperationendasNextOperation,
  case when OrderStatus = 'I0012' or OrderStatus = 'I0076' then '' else _NextOp.NextOperationText end as NextOperationText AS NextOperationTextendasNextOperationText,
  case when OrderStatus = 'I0012' or OrderStatus = 'I0076' then cast('' as abap.unit) else _NextOp.NextOperationUnit end as NextOperationUnit AS NextOperationUnitendasNextOperationUnit,
  case when OrderStatus = 'I0012' or OrderStatus = 'I0076' then _NextOp.NextOperationQty * 0 else _NextOp.NextOperationQty end as NextOperationQty AS NextOperationQtyendasNextOperationQty,
  LeadingMfgOrderMaterial,
  LeadingMfgOrderMaterialName,
  mfgorder.LeadingOrder AS LeadingOrder,
  SoldToParty,
  CustomerName,
  AuthorizationGroup,
  cast(WBSElement as abap.char( 24 ) ) AS WBSElement,
  WBSDescription,
  ProjectResponsiblePerson,
  ProjectResponsiblePersonName,
  cast(Project as abap.char( 24 ) ) AS Project,
  ProjectDescription,
  case when mfgorder.InspectionLot != '000000000000' then mfgorder.InspectionLot else null end as InspectionLot AS InspectionLotelsenullendasInspectionLot,
  cast(LastChangeDateTime as vdm_lastchangedon ) AS LastChangeDateTime,
  mfgorder._MRPController AS _MRPController
FROM P_MPEProcOrderItemPover AS mfgorder
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionLine AS _ProductionLine ON ProductionPlant = _ProductionLine.Plant AND ProductionLine = _ProductionLine.ProductionLine  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN P_MPEProdnOrdMatlIsMissing AS _ProdnOrdMaterialMissing ON OrderInternalBillOfOperations = _ProdnOrdMaterialMissing.OrderInternalBillOfOperations AND ManufacturingOrder = _ProdnOrdMaterialMissing.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_MPEProdnOrdMissingMatl AS _ProdnOrdMissingMaterial ON OrderInternalBillOfOperations = _ProdnOrdMissingMaterial.OrderInternalBillOfOperations AND ManufacturingOrder = _ProdnOrdMissingMaterial.ManufacturingOrder AND _ProdnOrdMissingMaterial.ManufacturingOrderCategory = '40'  -- association [0..1]
LEFT OUTER JOIN P_MPEProdnOrdCurOpData AS _CurOp ON OrderInternalBillOfOperations = _CurOp.OrderInternalBillOfOperations AND ManufacturingOrder = _CurOp.OrderID  -- association [1..1]
LEFT OUTER JOIN P_MPEProdnOrdNextOpData AS _NextOp ON OrderInternalBillOfOperations = _NextOp.OrderInternalBillOfOperations AND ManufacturingOrder = _NextOp.OrderID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProdItemUnitBaseUnit ON MfgOrderItemProductionUnit = _ProdItemUnitBaseUnit.UnitOfMeasure  -- association [1..1]
;