I_ProcOrdOpsMgmtAllOperations

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 I_ProcOrdOpsMgmtAllOperations.
-- 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: IPRCORDOPALLOPS

CREATE VIEW I_ProcOrdOpsMgmtAllOperations AS
SELECT
  _Operation.MfgOrderInternalID AS OrderInternalBillOfOperations,
  _Operation.OrderOperationInternalID AS OrderOperationInternalID,
  _RelatedOperation.OrderOperationInternalID AS OrderIntBillOfOperationsItem,
  _RelatedOperation.ManufacturingOrder AS ProcessOrder,
  cast(_RelatedOperation.ManufacturingOrderOperation as text4 preserving type ) AS OperationText,
  _RelatedOperation.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  _RelatedOperation.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  _RelatedOperation.ManufacturingOrderType AS ManufacturingOrderType,
  _RelatedOperation.ProductionPlant AS ProductionPlant,
  _RelatedOperation.ProductionSupervisor AS ProductionSupervisor,
  _RelatedOperation.MRPController AS MRPController,
  _OpPhaseCount.TotNmbrOfProcOrdOpConfdPhases AS TotNmbrOfProcOrdOpConfdPhases,
  _OpPhaseCount.TotNmbrOfProcOrdOpPhases AS TotNmbrOfProcOrdOpPhases,
  '000' AS ProcOrdOpProgressPercent,
  0 AS NmbrOfInterruptedProcOrdPhases,
  _RelatedOperation.OperationIsInterrupted AS OperationIsInterrupted,
  _RelatedOperation.WorkCenterInternalID AS WorkCenterInternalID,
  _RelatedOperation.WorkCenter AS WorkCenter,
  _RelatedOperation.WorkCenterText AS WorkCenterText,
  _RelatedOperation.OperationUnit AS OperationUnit,
  _RelatedOperation.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  _RelatedOperation.Material AS Material,
  _RelatedOperation.MaterialName AS MaterialName,
  _RelatedOperation.ProcOrdOpSchedldStartDateTime AS ProcOrdOpSchedldStartDateTime,
  _RelatedOperation.ProcOrdOpSchedldEndDateTime AS ProcOrdOpSchedldEndDateTime,
  _RelatedOperation.ProcOrdOpActualStartDateTime AS ProcOrdOpActualStartDateTime,
  _RelatedOperation.ProcOrdOpActualEndDateTime AS ProcOrdOpActualEndDateTime,
  _RelatedOperation.PlannedActualStartDateDvtnDurn AS PlannedActualStartDateDvtnDurn,
  _RelatedOperation.PlannedCurrentStrtDateDvtnDurn AS PlannedCurrentStrtDateDvtnDurn,
  _RelatedOperation.PlannedActualEndDateDvtnDurn AS PlannedActualEndDateDvtnDurn,
  _RelatedOperation.PlannedCurrentEndDateDvtnDurn AS PlannedCurrentEndDateDvtnDurn,
  _RelatedOperation.OperationIsConfirmed AS OperationIsConfirmed,
  coalesce(_OpCompIss.ProcOrdOpCompAvailyStatusCode,'04') AS ProcOrdOpCompAvailyStatusCode,
  _RelatedOperation.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  afpo.StockSegment AS StockSegment
FROM P_ProcOrdOperationWithStatus AS _Operation
INNER JOIN P_ProcOrdOperationWithStatus AS _RelatedOperation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_NmbrOfProcOrdOpValidPhases AS _OpPhaseCount ON OrderInternalBillOfOperations = _OpPhaseCount.MfgOrderInternalID AND OrderIntBillOfOperationsItem = _OpPhaseCount.OrderIntBillOfOperationsItem AND ProcessOrder = _OpPhaseCount.ProcessOrder AND ProductionPlant = _OpPhaseCount.ProductionPlant AND ProductionSupervisor = _OpPhaseCount.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN P_ProcOrdOpCompIssAggrgn AS _OpCompIss ON OrderInternalBillOfOperations = _OpCompIss.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _OpCompIss.OrderIntBillOfOperationsItem AND ProcessOrder = _OpCompIss.ProcessOrder AND ProductionPlant = _OpCompIss.ProductionPlant AND ProductionSupervisor = _OpCompIss.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN P_ProcOrdOpScrapIssAggrgn AS _OpScrapIss ON OrderInternalBillOfOperations = _OpScrapIss.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _OpScrapIss.OrderIntBillOfOpItemOfPhase AND ProcessOrder = _OpScrapIss.ProcessOrder AND ProductionPlant = _OpScrapIss.ProductionPlant AND ProductionSupervisor = _OpScrapIss.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN P_ProcOrdOpInspLotIssuesAggrgn AS _OpInspLotsIss ON OrderInternalBillOfOperations = _OpInspLotsIss.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _OpInspLotsIss.OrderIntBillOfOpItemOfPhase AND ProcessOrder = _OpInspLotsIss.ProcessOrder AND ProductionPlant = _OpInspLotsIss.ProductionPlant AND ProductionSupervisor = _OpInspLotsIss.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_OrderItem AS afpo ON ProcessOrder = afpo.OrderID AND afpo.OrderItem = '0001'  -- association [1..1]
LEFT OUTER JOIN E_ProcessOrderOperation AS _Extension ON OrderInternalBillOfOperations = _Extension.OrderInternalID AND OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID  -- association [1..1]
;