I_MfgOrderOperationDurn

DDL: I_MFGORDEROPERATIONDURN SQL: IPPMFGORDEROPD Type: view COMPOSITE

Manufacturing Order Operation Duration

I_MfgOrderOperationDurn is a Composite CDS View (Dimension) that provides data about "Manufacturing Order Operation Duration" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrderOperationDelay, P_MfgOrderOpDurnInWorkdays) and exposes 298 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. It has 8 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MfgOrderOperationDelay oper from
P_MfgOrderOpDurnInWorkdays P_MfgOrderOpDurnInWorkdays inner

Associations (8)

CardinalityTargetAliasCondition
[1..1] I_OrderInternalID _OrderInternalID $projection.OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID
[1..1] I_ManufacturingOrder _ManufacturingOrder $projection.ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder
[0..1] I_UnitOfMeasure _StdWorkQuantityUnit1 $projection.WorkCenterStandardWorkQtyUnit1 = _StdWorkQuantityUnit1.UnitOfMeasure
[0..1] I_UnitOfMeasure _StdWorkQuantityUnit2 $projection.WorkCenterStandardWorkQtyUnit2 = _StdWorkQuantityUnit2.UnitOfMeasure
[0..1] I_UnitOfMeasure _StdWorkQuantityUnit3 $projection.WorkCenterStandardWorkQtyUnit3 = _StdWorkQuantityUnit3.UnitOfMeasure
[0..1] I_UnitOfMeasure _StdWorkQuantityUnit4 $projection.WorkCenterStandardWorkQtyUnit4 = _StdWorkQuantityUnit4.UnitOfMeasure
[0..1] I_UnitOfMeasure _StdWorkQuantityUnit5 $projection.WorkCenterStandardWorkQtyUnit5 = _StdWorkQuantityUnit5.UnitOfMeasure
[0..1] I_UnitOfMeasure _StdWorkQuantityUnit6 $projection.WorkCenterStandardWorkQtyUnit6 = _StdWorkQuantityUnit6.UnitOfMeasure

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPPMFGORDEROPD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey OrderIntBillOfOperationsItem view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label Manufacturing Order Operation Duration view

