I_MFGORDEROPERATIONCOMPONENT

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 Component
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROPERATIONCOMPONENT (
    MANUFACTURINGORDER,
    MATERIAL,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALBILLOFOPERATIONS,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _ACCOUNTASSIGNMENTCATEGORY,
    _ASSEMBLYMRPCONTROLLER,
    _BASEUNIT,
    _BATCH,
    _BATCHSPLITTYPE,
    _BOMEXPLOSION,
    _BOMITEMCATEGORY,
    _BUSINESSAREA,
    _CHANGENUMBER,
    _COMPANYCODE,
    _CONSUMPTIONPOSTING,
    _CURRENCY,
    _DEBITCREDITCODE,
    _ENTRYUNIT,
    _FUNCTIONALAREA,
    _GLACCOUNT,
    _GOODSMOVEMENTTYPE,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYSPECIALSTOCKVALNTYPE,
    _LONGTEXT,
    _LONGTEXTLANGUAGE,
    _MANUFACTURINGORDER,
    _MATERIAL,
    _MATERIALGROUP,
    _MATLCOMPDISCONTINUATIONTYPE,
    _MFGORDER,
    _MFGORDERCATEGORY,
    _MFGORDERCOMPONENTLONGTEXT,
    _MFGORDEROPERATION,
    _MFGORDEROPERATIONBYSEMANKEY,
    _MFGORDEROPERATIONBYSEMKEY,
    _MFGORDERSEQUENCE,
    _MFGORDERTYPE,
    _ORDERINTERNALID,
    _ORDINTERNALBILLOFOPERATIONS,
    _ORIGINALRESERVATIONITEM,
    _PLANT,
    _PRODUCT,
    _PRODUCTIONPLANT,
    _PRODUCTIONSUPERVISOR,
    _PRODUCTPLANT,
    _PRODUCTPLANT2,
    _PURCHASEORDER,
    _PURCHASEORDERITEM,
    _PURCHASEREQUISITION,
    _PURCHASEREQUISITIONITEM,
    _PURCHASEREQUISITIONITEM2,
    _PURCHASINGGROUP,
    _PURCHASINGINFORECORD,
    _REQUIREMENTTYPE,
    _RESERVATION,
    _RESERVATIONDOCRECORDTYPE,
    _RESERVATIONITEM,
    _SALESORDER,
    _SALESORDERITEM,
    _STORAGELOCATION,
    _SUPPLYAREA,
    _WAREHOUSE,
    _WBSELEMENT,
    ACCOUNTASSIGNMENTCATEGORY,
    ALTERNATIVEITEMGROUP,
    ALTERNATIVEITEMPRIORITY,
    ALTERNATIVEITEMSTRATEGY,
    ALTERNATIVEMSTRRESERVATIONITEM,
    ASSEMBLY,
    ASSEMBLYMRPCONTROLLER,
    BASEUNIT,
    BATCH,
    BATCHMASTERRESERVATIONITEM,
    BATCHSPLITTYPE,
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALINTERNALID_2,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMNUMBER_2,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BOMEXPLOSIONDATEID,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMDESCRIPTION,
    BOMITEMINTERNALCHANGECOUNT,
    BUSINESSAREA,
    CHANGENUMBER,
    COMPANYCODE,
    COMPONENTSCRAPINPERCENT,
    CONFIRMEDAVAILABLEQUANTITY,
    CONSUMPTIONPOSTING,
    CURRENCY,
    DEBITCREDITCODE,
    DELIVERYDURATIONINDAYS,
    DISCONTINUATIONGROUP,
    EFFECTIVITYPARAMETERVARIANT,
    ENTRYUNIT,
    FOLLOWUPMATERIAL,
    FOLLOWUPMATERIALISACTIVE,
    FORMULAKEY,
    FUNCTIONALAREA,
    GLACCOUNT,
    GOODSMOVEMENTENTRYQTY,
    GOODSMOVEMENTISALLOWED,
    GOODSMOVEMENTTYPE,
    GOODSRECIPIENTNAME,
    INHERITEDBOMITEMNODE,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    ISBULKMATERIALCOMPONENT,
    ISNETSCRAP,
    LEADTIMEOFFSET,
    LONGTEXTEXISTS,
    LONGTEXTLANGUAGECODE,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDEROPERATION_2,
    MANUFACTURINGORDERSEQUENCE,
    MANUFACTURINGORDERTYPE,
    MATERIALCOMPISALTERNATIVEITEM,
    MATERIALCOMPISCOSTRELEVANT,
    MATERIALCOMPISINTRAMATERIAL,
    MATERIALCOMPISVARIABLESIZED,
    MATERIALCOMPONENTISCLASSIFIED,
    MATERIALCOMPONENTISMISSING,
    MATERIALCOMPONENTISPHANTOMITEM,
    MATERIALCOMPONENTSORTTEXT,
    MATERIALCOMPORIGINALQUANTITY,
    MATERIALGROUP,
    MATLCOMPDISCONTINUATIONTYPE,
    MATLCOMPISCONFIGURABLE,
    MATLCOMPISFOLLOWUPMATERIAL,
    MATLCOMPISMARKEDFORBACKFLUSH,
    MATLCOMPISMARKEDFORDELETION,
    MATLCOMPISTEXTITEM,
    MATLCOMPREQUIREMENTDATE,
    MATLCOMPREQUIREMENTTIME,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONLEADTIMEOFFSETUNIT,
    OPERATIONSCRAPINPERCENT,
    ORDERLEVELVALUE,
    ORDERPATHVALUE,
    ORIGINALRESERVATION,
    ORIGINALRESERVATIONITEM,
    PRODUCTCONFIGURATION,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    QUANTITYISFIXED,
    REQUIREDQUANTITY,
    REQUIREMENTSEGMENT,
    REQUIREMENTTYPE,
    RESERVATIONISFINALLYISSUED,
    RESERVATIONITEMCREATIONCODE,
    SALESORDER,
    SALESORDERITEM,
    SORTFIELD,
    STOCKSEGMENT,
    STORAGEBIN,
    STORAGELOCATION,
    STORAGETYPE,
    SUPPLIER,
    SUPPLYAREA,
    UNLOADINGPOINTNAME,
    USAGEPROBABILITYPERCENT,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    VARIABLESIZEITEMQUANTITY,
    VARIABLESIZEITEMUNIT,
    WAREHOUSE,
    WBSELEMENTINTERNALID,
    WBSELEMENTINTERNALID_2,
    WITHDRAWNQUANTITY,
    WITHDRAWNQUANTITYAMOUNT,
    PRIMARY KEY (MANUFACTURINGORDER, MATERIAL, ORDERINTBILLOFOPERATIONSITEM, ORDERINTERNALBILLOFOPERATIONS, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);