I_MfgOrderOperationCube

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_MfgOrderOperationCube.
-- 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: IPPMFGORDEROPC

CREATE VIEW I_MfgOrderOperationCube AS
SELECT
  oper.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  oper.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  oper.ManufacturingOrder AS ManufacturingOrder,
  oper.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  oper.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  oper.ManufacturingOrderSubOperation AS ManufacturingOrderSubOperation,
  oper.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  oper.ManufacturingOrderType AS ManufacturingOrderType,
  oper.ProductionSupervisor AS ProductionSupervisor,
  oper.MRPController AS MRPController,
  oper.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  oper.ProductConfiguration AS ProductConfiguration,
  oper.MfgOrderOperationText AS MfgOrderOperationText,
  oper.OperationHasLongText AS OperationHasLongText,
  oper.Language AS Language,
  oper.OperationStandardTextCode AS OperationStandardTextCode,
  oper.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  oper.MfgOrderPhaseSuperiorOperation AS MfgOrderPhaseSuperiorOperation,
  oper.NumberOfCapacities AS NumberOfCapacities,
  oper.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  oper.NumberOfOperationConfirmations AS NumberOfOperationConfirmations,
  oper.OperationImportance AS OperationImportance,
  oper.ManufacturingObject AS ObjectInternalID,
  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,
  stat.OperationIsScheduled AS OperationIsScheduled,
  stat.OperationIsPartiallyDelivered AS OperationIsPartiallyDelivered,
  stat.OperationIsDelivered AS OperationIsDelivered,
  oper.ProductionPlant AS ProductionPlant,
  oper.WorkCenterInternalID AS WorkCenterInternalID,
  oper.WorkCenterTypeCode_2 AS WorkCenterTypeCode,
  cast(oper._WorkCenter_2.WorkCenter as pph_arbpl preserving type) AS WorkCenter,
  oper.OperationControlProfile AS OperationControlProfile,
  oper.BillOfOperationsType AS BillOfOperationsType,
  oper.BillOfOperationsGroup AS BillOfOperationsGroup,
  oper.BillOfOperationsVariant AS BillOfOperationsVariant,
  oper.BillOfOperationsSequence AS BillOfOperationsSequence,
  oper.BillOfOperationsVersion AS BillOfOperationsVersion,
  oper.BOOOperationInternalID AS BOOOperationInternalID,
  oper.OperationConfirmation AS OperationConfirmation,
  oper.CapacityRequirement AS CapacityRequirement,
  oper.CapacityRequirementItem AS CapacityRequirementItem,
  oper.PurchasingOrganization AS PurchasingOrganization,
  oper.PurchasingGroup AS PurchasingGroup,
  oper.PurgInfoRecdDataIsFixed AS PurgInfoRecdDataIsFixed,
  oper.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  oper.OpExternalProcessingCurrency AS OpExternalProcessingCurrency,
  oper.OpExternalProcessingPrice AS OpExternalProcessingPrice,
  oper.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  oper.CompanyCode AS CompanyCode,
  oper.BusinessArea AS BusinessArea,
  oper.ControllingArea AS ControllingArea,
  oper.ProfitCenter AS ProfitCenter,
  oper.RequestingCostCenter AS RequestingCostCenter,
  oper.CostElement AS CostElement,
  oper.CostingVariant AS CostingVariant,
  oper.CostingSheet AS CostingSheet,
  oper.CostEstimate AS CostEstimate,
  oper.ControllingObjectClass AS ControllingObjectClass,
  oper.FunctionalArea AS FunctionalArea,
  oper.TaxJurisdiction AS TaxJurisdiction,
  oper.EmployeeWageType AS EmployeeWageType,
  oper.EmployeeWageGroup AS EmployeeWageGroup,
  oper.EmployeeSuitability AS EmployeeSuitability,
  oper.NumberOfTimeTickets AS NumberOfTimeTickets,
  oper.NumberOfEmployees AS NumberOfEmployees,
  oper.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  oper.OperationSetupGroup AS OperationSetupGroup,
  oper.OperationSetupType AS OperationSetupType,
  oper.OperationOverlappingIsRequired AS OperationOverlappingIsRequired,
  oper.OperationOverlappingIsPossible AS OperationOverlappingIsPossible,
  oper.OperationsIsAlwaysOverlapping AS OperationsIsAlwaysOverlapping,
  oper.OperationSplitIsRequired AS OperationSplitIsRequired,
  oper.MaximumNumberOfSplits AS MaximumNumberOfSplits,
  oper.LeadTimeReductionStrategy AS LeadTimeReductionStrategy,
  oper.OpSchedldReductionLevel AS OpSchedldReductionLevel,
  oper.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  oper.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  oper.OpErlstSchedldProcgStrtDte AS OpErlstSchedldProcgStrtDte,
  oper.OpErlstSchedldProcgStrtTme AS OpErlstSchedldProcgStrtTme,
  oper.OpErlstSchedldTrdwnStrtDte AS OpErlstSchedldTrdwnStrtDte,
  oper.OpErlstSchedldTrdwnStrtTme AS OpErlstSchedldTrdwnStrtTme,
  oper.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  oper.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  oper.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  oper.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  oper.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  oper.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  oper.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  oper.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  oper.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  oper.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  oper.OperationConfirmedStartDate AS OperationConfirmedStartDate,
  oper.OperationConfirmedEndDate AS OperationConfirmedEndDate,
  oper.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  oper.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  oper.OpActualSetupEndDate AS OpActualSetupEndDate,
  oper.OpActualSetupEndTime AS OpActualSetupEndTime,
  oper.OpActualProcessingStartDate AS OpActualProcessingStartDate,
  oper.OpActualProcessingStartTime AS OpActualProcessingStartTime,
  oper.OpActualProcessingEndDate AS OpActualProcessingEndDate,
  oper.OpActualProcessingEndTime AS OpActualProcessingEndTime,
  oper.OpActualTeardownStartDate AS OpActualTeardownStartDate,
  oper.OpActualTeardownStartTme AS OpActualTeardownStartTme,
  oper.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  oper.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  oper.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  oper.SchedldFcstdEarliestStartTime AS SchedldFcstdEarliestStartTime,
  oper.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  oper.SchedldFcstdEarliestEndTime AS SchedldFcstdEarliestEndTime,
  oper.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  oper.SchedldFcstdLatestStartTime AS SchedldFcstdLatestStartTime,
  oper.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  oper.SchedldFcstdLatestEndTime AS SchedldFcstdLatestEndTime,
  oper.EarliestScheduledWaitStartDate AS EarliestScheduledWaitStartDate,
  oper.EarliestScheduledWaitStartTime AS EarliestScheduledWaitStartTime,
  oper.EarliestScheduledWaitEndDate AS EarliestScheduledWaitEndDate,
  oper.EarliestScheduledWaitEndTime AS EarliestScheduledWaitEndTime,
  oper.LatestScheduledWaitStartDate AS LatestScheduledWaitStartDate,
  oper.LatestScheduledWaitStartTime AS LatestScheduledWaitStartTime,
  oper.LatestScheduledWaitEndDate AS LatestScheduledWaitEndDate,
  oper.LatestScheduledWaitEndTime AS LatestScheduledWaitEndTime,
  cast('S' as durationunit) AS DurationUnit,
  ddis.ActualWorkdayDurnInSeconds AS ActualWorkdayDurnInSeconds,
  ddis.PlannedWorkdayDurnInSeconds AS PlannedWorkdayDurnInSeconds,
  ddis.DeviationDurationInSeconds AS DeviationWorkdayDurnInSeconds,
  oper.PlannedActualStartDateDvtnDurn AS PlannedActualStartDateDvtnDurn,
  oper.PlannedActualEndDateDvtnDurn AS PlannedActualEndDateDvtnDurn,
  oper.PlannedCurrentStrtDateDvtnDurn AS PlannedCurrentStrtDateDvtnDurn,
  oper.PlannedCurrentEndDateDvtnDurn AS PlannedCurrentEndDateDvtnDurn,
  cast('STD' as durationunithour) AS HoursUnitOfMeasure,
  oper.StartDateOffsetReferenceCode AS StartDateOffsetReferenceCode,
  oper.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  oper.StartDateOffsetDuration AS StartDateOffsetDuration,
  oper.EndDateOffsetReferenceCode AS EndDateOffsetReferenceCode,
  oper.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  oper.EndDateOffsetDuration AS EndDateOffsetDuration,
  oper.OperationUnit AS OperationUnit,
  oper.OperationReferenceQuantity AS OperationReferenceQuantity,
  oper.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  oper.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  oper.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  oper.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  oper.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  oper.OperationConfirmedReworkQty AS OperationConfirmedReworkQty,
  oper.ProductionUnit AS ProductionUnit,
  oper.OpTotConfdYieldQtyInOrdQtyUnit AS OpTotConfdYieldQtyInOrdQtyUnit,
  oper.OpWorkQuantityUnit1 AS OpWorkQuantityUnit1,
  oper.OpConfirmedWorkQuantity1 AS OpConfirmedWorkQuantity1,
  oper.NoFurtherOpWorkQuantity1IsExpd AS NoFurtherOpWorkQuantity1IsExpd,
  oper.OpWorkQuantityUnit2 AS OpWorkQuantityUnit2,
  oper.OpConfirmedWorkQuantity2 AS OpConfirmedWorkQuantity2,
  oper.NoFurtherOpWorkQuantity2IsExpd AS NoFurtherOpWorkQuantity2IsExpd,
  oper.OpWorkQuantityUnit3 AS OpWorkQuantityUnit3,
  oper.OpConfirmedWorkQuantity3 AS OpConfirmedWorkQuantity3,
  oper.NoFurtherOpWorkQuantity3IsExpd AS NoFurtherOpWorkQuantity3IsExpd,
  oper.OpWorkQuantityUnit4 AS OpWorkQuantityUnit4,
  oper.OpConfirmedWorkQuantity4 AS OpConfirmedWorkQuantity4,
  oper.NoFurtherOpWorkQuantity4IsExpd AS NoFurtherOpWorkQuantity4IsExpd,
  oper.OpWorkQuantityUnit5 AS OpWorkQuantityUnit5,
  oper.OpConfirmedWorkQuantity5 AS OpConfirmedWorkQuantity5,
  oper.NoFurtherOpWorkQuantity5IsExpd AS NoFurtherOpWorkQuantity5IsExpd,
  oper.OpWorkQuantityUnit6 AS OpWorkQuantityUnit6,
  oper.OpConfirmedWorkQuantity6 AS OpConfirmedWorkQuantity6,
  oper.NoFurtherOpWorkQuantity6IsExpd AS NoFurtherOpWorkQuantity6IsExpd,
  oper.WorkCenterStandardWorkQtyUnit1 AS WorkCenterStandardWorkQtyUnit1,
  oper.WorkCenterStandardWorkQty1 AS WorkCenterStandardWorkQty1,
  oper.CostCtrActivityType1 AS CostCtrActivityType1,
  oper.WorkCenterStandardWorkQtyUnit2 AS WorkCenterStandardWorkQtyUnit2,
  oper.WorkCenterStandardWorkQty2 AS WorkCenterStandardWorkQty2,
  oper.CostCtrActivityType2 AS CostCtrActivityType2,
  oper.WorkCenterStandardWorkQtyUnit3 AS WorkCenterStandardWorkQtyUnit3,
  oper.WorkCenterStandardWorkQty3 AS WorkCenterStandardWorkQty3,
  oper.CostCtrActivityType3 AS CostCtrActivityType3,
  oper.WorkCenterStandardWorkQtyUnit4 AS WorkCenterStandardWorkQtyUnit4,
  oper.WorkCenterStandardWorkQty4 AS WorkCenterStandardWorkQty4,
  oper.CostCtrActivityType4 AS CostCtrActivityType4,
  oper.WorkCenterStandardWorkQtyUnit5 AS WorkCenterStandardWorkQtyUnit5,
  oper.WorkCenterStandardWorkQty5 AS WorkCenterStandardWorkQty5,
  oper.CostCtrActivityType5 AS CostCtrActivityType5,
  oper.WorkCenterStandardWorkQtyUnit6 AS WorkCenterStandardWorkQtyUnit6,
  oper.WorkCenterStandardWorkQty6 AS WorkCenterStandardWorkQty6,
  oper.CostCtrActivityType6 AS CostCtrActivityType6,
  oper.BusinessProcess AS BusinessProcess,
  oper.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  oper.BusinessProcessConfirmedQty AS BusinessProcessConfirmedQty,
  oper.NoFurtherBusinessProcQtyIsExpd AS NoFurtherBusinessProcQtyIsExpd,
  oper._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  oper._MfgOrder AS _MfgOrder,
  oper._MfgOrderSequence AS _MfgOrderSequence,
  oper._MfgOrderCategory AS _MfgOrderCategory,
  oper._MfgOrderType AS _MfgOrderType,
  oper._OperationStandardTextCode AS _OperationStandardTextCode,
  oper._ProductionPlant AS _ProductionPlant,
  oper._ProductionSupervisor AS _ProductionSupervisor,
  oper._ProductionUnit AS _ProductionUnit,
  oper._OperationUnit AS _OperationUnit,
  oper._OperationControlProfile AS _OperationControlProfile,
  oper._BillOfOperationsType AS _BillOfOperationsType,
  oper._BillOfOperationsSequence AS _BillOfOperationsSequence,
  oper._BillOfOperationsGroup AS _BillOfOperationsGroup,
  oper._BillOfOperationsVariant AS _BillOfOperationsVariant,
  oper._BOOOperationInternalID AS _BOOOperationInternalID,
  oper._WorkCenter_2 AS _WorkCenter,
  oper._WorkCenterType_2 AS _WorkCenterType,
  oper._MRPController AS _MRPController,
  oper._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  oper._CapacityRequirement AS _CapacityRequirement,
  oper._CapacityRequirementItem AS _CapacityRequirementItem,
  oper._OperationConfirmation AS _OperationConfirmation,
  oper._PurchasingOrganization AS _PurchasingOrganization,
  oper._PurchasingGroup AS _PurchasingGroup,
  oper._PurchaseOrder AS _PurchaseOrder,
  oper._PurchaseOrderItem AS _PurchaseOrderItem,
  oper._PurchasingInfoRecord AS _PurchasingInfoRecord,
  oper._OpExternalProcessingCurrency AS _OpExternalProcessingCurrency,
  oper._EmployeeWageGroup AS _EmployeeWageGroup,
  oper._EmployeeSuitability AS _EmployeeSuitability,
  oper._CompanyCode AS _CompanyCode,
  oper._ProfitCenter AS _ProfitCenter,
  oper._ControllingArea AS _ControllingArea,
  oper._ControllingObjectClass AS _ControllingObjectClass,
  oper._FunctionalArea AS _FunctionalArea,
  oper._BusinessArea AS _BusinessArea,
  oper._BusinessProcess AS _BusinessProcess,
  oper._BusinessProcessEntryUnit AS _BusinessProcessEntryUnit,
  oper._OperationSetupGroupCategory AS _OperationSetupGroupCategory,
  oper._OperationSetupGroup AS _OperationSetupGroup,
  oper._OperationSetupType AS _OperationSetupType,
  oper._LeadTimeReductionStrategy AS _LeadTimeReductionStrategy,
  oper._StartDateOffsetReferenceCode AS _StartDateOffsetReferenceCode,
  oper._EndDateOffsetReferenceCode AS _EndDateOffsetReferenceCode,
  oper._Language AS _Language
FROM P_MfgOrderOperationDelay AS oper
INNER JOIN P_OrderOperationStatusBasicAgg AS stat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _StartDate ON OpErlstSchedldExecStrtDte = _StartDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON WorkCenter = _WorkCenterBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DurationUnit ON DurationUnit = _DurationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DurationUnitHours ON HoursUnitOfMeasure = _DurationUnitHours.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ActualDurationUnit ON ActualDurationUnit = _ActualDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PlannedDurationUnit ON PlannedDurationUnit = _PlannedDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DeviationDurationUnit ON DeviationDurationUnit = _DeviationDurationUnit.UnitOfMeasure  -- association [0..1]
;