I_MANUFACTURINGORDERCOMPONENT

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 Component
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MANUFACTURINGORDERCOMPONENT (
    RESERVATION,
    RESERVATIONITEM,
    RESERVATIONRECORDTYPE,
    _ACCOUNTASSIGNMENTCATEGORY,
    _ASSEMBLYMRPCONTROLLER,
    _BASEUNIT,
    _BATCH,
    _BATCHSPLITTYPE,
    _BILLOFMATERIALITEM,
    _BOMEXPLOSION,
    _BOMITEMCATEGORY,
    _BUSINESSAREA,
    _BUSINESSAREATEXT,
    _CHANGENUMBER,
    _COMPANYCODE,
    _COMPANYCODETEXT,
    _CONSUMPTIONPOSTING,
    _CONTROLLINGAREA,
    _CONTROLLINGAREATEXT,
    _CURRENCY,
    _DEBITCREDITCODE,
    _DISCONTINUATIONTYPE,
    _EARMARKEDFUNDS,
    _EARMARKEDFUNDSITEM,
    _ENTERPRISEPROJECTELEMENT,
    _ENTRYUNIT,
    _FOLLOWUPMATERIAL,
    _FOLLOWUPMATERIALTEXT,
    _FUNCTIONALAREA,
    _FUNCTIONALAREATEXT,
    _GLACCOUNT,
    _GOODSMOVEMENTTYPE,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYSPECIALSTOCKVALNTYPE,
    _LONGTEXTLANGUAGE,
    _MATERIAL,
    _MATERIALGROUP,
    _MATERIALREVISIONLEVEL,
    _MATERIALTEXT,
    _MFGORDER,
    _MFGORDERCATEGORY,
    _MFGORDERCOMPONENTLONGTEXT,
    _MFGORDEROPERATION,
    _MFGORDEROPERATIONBYSEMKEY,
    _MFGORDERSEQUENCE,
    _MFGORDERSEQUENCECATEGORY,
    _MFGORDERTEXT,
    _MFGORDERTYPE,
    _OPLEADTIMEOFFSETUNIT,
    _ORDERINTERNALID,
    _PHANTOMASSEMBLY,
    _PHANTOMASSEMBLYTEXT,
    _PLANT,
    _PLANTTEXT,
    _PRODUCT,
    _PRODUCTIONPLANT,
    _PRODUCTIONPLANTTEXT,
    _PRODUCTIONSUPERVISOR,
    _PRODUCTPLANT,
    _PRODUCTSTORAGELOCATION,
    _PRODUCTSUPPLYPLANNING,
    _PRODUCTUNITSOFMEASURE,
    _PROVISIONTYPE,
    _PURCHASEORDER,
    _PURCHASEORDERITEM,
    _PURCHASEREQUISITION,
    _PURCHASEREQUISITIONITEM,
    _PURCHASINGGROUP,
    _PURCHASINGGROUPTEXT,
    _PURCHASINGINFORECORD,
    _REQUIREMENTTYPE,
    _RESERVATION,
    _RESERVATIONITEM,
    _RESERVATIONRECORDTYPE,
    _SALESORDER,
    _SALESORDERITEM,
    _SPAREPARTTYPE,
    _STATUSOBJECT,
    _STATUSOBJECTTEXT,
    _STORAGELOCATION,
    _STORAGELOCATIONTEXT,
    _SUPPLIER,
    _SUPPLIERCOMPANYBYPLANT,
    _SUPPLIERTEXT,
    _SUPPLYAREA,
    _SUPPLYAREATEXT,
    _VARIABLESIZECOMPUNIT,
    _VARIABLESIZEDIMENSIONUNIT,
    _VARIABLESIZEITEMUNIT,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTTEXT,
    ACCOUNTASSIGNMENTCATEGORY,
    ALTERNATIVEITEMGROUP,
    ALTERNATIVEITEMPRIORITY,
    ALTERNATIVEITEMSTRATEGY,
    ALTERNATIVEMSTRRESERVATIONITEM,
    ASSEMBLY,
    ASSEMBLYMRPCONTROLLER,
    ASSEMBLYORDERLEVELVALUE,
    ASSEMBLYORDERPATHVALUE,
    BASEUNIT,
    BATCHCLASSIFICATION,
    BATCHMASTERRESERVATIONITEM,
    BATCHSPLITTYPE,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BOMEXPLOSIONDATEID,
    BOMITEMINTERNALCHANGECOUNT,
    BUSINESSAREA,
    CHANGENUMBER,
    COMPONENTSCRAPINPERCENT,
    CONFIRMEDAVAILABLEQUANTITY,
    CONSUMPTIONPOSTING,
    CRITICALCOMPONENTLEVEL,
    CRITICALCOMPONENTTYPE,
    CURRENCY,
    DEBITCREDITCODE,
    DELIVERYDURATIONINDAYS,
    DISCONTINUATIONGROUP,
    DISCONTINUATIONMASTERRESVNITEM,
    EARMARKEDFUNDSDOCUMENT,
    EFFECTIVITYPARAMETERVARIANT,
    ENTRYUNIT,
    FOLLOWUPGROUP,
    FOLLOWUPMATERIAL,
    FOLLOWUPMATERIALISACTIVE,
    FUNCTIONALAREA,
    GLACCOUNT,
    GOODSMOVEMENTENTRYQTY,
    GOODSMOVEMENTISALLOWED,
    GOODSMOVEMENTTYPE,
    GOODSRECIPIENTNAME,
    INHERITEDBOMITEMNODE,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    ISBULKMATERIALCOMPONENT,
    ISNETSCRAP,
    LATESTREQUIREMENTDATE,
    LEADTIMEOFFSET,
    LONGTEXTLANGUAGE,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERSEQUENCE,
    MATERIALCOMPCOSTINGRELEVANCY,
    MATERIALCOMPISALTERNATIVEITEM,
    MATERIALCOMPISINTRAMATERIAL,
    MATERIALCOMPISVARIABLESIZED,
    MATERIALCOMPONENTHASLONGTEXT,
    MATERIALCOMPONENTISCLASSIFIED,
    MATERIALCOMPONENTISMISSING,
    MATERIALCOMPONENTISPHANTOMITEM,
    MATERIALCOMPONENTSECONDTEXT,
    MATERIALCOMPONENTSORTTEXT,
    MATERIALCOMPONENTTEXT,
    MATERIALCOMPORIGINALQUANTITY,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALISDIRECTLYPROCURED,
    MATERIALISDIRECTLYPRODUCED,
    MATERIALPLANNINGRELEVANCE,
    MATERIALPROVISIONTYPE,
    MATERIALQTYTOBASEQTYDNMNTR,
    MATERIALQTYTOBASEQTYNMRTR,
    MATERIALREVISIONLEVEL,
    MATLCOMPDISCONTINUATIONTYPE,
    MATLCOMPFREEDEFINEDATTRIBUTE,
    MATLCOMPISCONFIGURABLE,
    MATLCOMPISFOLLOWUPMATERIAL,
    MATLCOMPISMARKEDFORBACKFLUSH,
    MATLCOMPISMARKEDFORDELETION,
    MATLCOMPISTEXTITEM,
    MATLCOMPONENTSPAREPARTTYPE,
    MATLCOMPREQUIREMENTDATE,
    MATLCOMPREQUIREMENTTIME,
    MFGORDERSEQUENCECATEGORY,
    NUMBEROFOPERATIONPRICEUNITS,
    OBJECTINTERNALID,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONLEADTIMEOFFSETUNIT,
    OPERATIONSCRAPINPERCENT,
    ORDERINTERNALID,
    ORDERLEVELVALUE,
    ORDEROPERATIONINTERNALID,
    ORDERPATHVALUE,
    PRODUCTCONFIGURATION,
    PRODUCTIONSUPERVISOR,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERSCHEDULELINE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    QUANTITYISFIXED,
    REQUIREDQUANTITY,
    REQUIREMENTSEGMENT,
    REQUIREMENTTYPE,
    RESERVATIONISFINALLYISSUED,
    RESERVATIONITEMCREATIONCODE,
    SALESORDER,
    SALESORDERITEM,
    STOCKSEGMENT,
    STORAGELOCATION,
    SUPPLIER,
    SUPPLYAREA,
    UNLOADINGPOINTNAME,
    USAGEPROBABILITYPERCENT,
    VARIABLESIZECOMPFORMULAKEY,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    VARIABLESIZEITEMQUANTITY,
    VARIABLESIZEITEMUNIT,
    WBSELEMENTINTERNALID,
    WITHDRAWNQUANTITY,
    WITHDRAWNQUANTITYAMOUNT,
    PRIMARY KEY (RESERVATION, RESERVATIONITEM, RESERVATIONRECORDTYPE)
);