P_ProcOrdMgmtOperationCalc

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 P_ProcOrdMgmtOperationCalc.
-- 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: PPROCORDOPCALC

CREATE VIEW P_ProcOrdMgmtOperationCalc AS
SELECT
  MfgOrderInternalID AS OrderInternalBillOfOperations,
  OrderOperationInternalID AS OrderIntBillOfOperationsItem,
  ManufacturingOrder,
  ManufacturingOrder AS ProcessOrder,
  ManufacturingOrderSequence,
  ManufacturingOrderOperation,
  cast(ManufacturingOrderOperation as text4 preserving type ) AS OperationText,
  ManufacturingOrderSubOperation,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ProductionPlant,
  ProductionSupervisor,
  MRPController,
  ResponsiblePlannerGroup,
  ProductConfiguration,
  InspectionLot,
  ManufacturingOrderImportance,
  MfgOrderOperationText,
  OperationHasLongText,
  LongTextLanguageCode,
  OperationStandardTextCode,
  OperationIsToBeDeleted,
  MfgOrderOperationIsPhase,
  MfgOrderPhaseSuperiorOperation,
  ObjectInternalID,
  OperationImportance,
  OperationIsCreated,
  OperationIsReleased,
  OperationIsPrinted,
  OperationIsConfirmed,
  OperationIsPartiallyConfirmed,
  OperationIsDeleted,
  OperationIsTechlyCompleted,
  OperationIsClosed,
  OperationIsScheduled,
  OperationIsPartiallyDelivered,
  OperationIsDelivered,
  OperationIsInterrupted,
  SuperiorOperationInternalID,
  Plant,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  WorkCenterText,
  CapacityInternalID,
  CapacityCategoryAllocation,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecStrtTme,
  OpErlstSchedldExecEndDte,
  OpErlstSchedldExecEndTme,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  OpLtstSchedldExecEndDte,
  OpLtstSchedldExecEndTme,
  OperationConfirmedStartDate,
  OperationConfirmedEndDate,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  OpActualExecutionEndDate,
  OpActualExecutionEndTime,
  ProcOrdOpSchedldStartDateTime,
  ProcOrdOpSchedldEndDateTime,
  ProcOrdOpActualStartDateTime,
  ProcOrdOpActualEndDateTime,
  OpActualProcessingStartDteTme,
  OpActualProcessingEndDateTime,
  PlannedCurrentStrtDateDvtnDurn,
  PlannedCurrentEndDateDvtnDurn,
  PlannedActualStartDateDvtnDurn,
  PlannedActualEndDateDvtnDurn,
  OperationUnit,
  OpPlannedTotalQuantity,
  OpPlannedScrapQuantity,
  OpPlannedYieldQuantity,
  OpTotalConfirmedYieldQty,
  OpTotalConfirmedScrapQty,
  OperationConfirmedReworkQty,
  ProductionUnit,
  tstmp_seconds_between(ProcOrdOpSchedldStartDateTime, ProcOrdOpSchedldEndDateTime, 'INITIAL') AS OpPlannedProcessingDurn,
  OrderIntBillOfOpItemOfPhase,
  OperationReferenceQuantity,
  OpQtyToBaseQtyNmrtr,
  OperationControlProfile,
  StandardWorkFormulaParamGroup,
  cast(WorkCenterStandardWorkQtyUnit1 as pph_vge01 preserving type) AS WorkCenterStandardWorkQtyUnit1,
  cast(WorkCenterStandardWorkQty1 as vdm_vgw01 preserving type) AS WorkCenterStandardWorkQty1,
  cast(CostCtrActivityType1 as vdm_lar01 preserving type) AS CostCtrActivityType1,
  cast(WorkCenterStandardWorkQtyUnit2 as pph_vge02 preserving type) AS WorkCenterStandardWorkQtyUnit2,
  cast(WorkCenterStandardWorkQty2 as vdm_vgw02 preserving type) AS WorkCenterStandardWorkQty2,
  cast(CostCtrActivityType2 as vdm_lar02 preserving type) AS CostCtrActivityType2,
  cast(WorkCenterStandardWorkQtyUnit3 as pph_vge03 preserving type) AS WorkCenterStandardWorkQtyUnit3,
  cast(WorkCenterStandardWorkQty3 as vdm_vgw03 preserving type) AS WorkCenterStandardWorkQty3,
  cast(CostCtrActivityType3 as vdm_lar03 preserving type) AS CostCtrActivityType3,
  cast(WorkCenterStandardWorkQtyUnit4 as pph_vge04 preserving type) AS WorkCenterStandardWorkQtyUnit4,
  cast(WorkCenterStandardWorkQty4 as vdm_vgw04 preserving type) AS WorkCenterStandardWorkQty4,
  cast(CostCtrActivityType4 as vdm_lar04 preserving type) AS CostCtrActivityType4,
  cast(WorkCenterStandardWorkQtyUnit5 as pph_vge05 preserving type) AS WorkCenterStandardWorkQtyUnit5,
  cast(WorkCenterStandardWorkQty5 as vdm_vgw05 preserving type) AS WorkCenterStandardWorkQty5,
  cast(CostCtrActivityType5 as vdm_lar05 preserving type) AS CostCtrActivityType5,
  cast(WorkCenterStandardWorkQtyUnit6 as pph_vge06 preserving type) AS WorkCenterStandardWorkQtyUnit6,
  cast(WorkCenterStandardWorkQty6 as vdm_vgw06 preserving type) AS WorkCenterStandardWorkQty6,
  cast(CostCtrActivityType6 as vdm_lar06 preserving type) AS CostCtrActivityType6,
  OpWorkQuantityUnit1,
  OpWorkQuantityUnit2,
  OpWorkQuantityUnit3,
  OpWorkQuantityUnit4,
  OpWorkQuantityUnit5,
  OpWorkQuantityUnit6,
  OpConfirmedWorkQuantity1,
  OpConfirmedWorkQuantity2,
  OpConfirmedWorkQuantity3,
  OpConfirmedWorkQuantity4,
  OpConfirmedWorkQuantity5,
  OpConfirmedWorkQuantity6,
  ConfirmationIsNotPossible,
  Material,
  MaterialName,
  ProcOrdConfIsAtHeader,
  $session.system_date AS TodayDate,
  ProcessOrderHasNoLongText,
  OperationControlProfileName,
  ProductionPlantName,
  ProductionSupervisorName,
  MRPControllerName,
  ManufacturingOrderTypeName,
  afpo.StockSegment AS StockSegment,
  PlantTimeZone,
  ScheduledBasicStartDate,
  ScheduledBasicEndDate
FROM P_ProcOrdOperationWithStatus
LEFT OUTER JOIN I_OrderItem AS afpo ON ProcessOrder = afpo.OrderID AND afpo.OrderItem = '0001'  -- association [1..1]
;