I_MFGORDEROPERATIONBASIC

CDS View

Manufacturing Order Operation Basic

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

CDS Views using this table (12)

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_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
I_ProcOrderOperationCapacity view_entity from COMPOSITE Individual Capacity of Process Order Operation
I_ProdnOrderOperationCapacity view_entity from COMPOSITE Individual Capacity of Production Order Operation
I_ProdnOrderOperationLongText view_entity inner COMPOSITE Production Order Operation - Text
I_ProductionOrderTriggerPoint view_entity inner COMPOSITE Production Order Trigger Point
P_MfgOrderFirstOperation view from CONSUMPTION Manufacturing Order First Operation

Fields (26)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 3
KEY ManufacturingOrderOperation_2 ManufacturingOrderOperation,ProcessOrderOperation 4
KEY ManufacturingOrderSequence ManufacturingOrderSequence 4
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem,OrderOperationInternalID 9
KEY OrderInternalBillOfOperations MfgOrderInternalID,OrderInternalBillOfOperations,OrderInternalID 9
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
_OperationControlProfile _OperationControlProfile 2
_OrderInternalID _OrderInternalID 2
_ProductionPlant _ProductionPlant 2
Language LongTextLanguage 1
ManufacturingOrderCategory ManufacturingOrderCategory 5
ManufacturingOrderOperation ManufacturingOrderOperation 1
ManufacturingOrderType ManufacturingOrderType,ProcessOrderType 3
MfgOrderOperationIsPhase MfgOrderOperationIsPhase,OperationIsPhase 3
MfgOrderOperationText MfgOrderOperationText,OrderOperationText 4
NumberOfOperationConfirmations NumberOfOperationConfirmations 1
OperationConfirmation OperationConfirmation 1
OperationControlProfile OperationControlProfile 1
OperationIsSubOperation OperationIsSubOperation 1
ProduceOpActyNtwkInstance OpActyNtwkInstance 1
ProductionPlant Plant,ProductionPlant 6
SuperiorOperationIntIDOfPhase SuperiorOperationIntIDOfPhase 1
WorkCenterInternalID WorkCenterInternalID 6
WorkCenterTypeCode WorkCenterTypeCode 1
WorkCenterTypeCode_2 WorkCenterType,WorkCenterTypeCode,WorkCenterTypeCode_2 5

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,
    _ORDERINTERNALID,
    _PRODUCTIONPLANT,
    LANGUAGE,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERTYPE,
    MFGORDEROPERATIONISPHASE,
    MFGORDEROPERATIONTEXT,
    NUMBEROFOPERATIONCONFIRMATIONS,
    OPERATIONCONFIRMATION,
    OPERATIONCONTROLPROFILE,
    OPERATIONISSUBOPERATION,
    PRODUCEOPACTYNTWKINSTANCE,
    PRODUCTIONPLANT,
    SUPERIOROPERATIONINTIDOFPHASE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    WORKCENTERTYPECODE_2,
    PRIMARY KEY (MANUFACTURINGORDER, MANUFACTURINGORDEROPERATION_2, MANUFACTURINGORDERSEQUENCE, ORDERINTBILLOFOPERATIONSITEM, ORDERINTERNALBILLOFOPERATIONS)
);