Fields (298)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations I_MfgOrderOperationDelay OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem I_MfgOrderOperationDelay OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ManufacturingOrder I_MfgOrderOperationDelay ManufacturingOrder Order
ManufacturingOrderSequence I_MfgOrderOperationDelay ManufacturingOrderSequence
ManufacturingOrderOperation I_MfgOrderOperationDelay ManufacturingOrderOperation Activity
ManufacturingOrderOperation_2 I_MfgOrderOperationDelay ManufacturingOrderOperation_2
ManufacturingOrderSubOperation I_MfgOrderOperationDelay ManufacturingOrderSubOperation
ManufacturingOrdSubOperation_2 I_MfgOrderOperationDelay ManufacturingOrdSubOperation_2
ManufacturingOrderCategory I_MfgOrderOperationDelay ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrderOperationDelay ManufacturingOrderType
ProductionSupervisor I_MfgOrderOperationDelay ProductionSupervisor Prodn Supervisor
MRPController I_MfgOrderOperationDelay MRPController MRP Controller
ResponsiblePlannerGroup I_MfgOrderOperationDelay ResponsiblePlannerGroup
ProductConfiguration I_MfgOrderOperationDelay ProductConfiguration
MfgOrderOperationText I_MfgOrderOperationDelay MfgOrderOperationText
Language I_MfgOrderOperationDelay Language Report Text Language
OperationStandardTextCode I_MfgOrderOperationDelay OperationStandardTextCode Std Text Key
MfgOrderOperationIsPhase I_MfgOrderOperationDelay MfgOrderOperationIsPhase
MfgOrderPhaseSuperiorOperation I_MfgOrderOperationDelay MfgOrderPhaseSuperiorOperation
MfgOrdPhaseSuperiorOperation_2 I_MfgOrderOperationDelay MfgOrdPhaseSuperiorOperation_2
NumberOfCapacities I_MfgOrderOperationDelay NumberOfCapacities Number
NumberOfConfirmationSlips I_MfgOrderOperationDelay NumberOfConfirmationSlips No. of Conf. Slips
NumberOfOperationConfirmations I_MfgOrderOperationDelay NumberOfOperationConfirmations
OperationImportance I_MfgOrderOperationDelay OperationImportance
ObjectInternalID I_MfgOrderOperationDelay ManufacturingObject
OperationIsCreated I_MfgOrderOperationDelay OperationIsCreated
OperationIsReleased I_MfgOrderOperationDelay OperationIsReleased
OperationIsPrinted I_MfgOrderOperationDelay OperationIsPrinted
OperationIsConfirmed I_MfgOrderOperationDelay OperationIsConfirmed
OperationIsPartiallyConfirmed I_MfgOrderOperationDelay OperationIsPartiallyConfirmed
OperationIsDeleted I_MfgOrderOperationDelay OperationIsDeleted
OperationIsTechlyCompleted I_MfgOrderOperationDelay OperationIsTechlyCompleted
OperationIsClosed I_MfgOrderOperationDelay OperationIsClosed
OperationIsScheduled I_MfgOrderOperationDelay OperationIsScheduled
OperationIsPartiallyDelivered I_MfgOrderOperationDelay OperationIsPartiallyDelivered
OperationIsDelivered I_MfgOrderOperationDelay OperationIsDelivered
ProductionPlant I_MfgOrderOperationDelay ProductionPlant Prod plnt
WorkCenterInternalID I_MfgOrderOperationDelay WorkCenterInternalID Work Center
WorkCenterTypeCode I_MfgOrderOperationDelay WorkCenterTypeCode Object Type
WorkCenterTypeCode_2 I_MfgOrderOperationDelay WorkCenterTypeCode_2
WorkCenter I_MfgOrderOperationDelay WorkCenter Work Center
OperationControlProfile I_MfgOrderOperationDelay OperationControlProfile Control Key
BillOfOperationsType I_MfgOrderOperationDelay BillOfOperationsType Task List Type
BillOfOperationsGroup I_MfgOrderOperationDelay BillOfOperationsGroup Group
BillOfOperationsVariant I_MfgOrderOperationDelay BillOfOperationsVariant Group Counter
BillOfOperationsSequence I_MfgOrderOperationDelay BillOfOperationsSequence Sequence
BillOfOperationsVersion I_MfgOrderOperationDelay BillOfOperationsVersion Routing Version
BOOOperationInternalID I_MfgOrderOperationDelay BOOOperationInternalID Task list node
OperationConfirmation I_MfgOrderOperationDelay OperationConfirmation
CapacityRequirement I_MfgOrderOperationDelay CapacityRequirement
CapacityRequirementItem I_MfgOrderOperationDelay CapacityRequirementItem
PurchasingOrganization I_MfgOrderOperationDelay PurchasingOrganization Purchasing Organization
PurchasingGroup I_MfgOrderOperationDelay PurchasingGroup Purchasing Group
PurchaseRequisition I_MfgOrderOperationDelay PurchaseRequisition Requisition
PurchaseRequisitionItem I_MfgOrderOperationDelay PurchaseRequisitionItem Requisn. item
PurchaseOrder I_MfgOrderOperationDelay PurchaseOrder Purchasing Document
PurchaseOrderItem I_MfgOrderOperationDelay PurchaseOrderItem Purchasing Document Item
PurchasingInfoRecord I_MfgOrderOperationDelay PurchasingInfoRecord Info Record
PurgInfoRecdDataIsFixed I_MfgOrderOperationDelay PurgInfoRecdDataIsFixed
PurchasingInfoRecordCategory I_MfgOrderOperationDelay PurchasingInfoRecordCategory Infotype
OpExternalProcessingPriceUnit I_MfgOrderOperationDelay OpExternalProcessingPriceUnit Price unit
Supplier I_MfgOrderOperationDelay Supplier Supplier
GoodsRecipientName I_MfgOrderOperationDelay GoodsRecipientName Recipient Name
UnloadingPointName I_MfgOrderOperationDelay UnloadingPointName Unloading Point Name
OpExternalProcessingCurrency I_MfgOrderOperationDelay OpExternalProcessingCurrency Currency
OpExternalProcessingPrice I_MfgOrderOperationDelay OpExternalProcessingPrice Price
NumberOfOperationPriceUnits I_MfgOrderOperationDelay NumberOfOperationPriceUnits Price Unit
CompanyCode I_MfgOrderOperationDelay CompanyCode Receiver Company Code
BusinessArea I_MfgOrderOperationDelay BusinessArea Business Area
ControllingArea I_MfgOrderOperationDelay ControllingArea Controlling Area
ProfitCenter I_MfgOrderOperationDelay ProfitCenter Profit Center
RequestingCostCenter I_MfgOrderOperationDelay RequestingCostCenter Req.cost center
CostElement I_MfgOrderOperationDelay CostElement G/L Account
CostingVariant I_MfgOrderOperationDelay CostingVariant
CostingSheet I_MfgOrderOperationDelay CostingSheet Costing Sheet
CostEstimate I_MfgOrderOperationDelay CostEstimate Cost EstimateNo
ControllingObjectClass I_MfgOrderOperationDelay ControllingObjectClass Object Class
FunctionalArea I_MfgOrderOperationDelay FunctionalArea Sendr Fctl Area
TaxJurisdiction I_MfgOrderOperationDelay TaxJurisdiction Tax Jurisdiction
EmployeeWageType I_MfgOrderOperationDelay EmployeeWageType Wage type
EmployeeWageGroup I_MfgOrderOperationDelay EmployeeWageGroup Wage Group
EmployeeSuitability I_MfgOrderOperationDelay EmployeeSuitability
NumberOfTimeTickets I_MfgOrderOperationDelay NumberOfTimeTickets No.TimeTickets
NumberOfEmployees I_MfgOrderOperationDelay NumberOfEmployees No. employees
OperationSetupGroupCategory I_MfgOrderOperationDelay OperationSetupGroupCategory Setup group cat
OperationSetupGroup I_MfgOrderOperationDelay OperationSetupGroup Setup group key
OperationSetupType I_MfgOrderOperationDelay OperationSetupType Setup Type Key
OperationOverlappingIsRequired I_MfgOrderOperationDelay OperationOverlappingIsRequired
OperationOverlappingIsPossible I_MfgOrderOperationDelay OperationOverlappingIsPossible
OperationsIsAlwaysOverlapping I_MfgOrderOperationDelay OperationsIsAlwaysOverlapping
OperationSplitIsRequired I_MfgOrderOperationDelay OperationSplitIsRequired Splitting Reqd
MaximumNumberOfSplits I_MfgOrderOperationDelay MaximumNumberOfSplits Maximum Splits
LeadTimeReductionStrategy I_MfgOrderOperationDelay LeadTimeReductionStrategy Red. Strategy
OpSchedldReductionLevel I_MfgOrderOperationDelay OpSchedldReductionLevel
OpErlstSchedldExecStrtDte I_MfgOrderOperationDelay OpErlstSchedldExecStrtDte Earl.start date
OpErlstSchedldExecStrtTme I_MfgOrderOperationDelay OpErlstSchedldExecStrtTme
OpErlstSchedldProcgStrtDte I_MfgOrderOperationDelay OpErlstSchedldProcgStrtDte
OpErlstSchedldProcgStrtTme I_MfgOrderOperationDelay OpErlstSchedldProcgStrtTme
OpErlstSchedldTrdwnStrtDte I_MfgOrderOperationDelay OpErlstSchedldTrdwnStrtDte
OpErlstSchedldTrdwnStrtTme I_MfgOrderOperationDelay OpErlstSchedldTrdwnStrtTme
OpErlstSchedldExecEndDte I_MfgOrderOperationDelay OpErlstSchedldExecEndDte EarliestEndDate
OpErlstSchedldExecEndTme I_MfgOrderOperationDelay OpErlstSchedldExecEndTme
OpLtstSchedldExecStrtDte I_MfgOrderOperationDelay OpLtstSchedldExecStrtDte Latest start
OpLtstSchedldExecStrtTme I_MfgOrderOperationDelay OpLtstSchedldExecStrtTme
OpLtstSchedldProcgStrtDte I_MfgOrderOperationDelay OpLtstSchedldProcgStrtDte
OpLtstSchedldProcgStrtTme I_MfgOrderOperationDelay OpLtstSchedldProcgStrtTme
OpLtstSchedldTrdwnStrtDte I_MfgOrderOperationDelay OpLtstSchedldTrdwnStrtDte
OpLtstSchedldTrdwnStrtTme I_MfgOrderOperationDelay OpLtstSchedldTrdwnStrtTme
OpLtstSchedldExecEndDte I_MfgOrderOperationDelay OpLtstSchedldExecEndDte Lat.finish date
OpLtstSchedldExecEndTme I_MfgOrderOperationDelay OpLtstSchedldExecEndTme
OperationConfirmedStartDate I_MfgOrderOperationDelay OperationConfirmedStartDate
OperationConfirmedEndDate I_MfgOrderOperationDelay OperationConfirmedEndDate
OpActualExecutionStartDate I_MfgOrderOperationDelay OpActualExecutionStartDate Execution Start Date
OpActualExecutionStartTime I_MfgOrderOperationDelay OpActualExecutionStartTime
OpActualSetupEndDate I_MfgOrderOperationDelay OpActualSetupEndDate
OpActualSetupEndTime I_MfgOrderOperationDelay OpActualSetupEndTime
OpActualProcessingStartDate I_MfgOrderOperationDelay OpActualProcessingStartDate
OpActualProcessingStartTime I_MfgOrderOperationDelay OpActualProcessingStartTime
OpActualProcessingEndDate I_MfgOrderOperationDelay OpActualProcessingEndDate
OpActualProcessingEndTime I_MfgOrderOperationDelay OpActualProcessingEndTime
OpActualTeardownStartDate I_MfgOrderOperationDelay OpActualTeardownStartDate
OpActualTeardownStartTme I_MfgOrderOperationDelay OpActualTeardownStartTme
OpActualExecutionEndDate I_MfgOrderOperationDelay OpActualExecutionEndDate Execution End Date
OpActualExecutionEndTime I_MfgOrderOperationDelay OpActualExecutionEndTime
SchedldFcstdEarliestStartDate I_MfgOrderOperationDelay SchedldFcstdEarliestStartDate
SchedldFcstdEarliestStartTime I_MfgOrderOperationDelay SchedldFcstdEarliestStartTime
SchedldFcstdEarliestEndDate I_MfgOrderOperationDelay SchedldFcstdEarliestEndDate
SchedldFcstdEarliestEndTime I_MfgOrderOperationDelay SchedldFcstdEarliestEndTime
LatestSchedldFcstdStartDate I_MfgOrderOperationDelay LatestSchedldFcstdStartDate
SchedldFcstdLatestStartTime I_MfgOrderOperationDelay SchedldFcstdLatestStartTime
LatestSchedldFcstdEndDate I_MfgOrderOperationDelay LatestSchedldFcstdEndDate
SchedldFcstdLatestEndTime I_MfgOrderOperationDelay SchedldFcstdLatestEndTime
BreakDurationUnit I_MfgOrderOperationDelay BreakDurationUnit
PlannedBreakDuration I_MfgOrderOperationDelay PlannedBreakDuration
ConfirmedBreakDuration I_MfgOrderOperationDelay ConfirmedBreakDuration
OverlapMinimumDurationUnit I_MfgOrderOperationDelay OverlapMinimumDurationUnit Min.Overlap Tme
OverlapMinimumDuration I_MfgOrderOperationDelay OverlapMinimumDuration Minimum Overlap
MaximumWaitDurationUnit I_MfgOrderOperationDelay MaximumWaitDurationUnit Max. Wait Unit
MaximumWaitDuration I_MfgOrderOperationDelay MaximumWaitDuration Max. Wait Time
MinimumWaitDurationUnit I_MfgOrderOperationDelay MinimumWaitDurationUnit Req. Wait Unit
MinimumWaitDuration I_MfgOrderOperationDelay MinimumWaitDuration Min. Wait Time
StandardMoveDurationUnit I_MfgOrderOperationDelay StandardMoveDurationUnit StdMoveTime Un
StandardMoveDuration I_MfgOrderOperationDelay StandardMoveDuration Std Move Time
StandardQueueDurationUnit I_MfgOrderOperationDelay StandardQueueDurationUnit Std Queue Unit
StandardQueueDuration I_MfgOrderOperationDelay StandardQueueDuration Std Queue Time
MinimumQueueDurationUnit I_MfgOrderOperationDelay MinimumQueueDurationUnit Min. Queue Unit
MinimumQueueDuration I_MfgOrderOperationDelay MinimumQueueDuration Min. Queue Time
MinimumMoveDurationUnit I_MfgOrderOperationDelay MinimumMoveDurationUnit MinMoveTime Un
MinimumMoveDuration I_MfgOrderOperationDelay MinimumMoveDuration Min. Move Time
OperationStandardDuration I_MfgOrderOperationDelay OperationStandardDuration
OperationStandardDurationUnit I_MfgOrderOperationDelay OperationStandardDurationUnit
MinimumDuration I_MfgOrderOperationDelay MinimumDuration
MinimumDurationUnit I_MfgOrderOperationDelay MinimumDurationUnit
MinimumProcessingDuration I_MfgOrderOperationDelay MinimumProcessingDuration
MinimumProcessingDurationUnit I_MfgOrderOperationDelay MinimumProcessingDurationUnit
ScheduledMoveDuration I_MfgOrderOperationDelay ScheduledMoveDuration
ScheduledMoveDurationUnit I_MfgOrderOperationDelay ScheduledMoveDurationUnit
ScheduledQueueDuration I_MfgOrderOperationDelay ScheduledQueueDuration
ScheduledQueueDurationUnit I_MfgOrderOperationDelay ScheduledQueueDurationUnit
ScheduledWaitDuration I_MfgOrderOperationDelay ScheduledWaitDuration
ScheduledWaitDurationUnit I_MfgOrderOperationDelay ScheduledWaitDurationUnit
PlannedDeliveryDuration I_MfgOrderOperationDelay PlannedDeliveryDuration Pl. Deliv. Time
OpPlannedSetupDurn I_MfgOrderOperationDelay OpPlannedSetupDurn
OpPlannedSetupDurnUnit I_MfgOrderOperationDelay OpPlannedSetupDurnUnit
OpPlannedProcessingDurn I_MfgOrderOperationDelay OpPlannedProcessingDurn
OpPlannedProcessingDurnUnit I_MfgOrderOperationDelay OpPlannedProcessingDurnUnit
OpPlannedTeardownDurn I_MfgOrderOperationDelay OpPlannedTeardownDurn
OpPlannedTeardownDurnUnit I_MfgOrderOperationDelay OpPlannedTeardownDurnUnit
ErlstSchedldExecDurnInWorkdays durn ErlstSchedldExecDurnInWorkdays
LtstSchedldExecDurnInWorkdays durn LtstSchedldExecDurnInWorkdays
OpActualExecutionDays durn actualexecutiondurninworkdays
PlannedActualStartDateDvtnDurn I_MfgOrderOperationDelay PlannedActualStartDateDvtnDurn
PlannedActualEndDateDvtnDurn I_MfgOrderOperationDelay PlannedActualEndDateDvtnDurn
PlannedCurrentStrtDateDvtnDurn I_MfgOrderOperationDelay PlannedCurrentStrtDateDvtnDurn
PlannedCurrentEndDateDvtnDurn I_MfgOrderOperationDelay PlannedCurrentEndDateDvtnDurn
OperationExecutionStartIsLate I_MfgOrderOperationDelay OperationExecutionStartIsLate
OperationExecutionEndIsLate I_MfgOrderOperationDelay OperationExecutionEndIsLate
StartDateOffsetReferenceCode I_MfgOrderOperationDelay StartDateOffsetReferenceCode
StartDateOffsetDurationUnit I_MfgOrderOperationDelay StartDateOffsetDurationUnit
StartDateOffsetDuration I_MfgOrderOperationDelay StartDateOffsetDuration
EndDateOffsetReferenceCode I_MfgOrderOperationDelay EndDateOffsetReferenceCode
EndDateOffsetDurationUnit I_MfgOrderOperationDelay EndDateOffsetDurationUnit
EndDateOffsetDuration I_MfgOrderOperationDelay EndDateOffsetDuration
OperationUnit I_MfgOrderOperationDelay OperationUnit Act/op UoM
OperationReferenceQuantity I_MfgOrderOperationDelay OperationReferenceQuantity Base Quantity
OpPlannedTotalQuantity I_MfgOrderOperationDelay OpPlannedTotalQuantity
OpPlannedScrapQuantity I_MfgOrderOperationDelay OpPlannedScrapQuantity
OpPlannedYieldQuantity I_MfgOrderOperationDelay OpPlannedYieldQuantity
OpTotalConfirmedYieldQty I_MfgOrderOperationDelay OpTotalConfirmedYieldQty
OpTotalConfirmedScrapQty I_MfgOrderOperationDelay OpTotalConfirmedScrapQty
OperationConfirmedReworkQty I_MfgOrderOperationDelay OperationConfirmedReworkQty
OperationYieldDeviationQty I_MfgOrderOperationDelay OperationYieldDeviationQty
ProductionUnit I_MfgOrderOperationDelay ProductionUnit
OpTotConfdYieldQtyInOrdQtyUnit I_MfgOrderOperationDelay OpTotConfdYieldQtyInOrdQtyUnit
OpWorkQuantityUnit1 I_MfgOrderOperationDelay OpWorkQuantityUnit1
OpConfirmedWorkQuantity1 I_MfgOrderOperationDelay OpConfirmedWorkQuantity1
NoFurtherOpWorkQuantity1IsExpd I_MfgOrderOperationDelay NoFurtherOpWorkQuantity1IsExpd
OpWorkQuantityUnit2 I_MfgOrderOperationDelay OpWorkQuantityUnit2
OpConfirmedWorkQuantity2 I_MfgOrderOperationDelay OpConfirmedWorkQuantity2
NoFurtherOpWorkQuantity2IsExpd I_MfgOrderOperationDelay NoFurtherOpWorkQuantity2IsExpd
OpWorkQuantityUnit3 I_MfgOrderOperationDelay OpWorkQuantityUnit3
OpConfirmedWorkQuantity3 I_MfgOrderOperationDelay OpConfirmedWorkQuantity3
NoFurtherOpWorkQuantity3IsExpd I_MfgOrderOperationDelay NoFurtherOpWorkQuantity3IsExpd
OpWorkQuantityUnit4 I_MfgOrderOperationDelay OpWorkQuantityUnit4
OpConfirmedWorkQuantity4 I_MfgOrderOperationDelay OpConfirmedWorkQuantity4
NoFurtherOpWorkQuantity4IsExpd I_MfgOrderOperationDelay NoFurtherOpWorkQuantity4IsExpd
OpWorkQuantityUnit5 I_MfgOrderOperationDelay OpWorkQuantityUnit5
OpConfirmedWorkQuantity5 I_MfgOrderOperationDelay OpConfirmedWorkQuantity5
NoFurtherOpWorkQuantity5IsExpd I_MfgOrderOperationDelay NoFurtherOpWorkQuantity5IsExpd
OpWorkQuantityUnit6 I_MfgOrderOperationDelay OpWorkQuantityUnit6
OpConfirmedWorkQuantity6 I_MfgOrderOperationDelay OpConfirmedWorkQuantity6
NoFurtherOpWorkQuantity6IsExpd I_MfgOrderOperationDelay NoFurtherOpWorkQuantity6IsExpd
WorkCenterStandardWorkQtyUnit1 I_MfgOrderOperationDelay WorkCenterStandardWorkQtyUnit1
WorkCenterStandardWorkQty1 I_MfgOrderOperationDelay WorkCenterStandardWorkQty1
CostCtrActivityType1 I_MfgOrderOperationDelay CostCtrActivityType1 Activity Type
WorkCenterStandardWorkQtyUnit2 I_MfgOrderOperationDelay WorkCenterStandardWorkQtyUnit2
WorkCenterStandardWorkQty2 I_MfgOrderOperationDelay WorkCenterStandardWorkQty2
CostCtrActivityType2 I_MfgOrderOperationDelay CostCtrActivityType2 Activity Type
WorkCenterStandardWorkQtyUnit3 I_MfgOrderOperationDelay WorkCenterStandardWorkQtyUnit3
WorkCenterStandardWorkQty3 I_MfgOrderOperationDelay WorkCenterStandardWorkQty3
CostCtrActivityType3 I_MfgOrderOperationDelay CostCtrActivityType3 Activity Type
WorkCenterStandardWorkQtyUnit4 I_MfgOrderOperationDelay WorkCenterStandardWorkQtyUnit4
WorkCenterStandardWorkQty4 I_MfgOrderOperationDelay WorkCenterStandardWorkQty4
CostCtrActivityType4 I_MfgOrderOperationDelay CostCtrActivityType4 Activity Type
WorkCenterStandardWorkQtyUnit5 I_MfgOrderOperationDelay WorkCenterStandardWorkQtyUnit5
WorkCenterStandardWorkQty5 I_MfgOrderOperationDelay WorkCenterStandardWorkQty5
CostCtrActivityType5 I_MfgOrderOperationDelay CostCtrActivityType5 Activity Type
WorkCenterStandardWorkQtyUnit6 I_MfgOrderOperationDelay WorkCenterStandardWorkQtyUnit6
WorkCenterStandardWorkQty6 I_MfgOrderOperationDelay WorkCenterStandardWorkQty6
CostCtrActivityType6 I_MfgOrderOperationDelay CostCtrActivityType6 Activity Type
BusinessProcess I_MfgOrderOperationDelay BusinessProcess Business Process
BusinessProcessEntryUnit I_MfgOrderOperationDelay BusinessProcessEntryUnit
BusinessProcessConfirmedQty I_MfgOrderOperationDelay BusinessProcessConfirmedQty
NoFurtherBusinessProcQtyIsExpd I_MfgOrderOperationDelay NoFurtherBusinessProcQtyIsExpd
SetupOpActyNtwkInstance I_MfgOrderOperationDelay SetupOpActyNtwkInstance
ProduceOpActyNtwkInstance I_MfgOrderOperationDelay ProduceOpActyNtwkInstance
TeardownOpActyNtwkInstance I_MfgOrderOperationDelay TeardownOpActyNtwkInstance
_OrderInternalID _OrderInternalID
_ManufacturingOrder _ManufacturingOrder
_OrdInternalBillOfOperations I_MfgOrderOperationDelay _OrdInternalBillOfOperations
_MfgOrder I_MfgOrderOperationDelay _MfgOrder
_MfgOrderSequence I_MfgOrderOperationDelay _MfgOrderSequence
_MfgOrderCategory I_MfgOrderOperationDelay _MfgOrderCategory
_MfgOrderType I_MfgOrderOperationDelay _MfgOrderType
_OperationStandardTextCode I_MfgOrderOperationDelay _OperationStandardTextCode
_ProductionPlant I_MfgOrderOperationDelay _ProductionPlant
_ProductionSupervisor I_MfgOrderOperationDelay _ProductionSupervisor
_ProductionUnit I_MfgOrderOperationDelay _ProductionUnit
_OperationUnit I_MfgOrderOperationDelay _OperationUnit
_OperationControlProfile I_MfgOrderOperationDelay _OperationControlProfile
_BillOfOperationsType I_MfgOrderOperationDelay _BillOfOperationsType
_BillOfOperationsSequence I_MfgOrderOperationDelay _BillOfOperationsSequence
_BillOfOperationsGroup I_MfgOrderOperationDelay _BillOfOperationsGroup
_BillOfOperationsVariant I_MfgOrderOperationDelay _BillOfOperationsVariant
_WorkCenter I_MfgOrderOperationDelay _WorkCenter
_WorkCenter_2 I_MfgOrderOperationDelay _WorkCenter_2
_WorkCenterType I_MfgOrderOperationDelay _WorkCenterType
_WorkCenterType_2 I_MfgOrderOperationDelay _WorkCenterType_2
_WorkCenterBySemanticKey I_MfgOrderOperationDelay _WorkCenterBySemanticKey
_MRPController I_MfgOrderOperationDelay _MRPController
_ResponsiblePlannerGroup I_MfgOrderOperationDelay _ResponsiblePlannerGroup
_CapacityRequirement I_MfgOrderOperationDelay _CapacityRequirement
_CapacityRequirementItem I_MfgOrderOperationDelay _CapacityRequirementItem
_OperationConfirmation I_MfgOrderOperationDelay _OperationConfirmation
_PurchasingOrganization I_MfgOrderOperationDelay _PurchasingOrganization
_PurchasingGroup I_MfgOrderOperationDelay _PurchasingGroup
_PurchaseOrder I_MfgOrderOperationDelay _PurchaseOrder
_PurchaseOrderItem I_MfgOrderOperationDelay _PurchaseOrderItem
_PurchasingInfoRecord I_MfgOrderOperationDelay _PurchasingInfoRecord
_OpExternalProcessingCurrency I_MfgOrderOperationDelay _OpExternalProcessingCurrency
_EmployeeWageGroup I_MfgOrderOperationDelay _EmployeeWageGroup
_EmployeeSuitability I_MfgOrderOperationDelay _EmployeeSuitability
_CompanyCode I_MfgOrderOperationDelay _CompanyCode
_ProfitCenter I_MfgOrderOperationDelay _ProfitCenter
_ControllingArea I_MfgOrderOperationDelay _ControllingArea
_ControllingObjectClass I_MfgOrderOperationDelay _ControllingObjectClass
_FunctionalArea I_MfgOrderOperationDelay _FunctionalArea
_BusinessArea I_MfgOrderOperationDelay _BusinessArea
_BusinessProcess I_MfgOrderOperationDelay _BusinessProcess
_BusinessProcessEntryUnit I_MfgOrderOperationDelay _BusinessProcessEntryUnit
_OperationSetupGroupCategory I_MfgOrderOperationDelay _OperationSetupGroupCategory
_OperationSetupGroup I_MfgOrderOperationDelay _OperationSetupGroup
_OperationSetupType I_MfgOrderOperationDelay _OperationSetupType
_LeadTimeReductionStrategy I_MfgOrderOperationDelay _LeadTimeReductionStrategy
_StartDateOffsetReferenceCode I_MfgOrderOperationDelay _StartDateOffsetReferenceCode
_EndDateOffsetReferenceCode I_MfgOrderOperationDelay _EndDateOffsetReferenceCode
_Language I_MfgOrderOperationDelay _Language
_SetupOpActyNtwkInstance I_MfgOrderOperationDelay _SetupOpActyNtwkInstance
_ProduceOpActyNtwkInstance I_MfgOrderOperationDelay _ProduceOpActyNtwkInstance
_TeardownOpActyNtwkInstance I_MfgOrderOperationDelay _TeardownOpActyNtwkInstance
_StartDate I_MfgOrderOperationDelay _StartDate
_LongText I_MfgOrderOperationDelay _LongText
_StdWorkQuantityUnit1 _StdWorkQuantityUnit1
_StdWorkQuantityUnit2 _StdWorkQuantityUnit2
_StdWorkQuantityUnit3 _StdWorkQuantityUnit3
_StdWorkQuantityUnit4 _StdWorkQuantityUnit4
_StdWorkQuantityUnit5 _StdWorkQuantityUnit5
_StdWorkQuantityUnit6 _StdWorkQuantityUnit6

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_MfgOrderOperationDurn.
-- 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: IPPMFGORDEROPD

