I_MFGORDEROPERATIONBASIC

CDS View

Manufacturing Order Operation Basic

I_MFGORDEROPERATIONBASIC is a CDS View in S/4HANA. Manufacturing Order Operation Basic. It contains 24 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_ProdnOrderForSafetyInsights view inner CONSUMPTION Production Orders for Safety Insights
C_ShopFloorItemOperation view inner CONSUMPTION Shop Floor Item Operation
I_MfgOrderOperationBasicStdVH view_entity from COMPOSITE Manufacturing Order Operation Basic
I_MfgOrderOperationBySemKey view from COMPOSITE Manufacturing Order Operation By Semantic Key
I_MfgOrderOperationConfCube view inner COMPOSITE Manufacturing Order Operation Confirmation - Cube
I_MfgOrderOperationLongText view_entity inner COMPOSITE Manufacturing Order Operation - Text
I_MfgOrderOperationPickList view from COMPOSITE Mfg Order Operation (Pick List)
I_MfgOrderOperationTrggrPoint view inner COMPOSITE Manufacturing Order Operation Trigger Point
P_MfgOrderFirstOperation view from CONSUMPTION

Fields (24)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 3
KEY ManufacturingOrderOperation_2 ManufacturingOrderOperation 2
KEY ManufacturingOrderSequence ManufacturingOrderSequence 3
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem,OrderOperationInternalID 5
KEY OrderInternalBillOfOperations MfgOrderInternalID,OrderInternalBillOfOperations,OrderInternalID 5
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
_OperationControlProfile _OperationControlProfile 1
_ProductionPlant _ProductionPlant 1
Language LongTextLanguage 1
ManufacturingOrderCategory ManufacturingOrderCategory 3
ManufacturingOrderOperation ManufacturingOrderOperation 1
ManufacturingOrderType ManufacturingOrderType 2
MfgOrderOperationIsPhase MfgOrderOperationIsPhase 2
MfgOrderOperationText MfgOrderOperationText 3
NumberOfOperationConfirmations NumberOfOperationConfirmations 1
OperationConfirmation OperationConfirmation 1
OperationControlProfile OperationControlProfile 1
OperationIsSubOperation OperationIsSubOperation 1
ProduceOpActyNtwkInstance OpActyNtwkInstance 1
ProductionPlant ProductionPlant 3
WorkCenterInternalID WorkCenterInternalID 3
WorkCenterTypeCode WorkCenterTypeCode 1
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 Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROPERATIONBASIC (
    MANUFACTURINGORDER,
    MANUFACTURINGORDEROPERATION_2,
    MANUFACTURINGORDERSEQUENCE,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALBILLOFOPERATIONS,
    _MFGORDERCATEGORY,
    _MFGORDERTYPE,
    _OPERATIONCONTROLPROFILE,
    _PRODUCTIONPLANT,
    LANGUAGE,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERTYPE,
    MFGORDEROPERATIONISPHASE,
    MFGORDEROPERATIONTEXT,
    NUMBEROFOPERATIONCONFIRMATIONS,
    OPERATIONCONFIRMATION,
    OPERATIONCONTROLPROFILE,
    OPERATIONISSUBOPERATION,
    PRODUCEOPACTYNTWKINSTANCE,
    PRODUCTIONPLANT,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    WORKCENTERTYPECODE_2,
    PRIMARY KEY (MANUFACTURINGORDER, MANUFACTURINGORDEROPERATION_2, MANUFACTURINGORDERSEQUENCE, ORDERINTBILLOFOPERATIONSITEM, ORDERINTERNALBILLOFOPERATIONS)
);