P_ProcOrdOperationWithStatus

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_ProcOrdOperationWithStatus.
-- 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: PPOROPWITHSTS

CREATE VIEW P_ProcOrdOperationWithStatus AS
SELECT
  cast(afvg.ManufacturingOrderOperation as pph_vornr preserving type) AS ManufacturingOrderOperation,
  cast(afvg.ManufacturingOrderSubOperation as pph_uvorn preserving type) AS ManufacturingOrderSubOperation,
  cast(_OpWorkCenter.WorkCenter as pph_arbpl preserving type) AS WorkCenter,
  _OpWorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  afvg. OverlapMinimumDurationUnit AS OverlapMinimumDurationUnit,
  cast(afvg.OpWorkQuantityUnit1 as vdm_ile01 preserving type) AS OpWorkQuantityUnit1,
  cast(afvg.OpConfirmedWorkQuantity1 as vdm_ism01 preserving type) AS OpConfirmedWorkQuantity1,
  cast(afvg.OpWorkQuantityUnit2 as vdm_ile02 preserving type) AS OpWorkQuantityUnit2,
  cast(afvg.OpConfirmedWorkQuantity2 as vdm_ism02 preserving type) AS OpConfirmedWorkQuantity2,
  cast(afvg.OpWorkQuantityUnit3 as vdm_ile03 preserving type) AS OpWorkQuantityUnit3,
  cast(afvg.OpConfirmedWorkQuantity3 as vdm_ism03 preserving type) AS OpConfirmedWorkQuantity3,
  cast(afvg.OpWorkQuantityUnit4 as vdm_ile04 preserving type) AS OpWorkQuantityUnit4,
  cast(afvg.OpConfirmedWorkQuantity4 as vdm_ism04 preserving type) AS OpConfirmedWorkQuantity4,
  cast(afvg.OpWorkQuantityUnit5 as vdm_ile05 preserving type) AS OpWorkQuantityUnit5,
  cast(afvg.OpConfirmedWorkQuantity5 as vdm_ism05 preserving type) AS OpConfirmedWorkQuantity5,
  cast(afvg.OpWorkQuantityUnit6 as vdm_ile06 preserving type) AS OpWorkQuantityUnit6,
  cast(afvg.OpConfirmedWorkQuantity6 as vdm_ism06 preserving type) AS OpConfirmedWorkQuantity6,
  cast(afvg.WorkCenterStandardWorkQtyUnit1 as pph_vge01 preserving type) AS WorkCenterStandardWorkQtyUnit1,
  cast(afvg.WorkCenterStandardWorkQty1 as vdm_vgw01 preserving type) AS WorkCenterStandardWorkQty1,
  cast(afvg.CostCtrActivityType1 as vdm_lar01 preserving type) AS CostCtrActivityType1,
  cast(afvg.WorkCenterStandardWorkQtyUnit2 as pph_vge02 preserving type) AS WorkCenterStandardWorkQtyUnit2,
  cast(afvg.WorkCenterStandardWorkQty2 as vdm_vgw02 preserving type) AS WorkCenterStandardWorkQty2,
  cast(afvg.CostCtrActivityType2 as vdm_lar02 preserving type) AS CostCtrActivityType2,
  cast(afvg.WorkCenterStandardWorkQtyUnit3 as pph_vge03 preserving type) AS WorkCenterStandardWorkQtyUnit3,
  cast(afvg.WorkCenterStandardWorkQty3 as vdm_vgw03 preserving type) AS WorkCenterStandardWorkQty3,
  cast(afvg.CostCtrActivityType3 as vdm_lar03 preserving type) AS CostCtrActivityType3,
  cast(afvg.WorkCenterStandardWorkQtyUnit4 as pph_vge04 preserving type) AS WorkCenterStandardWorkQtyUnit4,
  cast(afvg.WorkCenterStandardWorkQty4 as vdm_vgw04 preserving type) AS WorkCenterStandardWorkQty4,
  cast(afvg.CostCtrActivityType4 as vdm_lar04 preserving type) AS CostCtrActivityType4,
  cast(afvg.WorkCenterStandardWorkQtyUnit5 as pph_vge05 preserving type) AS WorkCenterStandardWorkQtyUnit5,
  cast(afvg.WorkCenterStandardWorkQty5 as vdm_vgw05 preserving type) AS WorkCenterStandardWorkQty5,
  cast(afvg.CostCtrActivityType5 as vdm_lar05 preserving type) AS CostCtrActivityType5,
  cast(afvg.WorkCenterStandardWorkQtyUnit6 as pph_vge06 preserving type) AS WorkCenterStandardWorkQtyUnit6,
  cast(afvg.WorkCenterStandardWorkQty6 as vdm_vgw06 preserving type) AS WorkCenterStandardWorkQty6,
  cast(afvg.CostCtrActivityType6 as vdm_lar06 preserving type) AS CostCtrActivityType6,
  OrderIntBillOfOpItemOfPhase,
  ConfirmationIsNotPossible,
  Material,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ProcessOrderHasNoLongText,
  OperationControlProfileName,
  ProductionPlantName,
  ProductionSupervisorName,
  MRPControllerName,
  ManufacturingOrderTypeName,
  PlantTimeZone,
  afvg.MfgOrderInternalID AS MfgOrderInternalID,
  afvg.OrderOperationInternalID AS OrderOperationInternalID,
  afvg.ManufacturingOrder AS ManufacturingOrder,
  afvg.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  afvg.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  afvg.ManufacturingOrderType AS ManufacturingOrderType,
  afvg.ProductionPlant AS ProductionPlant,
  afvg.ProductionSupervisor AS ProductionSupervisor,
  afvg.MRPController AS MRPController,
  afvg.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  afvg.ProductConfiguration AS ProductConfiguration,
  afvg.InspectionLot AS InspectionLot,
  afvg.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  afvg.MfgOrderOperationText AS MfgOrderOperationText,
  afvg.OperationHasLongText AS OperationHasLongText,
  afvg.Language AS LongTextLanguageCode,
  afvg.OperationStandardTextCode AS OperationStandardTextCode,
  afvg.OperationIsToBeDeleted AS OperationIsToBeDeleted,
  afvg.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  afvg.MfgOrderPhaseSuperiorOperation AS MfgOrderPhaseSuperiorOperation,
  afvg.NumberOfCapacities AS NumberOfCapacities,
  afvg.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  afvg.OperationImportance AS OperationImportance,
  afvg.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  afvg.Plant AS Plant,
  afvg.WorkCenterInternalID AS WorkCenterInternalID,
  afvg.WorkCenterTypeCode AS WorkCenterTypeCode,
  afvg.OperationControlProfile AS OperationControlProfile,
  afvg.ControlRecipeDestination AS ControlRecipeDestination,
  afvg.OperationConfirmation AS OperationConfirmation,
  afvg.NumberOfOperationConfirmations AS NumberOfOperationConfirmations,
  afvg.FactoryCalendar AS FactoryCalendar,
  afvg.CapacityRequirement AS CapacityRequirement,
  afvg.CapacityRequirementItem AS CapacityRequirementItem,
  afvg.ChangeNumber AS ChangeNumber,
  afvg.ObjectInternalID AS ObjectInternalID,
  afvg.OperationTrackingNumber AS OperationTrackingNumber,
  afvg.BillOfOperationsType AS BillOfOperationsType,
  afvg.BillOfOperationsGroup AS BillOfOperationsGroup,
  afvg.BillOfOperationsVariant AS BillOfOperationsVariant,
  afvg.BillOfOperationsSequence AS BillOfOperationsSequence,
  afvg.BOOOperationInternalID AS BOOOperationInternalID,
  afvg.BillOfOperationsVersion AS BillOfOperationsVersion,
  afvg.BillOfMaterialCategory AS BillOfMaterialCategory,
  afvg.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  afvg.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  afvg.BOMItemNodeCount AS BOMItemNodeCount,
  afvg.ExtProcgOperationHasSubcontrg AS ExtProcgOperationHasSubcontrg,
  afvg.PurchasingOrganization AS PurchasingOrganization,
  afvg.PurchasingGroup AS PurchasingGroup,
  afvg.PurgInfoRecdDataIsFixed AS PurgInfoRecdDataIsFixed,
  afvg.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  afvg.Supplier AS Supplier,
  afvg.GoodsRecipientName AS GoodsRecipientName,
  afvg.UnloadingPointName AS UnloadingPointName,
  afvg.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  afvg.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  afvg.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  afvg.CompanyCode AS CompanyCode,
  afvg.BusinessArea AS BusinessArea,
  afvg.ControllingArea AS ControllingArea,
  afvg.CostElement AS CostElement,
  afvg.CostingVariant AS CostingVariant,
  afvg.CostingSheet AS CostingSheet,
  afvg.CostEstimate AS CostEstimate,
  afvg.ControllingObjectCurrency AS ControllingObjectCurrency,
  afvg.ControllingObjectClass AS ControllingObjectClass,
  afvg.FunctionalArea AS FunctionalArea,
  afvg.TaxJurisdiction AS TaxJurisdiction,
  afvg.EmployeeWageType AS EmployeeWageType,
  afvg.EmployeeWageGroup AS EmployeeWageGroup,
  afvg.EmployeeSuitability AS EmployeeSuitability,
  afvg.NumberOfTimeTickets AS NumberOfTimeTickets,
  afvg.Personnel AS Personnel,
  afvg.NumberOfEmployees AS NumberOfEmployees,
  afvg.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  afvg.OperationSetupGroup AS OperationSetupGroup,
  afvg.OperationSetupType AS OperationSetupType,
  afvg.OperationOverlappingIsRequired AS OperationOverlappingIsRequired,
  afvg.OperationOverlappingIsPossible AS OperationOverlappingIsPossible,
  afvg.OperationsIsAlwaysOverlapping AS OperationsIsAlwaysOverlapping,
  afvg.OperationSplitIsRequired AS OperationSplitIsRequired,
  afvg.MaximumNumberOfSplits AS MaximumNumberOfSplits,
  afvg.LeadTimeReductionStrategy AS LeadTimeReductionStrategy,
  afvg.OpSchedldReductionLevel AS OpSchedldReductionLevel,
  afvg.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  afvg.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  afvg.OpErlstSchedldProcgStrtDte AS OpErlstSchedldProcgStrtDte,
  afvg.OpErlstSchedldProcgStrtTme AS OpErlstSchedldProcgStrtTme,
  afvg.OpErlstSchedldTrdwnStrtDte AS OpErlstSchedldTrdwnStrtDte,
  afvg.OpErlstSchedldTrdwnStrtTme AS OpErlstSchedldTrdwnStrtTme,
  afvg.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  afvg.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  afvg.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  afvg.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  afvg.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  afvg.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  afvg.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  afvg.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  afvg.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  afvg.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  afvg.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  afvg.SchedldFcstdEarliestStartTime AS SchedldFcstdEarliestStartTime,
  afvg.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  afvg.SchedldFcstdEarliestEndTime AS SchedldFcstdEarliestEndTime,
  afvg.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  afvg.SchedldFcstdLatestStartTime AS SchedldFcstdLatestStartTime,
  afvg.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  afvg.SchedldFcstdLatestEndTime AS SchedldFcstdLatestEndTime,
  afvg.OperationConfirmedStartDate AS OperationConfirmedStartDate,
  afvg.OperationConfirmedEndDate AS OperationConfirmedEndDate,
  afvg.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  afvg.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  afvg.OpActualSetupEndDate AS OpActualSetupEndDate,
  afvg.OpActualSetupEndTime AS OpActualSetupEndTime,
  afvg.OpActualProcessingStartDate AS OpActualProcessingStartDate,
  afvg.OpActualProcessingStartTime AS OpActualProcessingStartTime,
  afvg.OpActualProcessingEndDate AS OpActualProcessingEndDate,
  afvg.OpActualProcessingEndTime AS OpActualProcessingEndTime,
  afvg.OpActualTeardownStartDate AS OpActualTeardownStartDate,
  afvg.OpActualTeardownStartTme AS OpActualTeardownStartTme,
  afvg.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  afvg.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  afvg.EarliestScheduledWaitStartDate AS EarliestScheduledWaitStartDate,
  afvg.EarliestScheduledWaitStartTime AS EarliestScheduledWaitStartTime,
  afvg.EarliestScheduledWaitEndDate AS EarliestScheduledWaitEndDate,
  afvg.EarliestScheduledWaitEndTime AS EarliestScheduledWaitEndTime,
  afvg.LatestScheduledWaitStartDate AS LatestScheduledWaitStartDate,
  afvg.LatestScheduledWaitStartTime AS LatestScheduledWaitStartTime,
  afvg.LatestScheduledWaitEndDate AS LatestScheduledWaitEndDate,
  afvg.LatestScheduledWaitEndTime AS LatestScheduledWaitEndTime,
  afvg.BreakDurationUnit AS BreakDurationUnit,
  afvg.PlannedBreakDuration AS PlannedBreakDuration,
  afvg.ConfirmedBreakDuration AS ConfirmedBreakDuration,
  afvg.OverlapMinimumDuration AS OverlapMinimumDuration,
  afvg.MaximumWaitDurationUnit AS MaximumWaitDurationUnit,
  afvg.MaximumWaitDuration AS MaximumWaitDuration,
  afvg.MinimumWaitDurationUnit AS MinimumWaitDurationUnit,
  afvg.MinimumWaitDuration AS MinimumWaitDuration,
  afvg.StandardMoveDurationUnit AS StandardMoveDurationUnit,
  afvg.StandardMoveDuration AS StandardMoveDuration,
  afvg.StandardQueueDurationUnit AS StandardQueueDurationUnit,
  afvg.StandardQueueDuration AS StandardQueueDuration,
  afvg.MinimumQueueDurationUnit AS MinimumQueueDurationUnit,
  afvg.MinimumQueueDuration AS MinimumQueueDuration,
  afvg.MinimumMoveDurationUnit AS MinimumMoveDurationUnit,
  afvg.MinimumMoveDuration AS MinimumMoveDuration,
  afvg.OperationStandardDuration AS OperationStandardDuration,
  afvg.OperationStandardDurationUnit AS OperationStandardDurationUnit,
  afvg.MinimumDuration AS MinimumDuration,
  afvg.MinimumDurationUnit AS MinimumDurationUnit,
  afvg.ScheduledMoveDuration AS ScheduledMoveDuration,
  afvg.ScheduledMoveDurationUnit AS ScheduledMoveDurationUnit,
  afvg.ScheduledQueueDuration AS ScheduledQueueDuration,
  afvg.ScheduledQueueDurationUnit AS ScheduledQueueDurationUnit,
  afvg.ScheduledWaitDuration AS ScheduledWaitDuration,
  afvg.ScheduledWaitDurationUnit AS ScheduledWaitDurationUnit,
  afvg.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  afvg.OpPlannedSetupDurn AS OpPlannedSetupDurn,
  afvg.OpPlannedSetupDurnUnit AS OpPlannedSetupDurnUnit,
  afvg.OpPlannedProcessingDurn AS OpPlannedProcessingDurn,
  afvg.OpPlannedProcessingDurnUnit AS OpPlannedProcessingDurnUnit,
  afvg.OpPlannedTeardownDurn AS OpPlannedTeardownDurn,
  afvg.OpPlannedTeardownDurnUnit AS OpPlannedTeardownDurnUnit,
  afvg.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  afvg.StartDateOffsetDuration AS StartDateOffsetDuration,
  afvg.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  afvg.EndDateOffsetDuration AS EndDateOffsetDuration,
  afvg.StandardWorkFormulaParamGroup AS StandardWorkFormulaParamGroup,
  afvg.OperationUnit AS OperationUnit,
  afvg.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  afvg.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  afvg.OperationScrapPercent AS OperationScrapPercent,
  afvg.OperationReferenceQuantity AS OperationReferenceQuantity,
  afvg.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  afvg.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  afvg.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  afvg.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  afvg.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  afvg.OperationConfirmedReworkQty AS OperationConfirmedReworkQty,
  afvg.ProductionUnit AS ProductionUnit,
  afvg.OpTotConfdYieldQtyInOrdQtyUnit AS OpTotConfdYieldQtyInOrdQtyUnit,
  afvg.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  afvg.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  afvg.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  afvg.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  afvg.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  afvg.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
  afvg.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  afvg.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  afvg.NoFurtherBusinessProcQtyIsExpd AS NoFurtherBusinessProcQtyIsExpd,
  afvg.BusinessProcRemainingQtyUnit AS BusinessProcRemainingQtyUnit,
  afvg.BusinessProcessRemainingQty AS BusinessProcessRemainingQty,
  afvg.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  afvg.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  afvg.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  afvg.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  afvg.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  afvg.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  afvg.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  afvg.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  afvg.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  afvg.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  afvg.FreeDefinedAmount1 AS FreeDefinedAmount1,
  afvg.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  afvg.FreeDefinedAmount2 AS FreeDefinedAmount2,
  afvg.FreeDefinedDate1 AS FreeDefinedDate1,
  afvg.FreeDefinedDate2 AS FreeDefinedDate2,
  afvg.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  afvg.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  _systemStatus.OperationIsCreated AS OperationIsCreated,
  _systemStatus.OperationIsReleased AS OperationIsReleased,
  _systemStatus.OperationIsPrinted AS OperationIsPrinted,
  _systemStatus.OperationIsConfirmed AS OperationIsConfirmed,
  _systemStatus.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
  _systemStatus.OperationIsPartiallyDelivered AS OperationIsPartiallyDelivered,
  _systemStatus.OperationIsDelivered AS OperationIsDelivered,
  _systemStatus.OperationIsDeleted AS OperationIsDeleted,
  _systemStatus.OperationIsTechlyCompleted AS OperationIsTechlyCompleted,
  _systemStatus.OperationIsClosed AS OperationIsClosed,
  _systemStatus.OperationIsScheduled AS OperationIsScheduled,
  _systemStatus.OperationIsInterrupted AS OperationIsInterrupted,
  _systemStatus.ProcOrdConfIsAtHeader AS ProcOrdConfIsAtHeader,
  _AllCapacity.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  _MfgOrderSequence.MfgOrderSequenceCategory AS MfgOrderSequenceCategory,
  _OpWorkCenter.CapacityInternalID AS CapacityInternalID
FROM P_ProcOrderOperationDurn AS afvg
INNER JOIN P_ProcOrdOpSystemStatusAggr AS _systemStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkCenterAllCapacity AS _AllCapacity ON WorkCenterInternalID = _AllCapacity.WorkCenterInternalID AND WorkCenterTypeCode = _AllCapacity.WorkCenterTypeCode AND CapacityInternalID = _AllCapacity.CapacityInternalID  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
;