CREATE VIEW I_MfgOrderOperationDurn AS
SELECT
  oper.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  oper.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  oper.ManufacturingOrder AS ManufacturingOrder,
  oper.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  oper.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  oper.ManufacturingOrderOperation_2 AS ManufacturingOrderOperation_2,
  oper.ManufacturingOrderSubOperation AS ManufacturingOrderSubOperation,
  oper.ManufacturingOrdSubOperation_2 AS ManufacturingOrdSubOperation_2,
  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.Language AS Language,
  oper.OperationStandardTextCode AS OperationStandardTextCode,
  oper.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  oper.MfgOrderPhaseSuperiorOperation AS MfgOrderPhaseSuperiorOperation,
  oper.MfgOrdPhaseSuperiorOperation_2 AS MfgOrdPhaseSuperiorOperation_2,
  oper.NumberOfCapacities AS NumberOfCapacities,
  oper.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  oper.NumberOfOperationConfirmations AS NumberOfOperationConfirmations,
  oper.OperationImportance AS OperationImportance,
  oper.ManufacturingObject AS ObjectInternalID,
  oper.OperationIsCreated AS OperationIsCreated,
  oper.OperationIsReleased AS OperationIsReleased,
  oper.OperationIsPrinted AS OperationIsPrinted,
  oper.OperationIsConfirmed AS OperationIsConfirmed,
  oper.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
  oper.OperationIsDeleted AS OperationIsDeleted,
  oper.OperationIsTechlyCompleted AS OperationIsTechlyCompleted,
  oper.OperationIsClosed AS OperationIsClosed,
  oper.OperationIsScheduled AS OperationIsScheduled,
  oper.OperationIsPartiallyDelivered AS OperationIsPartiallyDelivered,
  oper.OperationIsDelivered AS OperationIsDelivered,
  oper.ProductionPlant AS ProductionPlant,
  oper.WorkCenterInternalID AS WorkCenterInternalID,
  oper.WorkCenterTypeCode AS WorkCenterTypeCode,
  oper.WorkCenterTypeCode_2 AS WorkCenterTypeCode_2,
  oper.WorkCenter 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.PurchaseRequisition AS PurchaseRequisition,
  oper.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  oper.PurchaseOrder AS PurchaseOrder,
  oper.PurchaseOrderItem AS PurchaseOrderItem,
  oper.PurchasingInfoRecord AS PurchasingInfoRecord,
  oper.PurgInfoRecdDataIsFixed AS PurgInfoRecdDataIsFixed,
  oper.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  oper.OpExternalProcessingPriceUnit AS OpExternalProcessingPriceUnit,
  oper.Supplier AS Supplier,
  oper.GoodsRecipientName AS GoodsRecipientName,
  oper.UnloadingPointName AS UnloadingPointName,
  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.BreakDurationUnit AS BreakDurationUnit,
  oper.PlannedBreakDuration AS PlannedBreakDuration,
  oper.ConfirmedBreakDuration AS ConfirmedBreakDuration,
  oper.OverlapMinimumDurationUnit AS OverlapMinimumDurationUnit,
  oper.OverlapMinimumDuration AS OverlapMinimumDuration,
  oper.MaximumWaitDurationUnit AS MaximumWaitDurationUnit,
  oper.MaximumWaitDuration AS MaximumWaitDuration,
  oper.MinimumWaitDurationUnit AS MinimumWaitDurationUnit,
  oper.MinimumWaitDuration AS MinimumWaitDuration,
  oper.StandardMoveDurationUnit AS StandardMoveDurationUnit,
  oper.StandardMoveDuration AS StandardMoveDuration,
  oper.StandardQueueDurationUnit AS StandardQueueDurationUnit,
  oper.StandardQueueDuration AS StandardQueueDuration,
  oper.MinimumQueueDurationUnit AS MinimumQueueDurationUnit,
  oper.MinimumQueueDuration AS MinimumQueueDuration,
  oper.MinimumMoveDurationUnit AS MinimumMoveDurationUnit,
  oper.MinimumMoveDuration AS MinimumMoveDuration,
  oper.OperationStandardDuration AS OperationStandardDuration,
  oper.OperationStandardDurationUnit AS OperationStandardDurationUnit,
  oper.MinimumDuration AS MinimumDuration,
  oper.MinimumDurationUnit AS MinimumDurationUnit,
  oper.MinimumProcessingDuration AS MinimumProcessingDuration,
  oper.MinimumProcessingDurationUnit AS MinimumProcessingDurationUnit,
  oper.ScheduledMoveDuration AS ScheduledMoveDuration,
  oper.ScheduledMoveDurationUnit AS ScheduledMoveDurationUnit,
  oper.ScheduledQueueDuration AS ScheduledQueueDuration,
  oper.ScheduledQueueDurationUnit AS ScheduledQueueDurationUnit,
  oper.ScheduledWaitDuration AS ScheduledWaitDuration,
  oper.ScheduledWaitDurationUnit AS ScheduledWaitDurationUnit,
  oper.PlannedDeliveryDuration AS PlannedDeliveryDuration,
  oper.OpPlannedSetupDurn AS OpPlannedSetupDurn,
  oper.OpPlannedSetupDurnUnit AS OpPlannedSetupDurnUnit,
  oper.OpPlannedProcessingDurn AS OpPlannedProcessingDurn,
  oper.OpPlannedProcessingDurnUnit AS OpPlannedProcessingDurnUnit,
  oper.OpPlannedTeardownDurn AS OpPlannedTeardownDurn,
  oper.OpPlannedTeardownDurnUnit AS OpPlannedTeardownDurnUnit,
  durn.ErlstSchedldExecDurnInWorkdays AS ErlstSchedldExecDurnInWorkdays,
  durn.LtstSchedldExecDurnInWorkdays AS LtstSchedldExecDurnInWorkdays,
  durn.actualexecutiondurninworkdays AS OpActualExecutionDays,
  oper.PlannedActualStartDateDvtnDurn AS PlannedActualStartDateDvtnDurn,
  oper.PlannedActualEndDateDvtnDurn AS PlannedActualEndDateDvtnDurn,
  oper.PlannedCurrentStrtDateDvtnDurn AS PlannedCurrentStrtDateDvtnDurn,
  oper.PlannedCurrentEndDateDvtnDurn AS PlannedCurrentEndDateDvtnDurn,
  oper.OperationExecutionStartIsLate AS OperationExecutionStartIsLate,
  oper.OperationExecutionEndIsLate AS OperationExecutionEndIsLate,
  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.OperationYieldDeviationQty AS OperationYieldDeviationQty,
  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.SetupOpActyNtwkInstance AS SetupOpActyNtwkInstance,
  oper.ProduceOpActyNtwkInstance AS ProduceOpActyNtwkInstance,
  oper.TeardownOpActyNtwkInstance AS TeardownOpActyNtwkInstance,
  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._WorkCenter AS _WorkCenter,
  oper._WorkCenter_2 AS _WorkCenter_2,
  oper._WorkCenterType AS _WorkCenterType,
  oper._WorkCenterType_2 AS _WorkCenterType_2,
  oper._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  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,
  oper._SetupOpActyNtwkInstance AS _SetupOpActyNtwkInstance,
  oper._ProduceOpActyNtwkInstance AS _ProduceOpActyNtwkInstance,
  oper._TeardownOpActyNtwkInstance AS _TeardownOpActyNtwkInstance,
  oper._StartDate AS _StartDate,
  oper._LongText AS _LongText
FROM I_MfgOrderOperationDelay AS oper
INNER JOIN P_MfgOrderOpDurnInWorkdays ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit1 ON WorkCenterStandardWorkQtyUnit1 = _StdWorkQuantityUnit1.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit2 ON WorkCenterStandardWorkQtyUnit2 = _StdWorkQuantityUnit2.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit3 ON WorkCenterStandardWorkQtyUnit3 = _StdWorkQuantityUnit3.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit4 ON WorkCenterStandardWorkQtyUnit4 = _StdWorkQuantityUnit4.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit5 ON WorkCenterStandardWorkQtyUnit5 = _StdWorkQuantityUnit5.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StdWorkQuantityUnit6 ON WorkCenterStandardWorkQtyUnit6 = _StdWorkQuantityUnit6.UnitOfMeasure  -- association [0..1]
;