I_MFGORDEROPERATIONDELAY
Manufacturing Order Operation Delay Information
I_MFGORDEROPERATIONDELAY is a CDS View in S/4HANA. Manufacturing Order Operation Delay Information. It contains 300 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MfgOrderOprObjPg | view_entity | from | CONSUMPTION | Production Order Operations Object Page |
| I_ManageOperationsTP | view | from | TRANSACTIONAL | Production Operations Transactional BOPF |
| I_MfgOrderOperationDurn | view | from | COMPOSITE | Manufacturing Order Operation Duration |
| I_RFM_MfgOrderOperationDelay | view | from | COMPOSITE | Manufacturing Order Operation Schedule |
| P_ManageOperations | view_entity | from | TRANSACTIONAL | Production Operations |
| P_MfgOrderWrkCntrOper | view | from | COMPOSITE | Workcenter Manufacturing Order Operations |
| P_Mpe_Workcenteroperstatus | view_entity | from | CONSUMPTION | Status of operations in a work center |
| P_MPEProdnOrderOperationPover | view_entity | from | CONSUMPTION | Production Order Operation popover |
| P_MPEProdnOrdOperStatusText | view_entity | from | CONSUMPTION | Production Order Operation Status Text, private view |
Fields (300)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | 3 |
| KEY | OrderInternalBillOfOperations | OrderInternalBillOfOperations | 3 |
| _BillOfOperationsGroup | _BillOfOperationsGroup | 1 | |
| _BillOfOperationsSequence | _BillOfOperationsSequence | 1 | |
| _BillOfOperationsType | _BillOfOperationsType | 1 | |
| _BillOfOperationsVariant | _BillOfOperationsVariant | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessProcess | _BusinessProcess | 1 | |
| _BusinessProcessEntryUnit | _BusinessProcessEntryUnit | 2 | |
| _CapacityRequirement | _CapacityRequirement | 1 | |
| _CapacityRequirementItem | _CapacityRequirementItem | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingObjectClass | _ControllingObjectClass | 1 | |
| _EmployeeSuitability | _EmployeeSuitability | 1 | |
| _EmployeeWageGroup | _EmployeeWageGroup | 1 | |
| _EndDateOffsetReferenceCode | _EndDateOffsetReferenceCode | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _Language | _Language | 1 | |
| _LeadTimeReductionStrategy | _LeadTimeReductionStrategy | 1 | |
| _LongText | _LongText | 1 | |
| _MfgOrder | _MfgOrder | 2 | |
| _MfgOrderCategory | _MfgOrderCategory | 2 | |
| _MfgOrderSequence | _MfgOrderSequence | 2 | |
| _MfgOrderType | _MfgOrderType | 2 | |
| _MRPController | _MRPController | 1 | |
| _OperationConfirmation | _OperationConfirmation | 1 | |
| _OperationControlProfile | _OperationControlProfile | 1 | |
| _OperationSetupGroup | _OperationSetupGroup | 1 | |
| _OperationSetupGroupCategory | _OperationSetupGroupCategory | 1 | |
| _OperationSetupType | _OperationSetupType | 1 | |
| _OperationStandardTextCode | _OperationStandardTextCode | 1 | |
| _OperationUnit | _OperationUnit | 1 | |
| _OpExternalProcessingCurrency | _OpExternalProcessingCurrency | 1 | |
| _OrdInternalBillOfOperations | _OrdInternalBillOfOperations | 2 | |
| _ProduceOpActyNtwkInstance | _ProduceOpActyNtwkInstance | 1 | |
| _ProductionPlant | _ProductionPlant | 2 | |
| _ProductionSupervisor | _ProductionSupervisor | 1 | |
| _ProductionUnit | _ProductionUnit | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _PurchaseOrder | _PurchaseOrder | 1 | |
| _PurchaseOrderItem | _PurchaseOrderItem | 1 | |
| _PurchasingGroup | _PurchasingGroup | 1 | |
| _PurchasingInfoRecord | _PurchasingInfoRecord | 1 | |
| _PurchasingOrganization | _PurchasingOrganization | 1 | |
| _ResponsiblePlannerGroup | _ResponsiblePlannerGroup | 1 | |
| _SetupOpActyNtwkInstance | _SetupOpActyNtwkInstance | 1 | |
| _StartDate | _StartDate | 1 | |
| _StartDateOffsetReferenceCode | _StartDateOffsetReferenceCode | 1 | |
| _TeardownOpActyNtwkInstance | _TeardownOpActyNtwkInstance | 1 | |
| _WorkCenter | _WorkCenter | 1 | |
| _WorkCenter_2 | _WorkCenter,_WorkCenter_2 | 2 | |
| _WorkCenterBySemanticKey | _WorkCenterBySemanticKey | 2 | |
| _WorkCenterType | _WorkCenterType | 1 | |
| _WorkCenterType_2 | _WorkCenterType,_WorkCenterType_2 | 2 | |
| ActualForecastDuration | ActualForecastDuration | 1 | |
| ActualForecastDurationUnit | ActualForecastDurationUnit | 1 | |
| ActualForecastEndDate | ActualForecastEndDate | 1 | |
| ActualForecastEndTime | ActualForecastEndTime | 1 | |
| BillOfOperationsGroup | BillOfOperationsGroup | 1 | |
| BillOfOperationsSequence | BillOfOperationsSequence | 1 | |
| BillOfOperationsType | BillOfOperationsType | 1 | |
| BillOfOperationsVariant | BillOfOperationsVariant | 1 | |
| BillOfOperationsVersion | BillOfOperationsVersion | 1 | |
| BOOOperationInternalID | BOOOperationInternalID | 1 | |
| BreakDurationUnit | BreakDurationUnit | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessProcess | BusinessProcess | 1 | |
| BusinessProcessConfirmedQty | BusinessProcessConfirmedQty | 1 | |
| BusinessProcessEntryUnit | BusinessProcessEntryUnit | 2 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| CapacityRequirementItem | CapacityRequirementItem | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ConfirmedBreakDuration | ConfirmedBreakDuration | 1 | |
| ControllingArea | ControllingArea | 1 | |
| ControllingObjectClass | ControllingObjectClass | 1 | |
| CostCtrActivityType1 | CostCtrActivityType1 | 1 | |
| CostCtrActivityType2 | CostCtrActivityType2 | 1 | |
| CostCtrActivityType3 | CostCtrActivityType3 | 1 | |
| CostCtrActivityType4 | CostCtrActivityType4 | 1 | |
| CostCtrActivityType5 | CostCtrActivityType5 | 1 | |
| CostCtrActivityType6 | CostCtrActivityType6 | 1 | |
| CostElement | CostElement | 1 | |
| CostEstimate | CostEstimate | 1 | |
| CostingSheet | CostingSheet | 1 | |
| CostingVariant | CostingVariant | 1 | |
| EmployeeSuitability | EmployeeSuitability | 1 | |
| EmployeeWageGroup | EmployeeWageGroup | 1 | |
| EmployeeWageType | EmployeeWageType | 1 | |
| EndDateOffsetDuration | EndDateOffsetDuration | 1 | |
| EndDateOffsetDurationUnit | EndDateOffsetDurationUnit | 1 | |
| EndDateOffsetReferenceCode | EndDateOffsetReferenceCode | 1 | |
| ForecastProcessingDuration | ForecastProcessingDuration | 1 | |
| ForecastProcessingDurationUnit | ForecastProcessingDurationUnit | 1 | |
| ForecastWorkQuantity1 | ForecastWorkQuantity1 | 1 | |
| ForecastWorkQuantity2 | ForecastWorkQuantity2 | 1 | |
| ForecastWorkQuantity3 | ForecastWorkQuantity3 | 1 | |
| ForecastWorkQuantity4 | ForecastWorkQuantity4 | 1 | |
| ForecastWorkQuantity5 | ForecastWorkQuantity5 | 1 | |
| ForecastWorkQuantity6 | ForecastWorkQuantity6 | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| GoodsRecipientName | GoodsRecipientName | 3 | |
| Language | Language | 2 | |
| LatestSchedldFcstdEndDate | LatestSchedldFcstdEndDate | 1 | |
| LatestSchedldFcstdStartDate | LatestSchedldFcstdStartDate | 1 | |
| LeadTimeReductionStrategy | LeadTimeReductionStrategy | 1 | |
| ManufacturingObject | ObjectInternalID | 1 | |
| ManufacturingOrder | ManufacturingOrder | 3 | |
| ManufacturingOrderCategory | ManufacturingOrderCategory | 3 | |
| ManufacturingOrderOperation | ManufacturingOrderOperation | 3 | |
| ManufacturingOrderOperation_2 | ManufacturingOrderOperation_2 | 1 | |
| ManufacturingOrderSequence | ManufacturingOrderSequence | 2 | |
| ManufacturingOrderSubOperation | ManufacturingOrderSubOperation | 2 | |
| ManufacturingOrderType | ManufacturingOrderType | 3 | |
| ManufacturingOrdSubOperation_2 | ManufacturingOrdSubOperation_2 | 1 | |
| MaximumNumberOfSplits | MaximumNumberOfSplits | 1 | |
| MaximumWaitDuration | MaximumWaitDuration | 1 | |
| MaximumWaitDurationUnit | MaximumWaitDurationUnit | 1 | |
| MfgOrderOperationIsPhase | MfgOrderOperationIsPhase | 2 | |
| MfgOrderOperationText | MfgOrderOperationText | 3 | |
| MfgOrderPhaseSuperiorOperation | MfgOrderPhaseSuperiorOperation | 1 | |
| MfgOrdPhaseSuperiorOperation_2 | MfgOrdPhaseSuperiorOperation_2 | 1 | |
| MinimumDuration | MinimumDuration | 1 | |
| MinimumDurationUnit | MinimumDurationUnit | 1 | |
| MinimumMoveDuration | MinimumMoveDuration | 1 | |
| MinimumMoveDurationUnit | MinimumMoveDurationUnit | 1 | |
| MinimumProcessingDuration | MinimumProcessingDuration | 1 | |
| MinimumProcessingDurationUnit | MinimumProcessingDurationUnit | 1 | |
| MinimumQueueDuration | MinimumQueueDuration | 1 | |
| MinimumQueueDurationUnit | MinimumQueueDurationUnit | 1 | |
| MinimumWaitDuration | MinimumWaitDuration | 1 | |
| MinimumWaitDurationUnit | MinimumWaitDurationUnit | 1 | |
| MRPController | MRPController | 1 | |
| NoFurtherBusinessProcQtyIsExpd | NoFurtherBusinessProcQtyIsExpd | 1 | |
| NoFurtherOpWorkQuantity1IsExpd | NoFurtherOpWorkQuantity1IsExpd | 1 | |
| NoFurtherOpWorkQuantity2IsExpd | NoFurtherOpWorkQuantity2IsExpd | 1 | |
| NoFurtherOpWorkQuantity3IsExpd | NoFurtherOpWorkQuantity3IsExpd | 1 | |
| NoFurtherOpWorkQuantity4IsExpd | NoFurtherOpWorkQuantity4IsExpd | 1 | |
| NoFurtherOpWorkQuantity5IsExpd | NoFurtherOpWorkQuantity5IsExpd | 1 | |
| NoFurtherOpWorkQuantity6IsExpd | NoFurtherOpWorkQuantity6IsExpd | 1 | |
| NumberOfCapacities | NumberOfCapacities | 1 | |
| NumberOfConfirmationSlips | NumberOfConfirmationSlips | 1 | |
| NumberOfEmployees | NumberOfEmployees | 1 | |
| NumberOfOperationConfirmations | NumberOfOperationConfirmations | 1 | |
| NumberOfOperationPriceUnits | NumberOfOperationPriceUnits | 1 | |
| NumberOfTimeTickets | NumberOfTimeTickets | 1 | |
| OpActualExecutionEndDate | OpActualExecutionEndDate | 3 | |
| OpActualExecutionEndTime | OpActualExecutionEndTime | 3 | |
| OpActualExecutionStartDate | OpActualExecutionStartDate | 3 | |
| OpActualExecutionStartTime | OpActualExecutionStartTime | 3 | |
| OpActualProcessingEndDate | OpActualProcessingEndDate | 1 | |
| OpActualProcessingEndTime | OpActualProcessingEndTime | 1 | |
| OpActualProcessingStartDate | OpActualProcessingStartDate | 1 | |
| OpActualProcessingStartTime | OpActualProcessingStartTime | 1 | |
| OpActualSetupEndDate | OpActualSetupEndDate | 1 | |
| OpActualSetupEndTime | OpActualSetupEndTime | 1 | |
| OpActualTeardownStartDate | OpActualTeardownStartDate | 1 | |
| OpActualTeardownStartTme | OpActualTeardownStartTme | 1 | |
| OpConfirmedWorkQuantity1 | OpConfirmedWorkQuantity1 | 1 | |
| OpConfirmedWorkQuantity2 | OpConfirmedWorkQuantity2 | 1 | |
| OpConfirmedWorkQuantity3 | OpConfirmedWorkQuantity3 | 1 | |
| OpConfirmedWorkQuantity4 | OpConfirmedWorkQuantity4 | 1 | |
| OpConfirmedWorkQuantity5 | OpConfirmedWorkQuantity5 | 1 | |
| OpConfirmedWorkQuantity6 | OpConfirmedWorkQuantity6 | 1 | |
| OperationConfirmation | OperationConfirmation | 1 | |
| OperationConfirmedEndDate | OperationConfirmedEndDate | 1 | |
| OperationConfirmedReworkQty | OperationConfirmedReworkQty | 2 | |
| OperationConfirmedStartDate | OperationConfirmedStartDate | 1 | |
| OperationControlProfile | OperationControlProfile | 1 | |
| OperationExecutionEndIsLate | OperationExecutionEndIsLate | 2 | |
| OperationExecutionStartIsLate | OperationExecutionStartIsLate | 2 | |
| OperationHasLongText | OperationHasLongText | 1 | |
| OperationImportance | OperationImportance | 1 | |
| OperationIsClosed | OperationIsClosed | 1 | |
| OperationIsConfirmed | OperationIsConfirmed | 2 | |
| OperationIsCreated | OperationIsCreated | 2 | |
| OperationIsDeleted | OperationIsDeleted | 1 | |
| OperationIsDelivered | OperationIsDelivered | 1 | |
| OperationIsPartiallyConfirmed | OperationIsPartiallyConfirmed | 2 | |
| OperationIsPartiallyDelivered | OperationIsPartiallyDelivered | 1 | |
| OperationIsPrinted | OperationIsPrinted | 1 | |
| OperationIsReleased | OperationIsReleased | 2 | |
| OperationIsScheduled | OperationIsScheduled | 1 | |
| OperationIsTechlyCompleted | OperationIsTechlyCompleted | 1 | |
| OperationOverlappingIsPossible | OperationOverlappingIsPossible | 1 | |
| OperationOverlappingIsRequired | OperationOverlappingIsRequired | 1 | |
| OperationReferenceQuantity | OperationReferenceQuantity | 1 | |
| OperationSetupGroup | OperationSetupGroup | 1 | |
| OperationSetupGroupCategory | OperationSetupGroupCategory | 1 | |
| OperationSetupType | OperationSetupType | 1 | |
| OperationsIsAlwaysOverlapping | OperationsIsAlwaysOverlapping | 1 | |
| OperationSplitIsRequired | OperationSplitIsRequired | 1 | |
| OperationStandardDuration | OperationStandardDuration | 1 | |
| OperationStandardDurationUnit | OperationStandardDurationUnit | 1 | |
| OperationStandardTextCode | OperationStandardTextCode | 1 | |
| OperationUnit | OperationUnit | 3 | |
| OperationYieldDeviationQty | OperationYieldDeviationQty | 1 | |
| OpErlstSchedldExecEndDte | OpErlstSchedldExecEndDte | 2 | |
| OpErlstSchedldExecEndTme | OpErlstSchedldExecEndTme | 2 | |
| OpErlstSchedldExecStrtDte | OpErlstSchedldExecStrtDte | 3 | |
| OpErlstSchedldExecStrtTme | OpErlstSchedldExecStrtTme | 3 | |
| OpErlstSchedldProcgStrtDte | OpErlstSchedldProcgStrtDte | 1 | |
| OpErlstSchedldProcgStrtTme | OpErlstSchedldProcgStrtTme | 1 | |
| OpErlstSchedldTrdwnStrtDte | OpErlstSchedldTrdwnStrtDte | 1 | |
| OpErlstSchedldTrdwnStrtTme | OpErlstSchedldTrdwnStrtTme | 1 | |
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | 1 | |
| OpExternalProcessingPrice | OpExternalProcessingPrice | 1 | |
| OpExternalProcessingPriceUnit | OpExternalProcessingPriceUnit | 1 | |
| OpLtstSchedldExecEndDte | OpLtstSchedldExecEndDte | 3 | |
| OpLtstSchedldExecEndTme | OpLtstSchedldExecEndTme | 2 | |
| OpLtstSchedldExecStrtDte | OpLtstSchedldExecStrtDte | 3 | |
| OpLtstSchedldExecStrtTme | OpLtstSchedldExecStrtTme | 2 | |
| OpLtstSchedldProcgStrtDte | OpLtstSchedldProcgStrtDte | 2 | |
| OpLtstSchedldProcgStrtTme | OpLtstSchedldProcgStrtTme | 2 | |
| OpLtstSchedldTrdwnStrtDte | OpLtstSchedldTrdwnStrtDte | 1 | |
| OpLtstSchedldTrdwnStrtTme | OpLtstSchedldTrdwnStrtTme | 1 | |
| OpPlannedProcessingDurn | OpPlannedProcessingDurn | 1 | |
| OpPlannedProcessingDurnUnit | OpPlannedProcessingDurnUnit | 1 | |
| OpPlannedScrapQuantity | OpPlannedScrapQuantity | 2 | |
| OpPlannedSetupDurn | OpPlannedSetupDurn | 1 | |
| OpPlannedSetupDurnUnit | OpPlannedSetupDurnUnit | 1 | |
| OpPlannedTeardownDurn | OpPlannedTeardownDurn | 1 | |
| OpPlannedTeardownDurnUnit | OpPlannedTeardownDurnUnit | 1 | |
| OpPlannedTotalQuantity | OpPlannedTotalQuantity | 3 | |
| OpPlannedYieldQuantity | OpPlannedYieldQuantity | 1 | |
| OpSchedldReductionLevel | OpSchedldReductionLevel | 1 | |
| OpTotalConfirmedScrapQty | OpTotalConfirmedScrapQty | 2 | |
| OpTotalConfirmedYieldQty | OpTotalConfirmedYieldQty | 3 | |
| OpTotConfdYieldQtyInOrdQtyUnit | OpTotConfdYieldQtyInOrdQtyUnit | 1 | |
| OpWorkQuantityUnit1 | OpWorkQuantityUnit1 | 1 | |
| OpWorkQuantityUnit2 | OpWorkQuantityUnit2 | 1 | |
| OpWorkQuantityUnit3 | OpWorkQuantityUnit3 | 1 | |
| OpWorkQuantityUnit4 | OpWorkQuantityUnit4 | 1 | |
| OpWorkQuantityUnit5 | OpWorkQuantityUnit5 | 1 | |
| OpWorkQuantityUnit6 | OpWorkQuantityUnit6 | 1 | |
| OverlapMinimumDuration | OverlapMinimumDuration | 1 | |
| OverlapMinimumDurationUnit | OverlapMinimumDurationUnit | 1 | |
| PlannedActualEndDateDvtnDurn | PlannedActualEndDateDvtnDurn | 1 | |
| PlannedActualStartDateDvtnDurn | PlannedActualStartDateDvtnDurn | 1 | |
| PlannedBreakDuration | PlannedBreakDuration | 1 | |
| PlannedCurrentEndDateDvtnDurn | PlannedCurrentEndDateDvtnDurn | 1 | |
| PlannedCurrentStrtDateDvtnDurn | PlannedCurrentStrtDateDvtnDurn | 1 | |
| PlannedDeliveryDuration | PlannedDeliveryDuration | 1 | |
| ProduceOpActyNtwkInstance | ProduceOpActyNtwkInstance | 1 | |
| ProductConfiguration | ProductConfiguration | 1 | |
| ProductionPlant | ProductionPlant | 3 | |
| ProductionSupervisor | ProductionSupervisor | 2 | |
| ProductionUnit | ProductionUnit | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| PurchaseOrder | PurchaseOrder | 1 | |
| PurchaseOrderItem | PurchaseOrderItem | 1 | |
| PurchaseRequisition | PurchaseRequisition | 1 | |
| PurchaseRequisitionItem | PurchaseRequisitionItem | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingInfoRecord | PurchasingInfoRecord | 1 | |
| PurchasingInfoRecordCategory | PurchasingInfoRecordCategory | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| PurgInfoRecdDataIsFixed | PurgInfoRecdDataIsFixed | 1 | |
| RequestingCostCenter | RequestingCostCenter | 1 | |
| ResponsiblePlannerGroup | ResponsiblePlannerGroup | 1 | |
| SchedldFcstdEarliestEndDate | SchedldFcstdEarliestEndDate | 1 | |
| SchedldFcstdEarliestEndTime | SchedldFcstdEarliestEndTime | 1 | |
| SchedldFcstdEarliestStartDate | SchedldFcstdEarliestStartDate | 1 | |
| SchedldFcstdEarliestStartTime | SchedldFcstdEarliestStartTime | 1 | |
| SchedldFcstdLatestEndTime | SchedldFcstdLatestEndTime | 1 | |
| SchedldFcstdLatestStartTime | SchedldFcstdLatestStartTime | 1 | |
| ScheduledMoveDuration | ScheduledMoveDuration | 1 | |
| ScheduledMoveDurationUnit | ScheduledMoveDurationUnit | 1 | |
| ScheduledQueueDuration | ScheduledQueueDuration | 1 | |
| ScheduledQueueDurationUnit | ScheduledQueueDurationUnit | 1 | |
| ScheduledWaitDuration | ScheduledWaitDuration | 1 | |
| ScheduledWaitDurationUnit | ScheduledWaitDurationUnit | 1 | |
| SetupOpActyNtwkInstance | SetupOpActyNtwkInstance | 1 | |
| StandardMoveDuration | StandardMoveDuration | 1 | |
| StandardMoveDurationUnit | StandardMoveDurationUnit | 1 | |
| StandardQueueDuration | StandardQueueDuration | 1 | |
| StandardQueueDurationUnit | StandardQueueDurationUnit | 1 | |
| StartDateOffsetDuration | StartDateOffsetDuration | 1 | |
| StartDateOffsetDurationUnit | StartDateOffsetDurationUnit | 1 | |
| StartDateOffsetReferenceCode | StartDateOffsetReferenceCode | 1 | |
| Supplier | Supplier | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TeardownOpActyNtwkInstance | TeardownOpActyNtwkInstance | 1 | |
| UnloadingPointName | UnloadingPointName | 3 | |
| WorkCenter | WorkCenter | 3 | |
| WorkCenterInternalID | WorkCenterInternalID | 3 | |
| WorkCenterStandardWorkQty1 | WorkCenterStandardWorkQty1 | 1 | |
| WorkCenterStandardWorkQty2 | WorkCenterStandardWorkQty2 | 1 | |
| WorkCenterStandardWorkQty3 | WorkCenterStandardWorkQty3 | 1 | |
| WorkCenterStandardWorkQty4 | WorkCenterStandardWorkQty4 | 1 | |
| WorkCenterStandardWorkQty5 | WorkCenterStandardWorkQty5 | 1 | |
| WorkCenterStandardWorkQty6 | WorkCenterStandardWorkQty6 | 1 | |
| WorkCenterStandardWorkQtyUnit1 | WorkCenterStandardWorkQtyUnit1 | 1 | |
| WorkCenterStandardWorkQtyUnit2 | WorkCenterStandardWorkQtyUnit2 | 1 | |
| WorkCenterStandardWorkQtyUnit3 | WorkCenterStandardWorkQtyUnit3 | 1 | |
| WorkCenterStandardWorkQtyUnit4 | WorkCenterStandardWorkQtyUnit4 | 1 | |
| WorkCenterStandardWorkQtyUnit5 | WorkCenterStandardWorkQtyUnit5 | 1 | |
| WorkCenterStandardWorkQtyUnit6 | WorkCenterStandardWorkQtyUnit6 | 1 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 2 | |
| WorkCenterTypeCode_2 | WorkCenterTypeCode,WorkCenterTypeCode_2 | 2 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Manufacturing Order Operation Delay Information
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROPERATIONDELAY (
ORDERINTBILLOFOPERATIONSITEM,
ORDERINTERNALBILLOFOPERATIONS,
_BILLOFOPERATIONSGROUP,
_BILLOFOPERATIONSSEQUENCE,
_BILLOFOPERATIONSTYPE,
_BILLOFOPERATIONSVARIANT,
_BUSINESSAREA,
_BUSINESSPROCESS,
_BUSINESSPROCESSENTRYUNIT,
_CAPACITYREQUIREMENT,
_CAPACITYREQUIREMENTITEM,
_COMPANYCODE,
_CONTROLLINGAREA,
_CONTROLLINGOBJECTCLASS,
_EMPLOYEESUITABILITY,
_EMPLOYEEWAGEGROUP,
_ENDDATEOFFSETREFERENCECODE,
_FUNCTIONALAREA,
_LANGUAGE,
_LEADTIMEREDUCTIONSTRATEGY,
_LONGTEXT,
_MFGORDER,
_MFGORDERCATEGORY,
_MFGORDERSEQUENCE,
_MFGORDERTYPE,
_MRPCONTROLLER,
_OPERATIONCONFIRMATION,
_OPERATIONCONTROLPROFILE,
_OPERATIONSETUPGROUP,
_OPERATIONSETUPGROUPCATEGORY,
_OPERATIONSETUPTYPE,
_OPERATIONSTANDARDTEXTCODE,
_OPERATIONUNIT,
_OPEXTERNALPROCESSINGCURRENCY,
_ORDINTERNALBILLOFOPERATIONS,
_PRODUCEOPACTYNTWKINSTANCE,
_PRODUCTIONPLANT,
_PRODUCTIONSUPERVISOR,
_PRODUCTIONUNIT,
_PROFITCENTER,
_PURCHASEORDER,
_PURCHASEORDERITEM,
_PURCHASINGGROUP,
_PURCHASINGINFORECORD,
_PURCHASINGORGANIZATION,
_RESPONSIBLEPLANNERGROUP,
_SETUPOPACTYNTWKINSTANCE,
_STARTDATE,
_STARTDATEOFFSETREFERENCECODE,
_TEARDOWNOPACTYNTWKINSTANCE,
_WORKCENTER,
_WORKCENTER_2,
_WORKCENTERBYSEMANTICKEY,
_WORKCENTERTYPE,
_WORKCENTERTYPE_2,
ACTUALFORECASTDURATION,
ACTUALFORECASTDURATIONUNIT,
ACTUALFORECASTENDDATE,
ACTUALFORECASTENDTIME,
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSSEQUENCE,
BILLOFOPERATIONSTYPE,
BILLOFOPERATIONSVARIANT,
BILLOFOPERATIONSVERSION,
BOOOPERATIONINTERNALID,
BREAKDURATIONUNIT,
BUSINESSAREA,
BUSINESSPROCESS,
BUSINESSPROCESSCONFIRMEDQTY,
BUSINESSPROCESSENTRYUNIT,
CAPACITYREQUIREMENT,
CAPACITYREQUIREMENTITEM,
COMPANYCODE,
CONFIRMEDBREAKDURATION,
CONTROLLINGAREA,
CONTROLLINGOBJECTCLASS,
COSTCTRACTIVITYTYPE1,
COSTCTRACTIVITYTYPE2,
COSTCTRACTIVITYTYPE3,
COSTCTRACTIVITYTYPE4,
COSTCTRACTIVITYTYPE5,
COSTCTRACTIVITYTYPE6,
COSTELEMENT,
COSTESTIMATE,
COSTINGSHEET,
COSTINGVARIANT,
EMPLOYEESUITABILITY,
EMPLOYEEWAGEGROUP,
EMPLOYEEWAGETYPE,
ENDDATEOFFSETDURATION,
ENDDATEOFFSETDURATIONUNIT,
ENDDATEOFFSETREFERENCECODE,
FORECASTPROCESSINGDURATION,
FORECASTPROCESSINGDURATIONUNIT,
FORECASTWORKQUANTITY1,
FORECASTWORKQUANTITY2,
FORECASTWORKQUANTITY3,
FORECASTWORKQUANTITY4,
FORECASTWORKQUANTITY5,
FORECASTWORKQUANTITY6,
FUNCTIONALAREA,
GOODSRECIPIENTNAME,
LANGUAGE,
LATESTSCHEDLDFCSTDENDDATE,
LATESTSCHEDLDFCSTDSTARTDATE,
LEADTIMEREDUCTIONSTRATEGY,
MANUFACTURINGOBJECT,
MANUFACTURINGORDER,
MANUFACTURINGORDERCATEGORY,
MANUFACTURINGORDEROPERATION,
MANUFACTURINGORDEROPERATION_2,
MANUFACTURINGORDERSEQUENCE,
MANUFACTURINGORDERSUBOPERATION,
MANUFACTURINGORDERTYPE,
MANUFACTURINGORDSUBOPERATION_2,
MAXIMUMNUMBEROFSPLITS,
MAXIMUMWAITDURATION,
MAXIMUMWAITDURATIONUNIT,
MFGORDEROPERATIONISPHASE,
MFGORDEROPERATIONTEXT,
MFGORDERPHASESUPERIOROPERATION,
MFGORDPHASESUPERIOROPERATION_2,
MINIMUMDURATION,
MINIMUMDURATIONUNIT,
MINIMUMMOVEDURATION,
MINIMUMMOVEDURATIONUNIT,
MINIMUMPROCESSINGDURATION,
MINIMUMPROCESSINGDURATIONUNIT,
MINIMUMQUEUEDURATION,
MINIMUMQUEUEDURATIONUNIT,
MINIMUMWAITDURATION,
MINIMUMWAITDURATIONUNIT,
MRPCONTROLLER,
NOFURTHERBUSINESSPROCQTYISEXPD,
NOFURTHEROPWORKQUANTITY1ISEXPD,
NOFURTHEROPWORKQUANTITY2ISEXPD,
NOFURTHEROPWORKQUANTITY3ISEXPD,
NOFURTHEROPWORKQUANTITY4ISEXPD,
NOFURTHEROPWORKQUANTITY5ISEXPD,
NOFURTHEROPWORKQUANTITY6ISEXPD,
NUMBEROFCAPACITIES,
NUMBEROFCONFIRMATIONSLIPS,
NUMBEROFEMPLOYEES,
NUMBEROFOPERATIONCONFIRMATIONS,
NUMBEROFOPERATIONPRICEUNITS,
NUMBEROFTIMETICKETS,
OPACTUALEXECUTIONENDDATE,
OPACTUALEXECUTIONENDTIME,
OPACTUALEXECUTIONSTARTDATE,
OPACTUALEXECUTIONSTARTTIME,
OPACTUALPROCESSINGENDDATE,
OPACTUALPROCESSINGENDTIME,
OPACTUALPROCESSINGSTARTDATE,
OPACTUALPROCESSINGSTARTTIME,
OPACTUALSETUPENDDATE,
OPACTUALSETUPENDTIME,
OPACTUALTEARDOWNSTARTDATE,
OPACTUALTEARDOWNSTARTTME,
OPCONFIRMEDWORKQUANTITY1,
OPCONFIRMEDWORKQUANTITY2,
OPCONFIRMEDWORKQUANTITY3,
OPCONFIRMEDWORKQUANTITY4,
OPCONFIRMEDWORKQUANTITY5,
OPCONFIRMEDWORKQUANTITY6,
OPERATIONCONFIRMATION,
OPERATIONCONFIRMEDENDDATE,
OPERATIONCONFIRMEDREWORKQTY,
OPERATIONCONFIRMEDSTARTDATE,
OPERATIONCONTROLPROFILE,
OPERATIONEXECUTIONENDISLATE,
OPERATIONEXECUTIONSTARTISLATE,
OPERATIONHASLONGTEXT,
OPERATIONIMPORTANCE,
OPERATIONISCLOSED,
OPERATIONISCONFIRMED,
OPERATIONISCREATED,
OPERATIONISDELETED,
OPERATIONISDELIVERED,
OPERATIONISPARTIALLYCONFIRMED,
OPERATIONISPARTIALLYDELIVERED,
OPERATIONISPRINTED,
OPERATIONISRELEASED,
OPERATIONISSCHEDULED,
OPERATIONISTECHLYCOMPLETED,
OPERATIONOVERLAPPINGISPOSSIBLE,
OPERATIONOVERLAPPINGISREQUIRED,
OPERATIONREFERENCEQUANTITY,
OPERATIONSETUPGROUP,
OPERATIONSETUPGROUPCATEGORY,
OPERATIONSETUPTYPE,
OPERATIONSISALWAYSOVERLAPPING,
OPERATIONSPLITISREQUIRED,
OPERATIONSTANDARDDURATION,
OPERATIONSTANDARDDURATIONUNIT,
OPERATIONSTANDARDTEXTCODE,
OPERATIONUNIT,
OPERATIONYIELDDEVIATIONQTY,
OPERLSTSCHEDLDEXECENDDTE,
OPERLSTSCHEDLDEXECENDTME,
OPERLSTSCHEDLDEXECSTRTDTE,
OPERLSTSCHEDLDEXECSTRTTME,
OPERLSTSCHEDLDPROCGSTRTDTE,
OPERLSTSCHEDLDPROCGSTRTTME,
OPERLSTSCHEDLDTRDWNSTRTDTE,
OPERLSTSCHEDLDTRDWNSTRTTME,
OPEXTERNALPROCESSINGCURRENCY,
OPEXTERNALPROCESSINGPRICE,
OPEXTERNALPROCESSINGPRICEUNIT,
OPLTSTSCHEDLDEXECENDDTE,
OPLTSTSCHEDLDEXECENDTME,
OPLTSTSCHEDLDEXECSTRTDTE,
OPLTSTSCHEDLDEXECSTRTTME,
OPLTSTSCHEDLDPROCGSTRTDTE,
OPLTSTSCHEDLDPROCGSTRTTME,
OPLTSTSCHEDLDTRDWNSTRTDTE,
OPLTSTSCHEDLDTRDWNSTRTTME,
OPPLANNEDPROCESSINGDURN,
OPPLANNEDPROCESSINGDURNUNIT,
OPPLANNEDSCRAPQUANTITY,
OPPLANNEDSETUPDURN,
OPPLANNEDSETUPDURNUNIT,
OPPLANNEDTEARDOWNDURN,
OPPLANNEDTEARDOWNDURNUNIT,
OPPLANNEDTOTALQUANTITY,
OPPLANNEDYIELDQUANTITY,
OPSCHEDLDREDUCTIONLEVEL,
OPTOTALCONFIRMEDSCRAPQTY,
OPTOTALCONFIRMEDYIELDQTY,
OPTOTCONFDYIELDQTYINORDQTYUNIT,
OPWORKQUANTITYUNIT1,
OPWORKQUANTITYUNIT2,
OPWORKQUANTITYUNIT3,
OPWORKQUANTITYUNIT4,
OPWORKQUANTITYUNIT5,
OPWORKQUANTITYUNIT6,
OVERLAPMINIMUMDURATION,
OVERLAPMINIMUMDURATIONUNIT,
PLANNEDACTUALENDDATEDVTNDURN,
PLANNEDACTUALSTARTDATEDVTNDURN,
PLANNEDBREAKDURATION,
PLANNEDCURRENTENDDATEDVTNDURN,
PLANNEDCURRENTSTRTDATEDVTNDURN,
PLANNEDDELIVERYDURATION,
PRODUCEOPACTYNTWKINSTANCE,
PRODUCTCONFIGURATION,
PRODUCTIONPLANT,
PRODUCTIONSUPERVISOR,
PRODUCTIONUNIT,
PROFITCENTER,
PURCHASEORDER,
PURCHASEORDERITEM,
PURCHASEREQUISITION,
PURCHASEREQUISITIONITEM,
PURCHASINGGROUP,
PURCHASINGINFORECORD,
PURCHASINGINFORECORDCATEGORY,
PURCHASINGORGANIZATION,
PURGINFORECDDATAISFIXED,
REQUESTINGCOSTCENTER,
RESPONSIBLEPLANNERGROUP,
SCHEDLDFCSTDEARLIESTENDDATE,
SCHEDLDFCSTDEARLIESTENDTIME,
SCHEDLDFCSTDEARLIESTSTARTDATE,
SCHEDLDFCSTDEARLIESTSTARTTIME,
SCHEDLDFCSTDLATESTENDTIME,
SCHEDLDFCSTDLATESTSTARTTIME,
SCHEDULEDMOVEDURATION,
SCHEDULEDMOVEDURATIONUNIT,
SCHEDULEDQUEUEDURATION,
SCHEDULEDQUEUEDURATIONUNIT,
SCHEDULEDWAITDURATION,
SCHEDULEDWAITDURATIONUNIT,
SETUPOPACTYNTWKINSTANCE,
STANDARDMOVEDURATION,
STANDARDMOVEDURATIONUNIT,
STANDARDQUEUEDURATION,
STANDARDQUEUEDURATIONUNIT,
STARTDATEOFFSETDURATION,
STARTDATEOFFSETDURATIONUNIT,
STARTDATEOFFSETREFERENCECODE,
SUPPLIER,
TAXJURISDICTION,
TEARDOWNOPACTYNTWKINSTANCE,
UNLOADINGPOINTNAME,
WORKCENTER,
WORKCENTERINTERNALID,
WORKCENTERSTANDARDWORKQTY1,
WORKCENTERSTANDARDWORKQTY2,
WORKCENTERSTANDARDWORKQTY3,
WORKCENTERSTANDARDWORKQTY4,
WORKCENTERSTANDARDWORKQTY5,
WORKCENTERSTANDARDWORKQTY6,
WORKCENTERSTANDARDWORKQTYUNIT1,
WORKCENTERSTANDARDWORKQTYUNIT2,
WORKCENTERSTANDARDWORKQTYUNIT3,
WORKCENTERSTANDARDWORKQTYUNIT4,
WORKCENTERSTANDARDWORKQTYUNIT5,
WORKCENTERSTANDARDWORKQTYUNIT6,
WORKCENTERTYPECODE,
WORKCENTERTYPECODE_2,
PRIMARY KEY (ORDERINTBILLOFOPERATIONSITEM, ORDERINTERNALBILLOFOPERATIONS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA