I_ProcOrdMgmtOpPhase

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_ProcOrdMgmtOpPhase.
-- 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: IPROCORDMGMTPHS

CREATE VIEW I_ProcOrdMgmtOpPhase AS
SELECT
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  ManufacturingOrder AS ProcessOrder,
  ManufacturingOrderType,
  ManufacturingOrderCategory,
  ProductionPlant,
  ProductionSupervisor,
  ManufacturingOrderOperation,
  OperationText,
  ManufacturingOrderSubOperation,
  MfgOrderOperationText,
  ManufacturingOrderSequence,
  MfgOrderOperationIsPhase,
  MfgOrderPhaseSuperiorOperation,
  OrderIntBillOfOpItemOfPhase AS OrderOperationInternalID,
  ProcOrdOpStatusCode,
  ProcOrdOpStatusText,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  _WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  ProcOrdOpSchedldStartDateTime,
  OpLtstSchedldExecEndDte,
  OpLtstSchedldExecEndTme,
  ProcOrdOpSchedldEndDateTime,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  ProcOrdOpActualStartDateTime,
  OpActualExecutionEndDate,
  OpActualExecutionEndTime,
  ProcOrdOpActualEndDateTime,
  OperationExecutionStartIsLate,
  OperationExecutionEndIsLate,
  DIVISION(TSTMP_SECONDS_BETWEEN(ProcOrdOpSchedldStartDateTime, ProcOrdOpSchedldEndDateTime, 'INITIAL'), 3600, 2) AS PlannedDuration,
  DIVISION(TSTMP_SECONDS_BETWEEN(ProcOrdOpActualStartDateTime, ProcOrdOpActualEndDateTime, 'INITIAL'), 3600, 2) AS ActualDuration,
  OperationUnit,
  OpPlannedTotalQuantity,
  OpTotalConfirmedYieldQty,
  OpPlannedYieldQuantity,
  MfgOrderActualStartDateCritlty,
  MfgOrdActualEndDateCriticality,
  OperationIsInterrupted,
  OrderIntBillOfOpItemOfPhase,
  _ConfDetails.VarianceReasonCode AS VarianceReasonCode,
  _ConfDetails.VarianceReasonName AS VarianceReasonName,
  _ConfDetails.ConfirmedDateTime AS ConfirmedDateTime
FROM I_ProcOrdMgmtOperationCalc
LEFT OUTER JOIN P_ProcOrdOpLatestConf AS _ConfDetails ON OrderInternalBillOfOperations = _ConfDetails.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _ConfDetails.OrderIntBillOfOperationsItem  -- association [0..1]
LEFT OUTER JOIN E_ProcessOrderOperation AS _Extension ON OrderInternalBillOfOperations = _Extension.OrderInternalID AND OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID  -- association [1..1]
;