C_MPEProdnOrderOperationPover

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_MPEProdnOrderOperationPover.
-- 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_MPEProdnOrderOperationPover AS
SELECT
  Oper.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  Oper.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  Oper.ManufacturingOrder AS ManufacturingOrder,
  Oper.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  Oper.ManufacturingOrderType AS ManufacturingOrderType,
  Oper.ProductionPlant AS ProductionPlant,
  Oper.MfgOrderOperationText AS MfgOrderOperationText,
  Oper.Material AS Material,
  Oper.MaterialName AS MaterialName,
  Oper.WorkCenter AS WorkCenter,
  Oper.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  Oper.OperationUnit AS OperationUnit,
  Oper.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  Oper.StatusName AS StatusName,
  Oper.ProductionMilestoneStatus AS ProductionMilestoneStatus,
  Oper.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  Oper.NumberOfMissingMatlComp AS NumberOfMissingMatlComp,
  Oper.MissingMaterial AS MissingMaterial,
  Oper.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  case when Oper.InspectionLot != '000000000000' then Oper.InspectionLot else cast('' as abap.numc(12)) end as InspectionLot AS numc12endasInspectionLot,
  Oper.OperationExecutionStartIsLate AS OperationExecutionStartIsLate,
  Oper.OperationExecutionEndIsLate AS OperationExecutionEndIsLate,
  Oper.ProductionSupervisor AS ProductionSupervisor,
  Oper.ProductionSupervisorName AS ProductionSupervisorName,
  Oper.WorkCenterResponsible AS WorkCenterResponsible,
  Oper.WorkCenterResponsibleName AS WorkCenterResponsibleName,
  Oper.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  Oper.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  Oper.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  Oper.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  Oper.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  Oper.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  Oper.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  Oper.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  Oper.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  Oper.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  Oper.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  Oper.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  Oper.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  Oper.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  Oper.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  Oper.OperationConfirmedReworkQty AS OperationConfirmedReworkQty,
  Oper.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  Oper.ProductionUnit AS ProductionUnit,
  Oper.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  cast (Oper.OpenQuantity as openquan) AS OpenQuantity,
  Oper.LeadingOrder AS LeadingOrder,
  case when Oper.LocSDDocumentCategory = 'C' or Oper._SalesDocument.SalesDocument is null then case when Oper.LocSalesDocument is null then Oper.ReferenceSDDocument else Oper.LocSalesDocument end else Oper._SalesDocument.SalesDocument end as SDDocument AS SalesDocumentendasSDDocument,
  cast (case when Oper.LocSDDocumentCategory = 'C' or Oper._SalesDocument.SalesDocument is null then Oper.LocSalesDocumentItem else Oper._SalesDocumentItem.SalesDocumentItem end as abap.int4 ) as SDDocumentItem AS int4asSDDocumentItem,
  Oper.SoldToParty AS SoldToParty,
  Oper.CustomerName AS CustomerName,
  Oper.AuthorizationGroup AS AuthorizationGroup,
  Oper.WBSElement AS WBSElement,
  Oper.WBSDescription AS WBSDescription,
  _Project.Project AS Project,
  _Project.ProjectDescription AS ProjectDescription,
  Oper.WorkCenterInternalID AS WorkCenterInternalID,
  Oper.WorkCenterTypeCode AS WorkCenterTypeCode
FROM P_MPEProdnOrderOperationPover AS Oper
LEFT OUTER JOIN E_OrderOperation AS _Extension ON Oper.OrderInternalBillOfOperations = _Extension.OrderInternalID AND Oper.OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID  -- association [1..1]
;