C_MPEProdnOrderPover

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_MPEProdnOrderPover.
-- 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_MPEProdnOrderPover AS
SELECT
  ManufacturingOrder,
  ManufacturingOrderItem,
  mfgorder.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  mfgorder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  mfgorder.ProductionPlant AS ProductionPlant,
  mfgorder.Material AS Material,
  MaterialName,
  mfgorder._StatusText.StatusName AS StatusName,
  ProductionMilestoneStatus,
  mfgorder.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  ManufacturingOrderType,
  ManufacturingOrderTypeName,
  mfgorder.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  mfgorder.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  mfgorder.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  mfgorder.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  mfgorder.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  mfgorder.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  mfgorder.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  mfgorder.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  mfgorder.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  mfgorder.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  MaterialGoodsReceiptDuration,
  mfgorder.ProductionUnit AS ProductionUnit,
  MfgOrderItemProductionUnit,
  _ProdItemUnitBaseUnit.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _ProdItemUnitBaseUnit.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  _ProdItemUnitBaseUnit._Text[1: Language = $session.system_language ].UnitOfMeasureCommercialName AS UnitOfMeasureCommercialName,
  mfgorder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  MfgOrderItemPlannedTotalQty,
  MfgOrderPlannedScrapQty,
  MfgOrderItemPlannedScrapQty,
  ActualDeliveredQuantity,
  MfgOrderItemGoodsReceiptQty,
  ExpectedDeviationQuantity,
  cast(OpenQuantity as abap.quan(13, 3)) AS OpenQuantity,
  ProductionVersion,
  ProductionVersionText,
  Plant,
  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( 0 as abap.quan(13,3) ) 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 cast( 0 as abap.quan(13,3) ) else _NextOp.NextOperationQty end as NextOperationQty AS NextOperationQtyendasNextOperationQty,
  LeadingMfgOrderMaterial,
  LeadingMfgOrderMaterialName,
  mfgorder.LeadingOrder AS LeadingOrder,
  cast(SDDocument as vbeln_va preserving type) AS SDDocument,
  cast(SDDocumentItem as abap.int4 ) AS SDDocumentItem,
  SDDocumentCategory,
  SDDocumentCategoryName,
  SoldToParty,
  CustomerName,
  AuthorizationGroup,
  WBSElement,
  WBSDescription,
  ProjectResponsiblePerson,
  ProjectResponsiblePersonName,
  Project,
  ProjectDescription,
  cast(LastChangeDateTime as vdm_lastchangedon ) AS LastChangeDateTime,
  mfgorder._MRPController AS _MRPController
FROM P_MPEProdnOrderItemPover AS mfgorder
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductionLine AS _ProductionLine ON Plant = _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 = '10'  -- 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]
;