I_MFGORDEROPERATIONDURN

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);