I_MfgOrderOperationDurn
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)
| Source | Alias | Join Type |
|---|---|---|
| I_MfgOrderOperationDelay | oper | from |
| P_MfgOrderOpDurnInWorkdays | P_MfgOrderOpDurnInWorkdays | inner |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA