I_MFGORDEROPERATIONDURN
Manufacturing Order Operation Duration
I_MFGORDEROPERATIONDURN is a CDS View in S/4HANA. Manufacturing Order Operation Duration. It contains 43 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ProcessOrderOperation | view_entity | from | COMPOSITE | API for Process Order Operations |
| A_ProcessOrderOperation_2 | view_entity | from | COMPOSITE | Process Order Operations |
| A_ProductionOrderOperation | view_entity | from | COMPOSITE | API Production Order Operations |
| A_ProductionOrderOperation_2 | view_entity | from | COMPOSITE | Production Order Operations |
| C_MfgOrderObjPgOpr | view | from | CONSUMPTION | Manufacturing Order Opr : Object Page |
| C_ProcessOrderObjPgOpr | view_entity | from | CONSUMPTION | Manufacturing Order Opr : Object Page |
| I_MfgOrderWrkcntrOper | view_entity | from | COMPOSITE | Workcenter Manufacturing Order Operations |
Fields (43)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | 2 |
| KEY | OrderInternalBillOfOperations | OrderInternalBillOfOperations | 2 |
| _BusinessProcessEntryUnit | _BusinessProcessEntryUnit | 2 | |
| _MfgOrder | _MfgOrder | 2 | |
| _MfgOrderCategory | _MfgOrderCategory | 2 | |
| _MfgOrderSequence | _MfgOrderSequence | 2 | |
| _MfgOrderType | _MfgOrderType | 2 | |
| _OrdInternalBillOfOperations | _OrdInternalBillOfOperations | 2 | |
| _ProductionPlant | _ProductionPlant | 1 | |
| _WorkCenter_2 | _WorkCenter | 1 | |
| _WorkCenterBySemanticKey | _WorkCenterBySemanticKey | 1 | |
| _WorkCenterType_2 | _WorkCenterType | 1 | |
| BusinessProcessEntryUnit | BusinessProcessEntryUnit | 2 | |
| ErlstSchedldExecDurnInWorkdays | ErlstSchedldExecDurnInWorkdays | 2 | |
| ManufacturingOrder | ManufacturingOrder | 2 | |
| ManufacturingOrderCategory | ManufacturingOrderCategory | 2 | |
| ManufacturingOrderOperation | ManufacturingOrderOperation | 1 | |
| ManufacturingOrderSequence | ManufacturingOrderSequence | 2 | |
| ManufacturingOrderSubOperation | ManufacturingOrderSubOperation | 1 | |
| ManufacturingOrderType | ManufacturingOrderType | 2 | |
| MfgOrderOperationIsPhase | MfgOrderOperationIsPhase | 2 | |
| MfgOrderOperationText | MfgOrderOperationText | 2 | |
| OpActualExecutionDays | OpActualExecutionDays | 2 | |
| OpActualExecutionEndDate | OpActualExecutionEndDate | 2 | |
| OpActualExecutionEndTime | OpActualExecutionEndTime | 2 | |
| OpActualExecutionStartDate | OpActualExecutionStartDate | 2 | |
| OpActualExecutionStartTime | OpActualExecutionStartTime | 2 | |
| OperationIsConfirmed | OperationIsConfirmed | 1 | |
| OperationIsCreated | OperationIsCreated | 1 | |
| OperationIsPartiallyConfirmed | OperationIsPartiallyConfirmed | 1 | |
| OperationIsReleased | OperationIsReleased | 1 | |
| OperationUnit | OperationUnit | 2 | |
| OpErlstSchedldExecEndDte | OpErlstSchedldExecEndDte | 2 | |
| OpErlstSchedldExecEndTme | OpErlstSchedldExecEndTme | 2 | |
| OpErlstSchedldExecStrtDte | OpErlstSchedldExecStrtDte | 2 | |
| OpErlstSchedldExecStrtTme | OpErlstSchedldExecStrtTme | 2 | |
| OpPlannedTotalQuantity | OpPlannedTotalQuantity | 2 | |
| OpTotalConfirmedYieldQty | OpTotalConfirmedYieldQty | 2 | |
| ProductionPlant | ProductionPlant | 1 | |
| WorkCenter | WorkCenter | 2 | |
| WorkCenterInternalID | ProductionResourceInternalID,WorkCenterInternalID | 2 | |
| WorkCenterTypeCode | ProductionResourceType | 1 | |
| WorkCenterTypeCode_2 | WorkCenterTypeCode | 1 |
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 Duration
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROPERATIONDURN (
ORDERINTBILLOFOPERATIONSITEM,
ORDERINTERNALBILLOFOPERATIONS,
_BUSINESSPROCESSENTRYUNIT,
_MFGORDER,
_MFGORDERCATEGORY,
_MFGORDERSEQUENCE,
_MFGORDERTYPE,
_ORDINTERNALBILLOFOPERATIONS,
_PRODUCTIONPLANT,
_WORKCENTER_2,
_WORKCENTERBYSEMANTICKEY,
_WORKCENTERTYPE_2,
BUSINESSPROCESSENTRYUNIT,
ERLSTSCHEDLDEXECDURNINWORKDAYS,
MANUFACTURINGORDER,
MANUFACTURINGORDERCATEGORY,
MANUFACTURINGORDEROPERATION,
MANUFACTURINGORDERSEQUENCE,
MANUFACTURINGORDERSUBOPERATION,
MANUFACTURINGORDERTYPE,
MFGORDEROPERATIONISPHASE,
MFGORDEROPERATIONTEXT,
OPACTUALEXECUTIONDAYS,
OPACTUALEXECUTIONENDDATE,
OPACTUALEXECUTIONENDTIME,
OPACTUALEXECUTIONSTARTDATE,
OPACTUALEXECUTIONSTARTTIME,
OPERATIONISCONFIRMED,
OPERATIONISCREATED,
OPERATIONISPARTIALLYCONFIRMED,
OPERATIONISRELEASED,
OPERATIONUNIT,
OPERLSTSCHEDLDEXECENDDTE,
OPERLSTSCHEDLDEXECENDTME,
OPERLSTSCHEDLDEXECSTRTDTE,
OPERLSTSCHEDLDEXECSTRTTME,
OPPLANNEDTOTALQUANTITY,
OPTOTALCONFIRMEDYIELDQTY,
PRODUCTIONPLANT,
WORKCENTER,
WORKCENTERINTERNALID,
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