P_MfgOrderOperationDelay

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_MfgOrderOperationDelay.
-- 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: PMFGORERDOPDELAY

CREATE VIEW P_MfgOrderOperationDelay AS
SELECT
  afvg.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  afvg.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  afvg.ManufacturingOrder AS ManufacturingOrder,
  afvg.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  afvg.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  afvg.ManufacturingOrderSubOperation AS ManufacturingOrderSubOperation,
  afvg.MfgOrderOperationOrSubOp AS MfgOrderOperationOrSubOp,
  afvg.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  afvg.ManufacturingOrderType AS ManufacturingOrderType,
  afvg.ProductionSupervisor AS ProductionSupervisor,
  afvg.MRPController AS MRPController,
  afvg.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  afvg.ProductConfiguration AS ProductConfiguration,
  afvg.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  afvg.InspectionLot AS InspectionLot,
  afvg.MfgOrderOperationText AS MfgOrderOperationText,
  afvg.Language AS Language,
  afvg.OperationStandardTextCode AS OperationStandardTextCode,
  afvg.OperationHasLongText AS OperationHasLongText,
  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.ProductionPlant AS ProductionPlant,
  afvg.WorkCenterInternalID AS WorkCenterInternalID,
  afvg.WorkCenterTypeCode AS WorkCenterTypeCode,
  afvg.WorkCenterTypeCode_2 AS WorkCenterTypeCode_2,
  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.ManufacturingObject AS ManufacturingObject,
  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.PurchaseRequisition AS PurchaseRequisition,
  afvg.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  afvg.PurchaseOrder AS PurchaseOrder,
  afvg.PurchaseOrderItem AS PurchaseOrderItem,
  afvg.PurchasingInfoRecord AS PurchasingInfoRecord,
  afvg.PurgInfoRecdDataIsFixed AS PurgInfoRecdDataIsFixed,
  afvg.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  afvg.OpExternalProcessingPriceUnit AS OpExternalProcessingPriceUnit,
  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.ProfitCenter AS ProfitCenter,
  afvg.RequestingCostCenter AS RequestingCostCenter,
  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.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.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.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,
  cast(afvg.OverlapMinimumDurationUnit as pph_dzeimu preserving type) AS OverlapMinimumDurationUnit,
  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.MinimumProcessingDuration AS MinimumProcessingDuration,
  afvg.MinimumProcessingDurationUnit AS MinimumProcessingDurationUnit,
  afvg.ScheduledMoveDuration AS ScheduledMoveDuration,
  afvg.ScheduledMoveDurationUnit AS ScheduledMoveDurationUnit,
  afvg.ScheduledQueueDuration AS ScheduledQueueDuration,
  afvg.ScheduledQueueDurationUnit AS ScheduledQueueDurationUnit,
  afvg.ScheduledWaitDuration AS ScheduledWaitDuration,
  afvg.ScheduledWaitDurationUnit AS ScheduledWaitDurationUnit,
  cast(afvg.PlannedDeliveryDuration as pph_plifz preserving type) AS PlannedDeliveryDuration,
  afvg.OpPlannedSetupDurn AS OpPlannedSetupDurn,
  afvg.OpPlannedSetupDurnUnit AS OpPlannedSetupDurnUnit,
  afvg.OpPlannedProcessingDurn AS OpPlannedProcessingDurn,
  cast(afvg.OpPlannedProcessingDurnUnit as pph_beaze preserving type) AS OpPlannedProcessingDurnUnit,
  afvg.OpPlannedTeardownDurn AS OpPlannedTeardownDurn,
  afvg.OpPlannedTeardownDurnUnit AS OpPlannedTeardownDurnUnit,
  afvg.StartDateOffsetReferenceCode AS StartDateOffsetReferenceCode,
  afvg.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  afvg.StartDateOffsetDuration AS StartDateOffsetDuration,
  afvg.EndDateOffsetReferenceCode AS EndDateOffsetReferenceCode,
  afvg.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  afvg.EndDateOffsetDuration AS EndDateOffsetDuration,
  cast(afvg.OperationUnit as operationunit preserving type) 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.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
  afvg.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
  afvg.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  afvg.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
  afvg.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
  afvg.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  afvg.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
  afvg.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
  afvg.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  afvg.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
  afvg.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
  afvg.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  afvg.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
  afvg.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
  afvg.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  afvg.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
  afvg.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
  afvg.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
  afvg.WorkCenterStandardWorkQtyUnit1 AS WorkCenterStandardWorkQtyUnit1,
  afvg.WorkCenterStandardWorkQty1 AS WorkCenterStandardWorkQty1,
  afvg.CostCtrActivityType1 AS CostCtrActivityType1,
  afvg.WorkCenterStandardWorkQtyUnit2 AS WorkCenterStandardWorkQtyUnit2,
  afvg.WorkCenterStandardWorkQty2 AS WorkCenterStandardWorkQty2,
  afvg.CostCtrActivityType2 AS CostCtrActivityType2,
  afvg.WorkCenterStandardWorkQtyUnit3 AS WorkCenterStandardWorkQtyUnit3,
  afvg.WorkCenterStandardWorkQty3 AS WorkCenterStandardWorkQty3,
  afvg.CostCtrActivityType3 AS CostCtrActivityType3,
  afvg.WorkCenterStandardWorkQtyUnit4 AS WorkCenterStandardWorkQtyUnit4,
  afvg.WorkCenterStandardWorkQty4 AS WorkCenterStandardWorkQty4,
  afvg.CostCtrActivityType4 AS CostCtrActivityType4,
  afvg.WorkCenterStandardWorkQtyUnit5 AS WorkCenterStandardWorkQtyUnit5,
  afvg.WorkCenterStandardWorkQty5 AS WorkCenterStandardWorkQty5,
  afvg.CostCtrActivityType5 AS CostCtrActivityType5,
  afvg.WorkCenterStandardWorkQtyUnit6 AS WorkCenterStandardWorkQtyUnit6,
  afvg.WorkCenterStandardWorkQty6 AS WorkCenterStandardWorkQty6,
  afvg.CostCtrActivityType6 AS CostCtrActivityType6,
  afvg.BusinessProcess AS BusinessProcess,
  afvg.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  afvg.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  afvg.NoFurtherBusinessProcQtyIsExpd AS NoFurtherBusinessProcQtyIsExpd,
  afvg.BusinessProcRemainingQtyUnit AS BusinessProcRemainingQtyUnit,
  afvg.BusinessProcessRemainingQty AS BusinessProcessRemainingQty,
  afvg.SetupOpActyNtwkInstance AS SetupOpActyNtwkInstance,
  afvg.ProduceOpActyNtwkInstance AS ProduceOpActyNtwkInstance,
  afvg.TeardownOpActyNtwkInstance AS TeardownOpActyNtwkInstance,
  afvg.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  afvg.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  afvg.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  afvg.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  afvg.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  afvg.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  afvg.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  afvg.FreeDefinedAmount1 AS FreeDefinedAmount1,
  afvg.FreeDefinedAmount2 AS FreeDefinedAmount2,
  afvg.FreeDefinedDate1 AS FreeDefinedDate1,
  afvg.FreeDefinedDate2 AS FreeDefinedDate2,
  afvg.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  afvg.FreeDefinedIndicator2 AS FreeDefinedIndicator2
FROM I_MfgOrderOperation AS afvg
;