I_MfgOrderOperationWithStatus

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_MfgOrderOperationWithStatus.
-- 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: IMFGORDOPWITHSTS

CREATE VIEW I_MfgOrderOperationWithStatus AS
SELECT
  afvg.MfgOrderInternalID AS MfgOrderInternalID,
  afvg.OrderOperationInternalID AS OrderOperationInternalID,
  afvg.ManufacturingOrder AS ManufacturingOrder,
  afvg.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  cast(afvg.ManufacturingOrderOperation as pph_vornr preserving type) AS ManufacturingOrderOperation,
  afvg.ManufacturingOrderOperation_2 AS ManufacturingOrderOperation_2,
  cast(afvg.ManufacturingOrderSubOperation as pph_uvorn preserving type) AS ManufacturingOrderSubOperation,
  afvg.ManufacturingOrdSubOperation_2 AS ManufacturingOrdSubOperation_2,
  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.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.SuperiorOperation_2 AS SuperiorOperation_2,
  afvg.NumberOfCapacities AS NumberOfCapacities,
  afvg.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  afvg.OperationImportance AS OperationImportance,
  stat.OperationIsCreated AS OperationIsCreated,
  stat.OperationIsReleased AS OperationIsReleased,
  stat.OperationIsPrinted AS OperationIsPrinted,
  stat.OperationIsConfirmed AS OperationIsConfirmed,
  stat.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
  stat.OperationIsDeleted AS OperationIsDeleted,
  stat.OperationIsTechlyCompleted AS OperationIsTechlyCompleted,
  stat.OperationIsClosed AS OperationIsClosed,
  cast(stat.OperationIsConfdByMilestone as isconfirmedbymilestone preserving type) AS OperationIsConfdByMilestone,
  cast(stat.OperationIsManuallyConfirmed as isconfirmedmanually preserving type) AS OperationIsManuallyConfirmed,
  stat.OperationIsScheduled AS OperationIsScheduled,
  cast(stat.OperationIsGenerated as operationisgenerated preserving type) AS OperationIsGenerated,
  stat.OperationIsPartiallyDelivered AS OperationIsPartiallyDelivered,
  stat.OperationIsDelivered AS OperationIsDelivered,
  cast(stat.ControlRecipeIsCreated as controlrecipeiscreated preserving type) AS ControlRecipeIsCreated,
  afvg.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  afvg.Plant AS Plant,
  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.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.BillOfMaterialInternalID_2 AS BillOfMaterialInternalID_2,
  afvg.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  afvg.BOMItemNodeCount AS BOMItemNodeCount,
  afvg.ExtProcgOperationHasSubcontrg AS ExtProcgOperationHasSubcontrg,
  afvg.PurchasingOrganization AS PurchasingOrganization,
  afvg.PurchasingGroup AS PurchasingGroup,
  afvg.PurchaseOrder AS PurchaseOrder,
  afvg.PurchaseOrderItem AS PurchaseOrderItem,
  afvg.PurchaseOutlineAgreement AS PurchaseOutlineAgreement,
  afvg.PurchaseOutlineAgreementItem AS PurchaseOutlineAgreementItem,
  afvg.PurchasingInfoRecord AS PurchasingInfoRecord,
  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.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.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.OverlapMinimumDurationUnit 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.OperationStandardDurationUnit AS OperationStandardDurationUnit,
  afvg.OperationStandardDuration AS OperationStandardDuration,
  afvg.MinimumDurationUnit AS MinimumDurationUnit,
  afvg.MinimumDuration AS MinimumDuration,
  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,
  cast(afvg.OpWorkQuantityUnit1 as vdm_ile01 preserving type) AS OpWorkQuantityUnit1,
  cast(afvg.OpConfirmedWorkQuantity1 as vdm_ism01 preserving type) AS OpConfirmedWorkQuantity1,
  afvg.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  cast(afvg.OpWorkQuantityUnit2 as vdm_ile02 preserving type) AS OpWorkQuantityUnit2,
  cast(afvg.OpConfirmedWorkQuantity2 as vdm_ism02 preserving type) AS OpConfirmedWorkQuantity2,
  afvg.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  cast(afvg.OpWorkQuantityUnit3 as vdm_ile03 preserving type) AS OpWorkQuantityUnit3,
  cast(afvg.OpConfirmedWorkQuantity3 as vdm_ism03 preserving type) AS OpConfirmedWorkQuantity3,
  afvg.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  cast(afvg.OpWorkQuantityUnit4 as vdm_ile04 preserving type) AS OpWorkQuantityUnit4,
  cast(afvg.OpConfirmedWorkQuantity4 as vdm_ism04 preserving type) AS OpConfirmedWorkQuantity4,
  afvg.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  cast(afvg.OpWorkQuantityUnit5 as vdm_ile05 preserving type) AS OpWorkQuantityUnit5,
  cast(afvg.OpConfirmedWorkQuantity5 as vdm_ism05 preserving type) AS OpConfirmedWorkQuantity5,
  afvg.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  cast(afvg.OpWorkQuantityUnit6 as vdm_ile06 preserving type) AS OpWorkQuantityUnit6,
  cast(afvg.OpConfirmedWorkQuantity6 as vdm_ism06 preserving type) AS OpConfirmedWorkQuantity6,
  afvg.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
  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
FROM I_ManufacturingOrderOperation AS afvg
INNER JOIN P_OrderOperationStatusBasicAgg AS stat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_OrderOperation AS _Extension ON MfgOrderInternalID = _Extension.OrderInternalID AND OrderOperationInternalID = _Extension.OrderOperationInternalID  -- association [1..1]
;