I_ORDERCOMPONENT

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.

-- Order Component
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDERCOMPONENT (
    MATERIAL,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    _ACCOUNTASSIGNMENTCATEGORY,
    _BASEUNIT,
    _BATCH,
    _BATCHSPLITTYPE,
    _BILLOFMATERIALITEM,
    _BOMEXPLOSION,
    _BOMITEMCATEGORY,
    _BUSINESSAREA,
    _CHANGENUMBER,
    _COMMITMENTITEM,
    _COMMITMENTITEMSHORTID,
    _COMPANYCODE,
    _CONSUMPTIONPOSTING,
    _CONTROLLINGAREA,
    _CURRENCY,
    _DEBITCREDITCODE,
    _DISCONTINUATIONTYPE,
    _EARMARKEDFUNDS,
    _EARMARKEDFUNDSITEM,
    _ENTRYUNIT,
    _FOLLOWUPMATERIAL,
    _FUNCTIONALAREA,
    _FUND,
    _FUNDSCENTER,
    _GLACCOUNT,
    _GOODSMOVEMENTTYPE,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYSPECIALSTOCKVALNTYPE,
    _LONGTEXT,
    _LONGTEXTLANGUAGE,
    _MATERIAL,
    _MATERIALGROUP,
    _MATERIALREVISIONLEVEL,
    _OPLEADTIMEOFFSETUNIT,
    _ORDER,
    _ORDERINTERNALID,
    _PHANTOMASSEMBLY,
    _PLANT,
    _PRODUCT,
    _PRODUCTIONPLANT,
    _PRODUCTPLANT,
    _PRODUCTSTORAGELOCATION,
    _PROVISIONTYPE,
    _PURCHASEORDER,
    _PURCHASEORDERITEM,
    _PURCHASEREQUISITION,
    _PURCHASEREQUISITIONITEM,
    _PURCHASINGGROUP,
    _PURCHASINGINFORECORD,
    _REQUIREMENTTYPE,
    _RESERVATION,
    _RESERVATIONDOCRECORDTYPE,
    _RESERVATIONITEM,
    _SALESORDER,
    _SALESORDERITEM,
    _SEQUENCECATEGORY,
    _SPAREPARTTYPE,
    _STATUSOBJECT,
    _STORAGELOCATION,
    _SUPPLIER,
    _SUPPLYAREA,
    _VARIABLESIZECOMPONENTUNIT,
    _VARIABLESIZEITEMUNIT,
    _WAREHOUSE,
    _WBSELEMENTBASICDATA,
    ACCOUNTASSIGNMENTCATEGORY,
    ALTERNATIVEITEMGROUP,
    ALTERNATIVEITEMPRIORITY,
    ALTERNATIVEITEMSTRATEGY,
    ALTERNATIVEMSTRRESERVATIONITEM,
    ASSEMBLY,
    ASSEMBLYORDERLEVELVALUE,
    ASSEMBLYORDERPATHVALUE,
    BASEUNIT,
    BATCH,
    BATCHCLASSIFICATION,
    BATCHMASTERRESERVATIONITEM,
    BATCHSPLITTYPE,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BOMEXPLOSIONDATEID,
    BOMITEM,
    BOMITEMCATEGORY,
    BOMITEMDESCRIPTION,
    BOMITEMINTERNALCHANGECOUNT,
    BOMITEMTEXT2,
    BUSINESSAREA,
    CHANGENUMBER,
    COMMITMENTITEMSHORTID,
    COMPANYCODE,
    COMPONENTSCRAPINPERCENT,
    CONFIRMEDAVAILABLEQUANTITY,
    CONSUMPTIONPOSTING,
    CONTROLLINGAREA,
    CRITICALCOMPONENTLEVEL,
    CRITICALCOMPONENTTYPE,
    CURRENCY,
    DEBITCREDITCODE,
    DELIVERYDURATIONINDAYS,
    DISCONTINUATIONGROUP,
    DISCONTINUATIONMASTERRESVNITEM,
    EARMARKEDFUNDSDOCUMENT,
    EFFECTIVITYPARAMETERVARIANT,
    FOLLOWUPGROUP,
    FOLLOWUPMATERIAL,
    FOLLOWUPMATERIALISACTIVE,
    FOLLOWUPMATERIALISNOTACTIVE,
    FORMULAKEY,
    FUNCTIONALAREA,
    GLACCOUNT,
    GOODSMOVEMENTENTRYQTY,
    GOODSMOVEMENTISALLOWED,
    GOODSMOVEMENTTYPE,
    GOODSRECIPIENTNAME,
    INHERITEDBOMITEMNODE,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    ISBULKMATERIALCOMPONENT,
    ISNETSCRAP,
    LATESTREQUIREMENTDATE,
    LEADTIMEOFFSET,
    LONGTEXTLANGUAGE,
    MATERIALCOMPCOSTINGRELEVANCY,
    MATERIALCOMPISALTERNATIVEITEM,
    MATERIALCOMPISINTRAMATERIAL,
    MATERIALCOMPISVARIABLESIZED,
    MATERIALCOMPONENTHASLONGTEXT,
    MATERIALCOMPONENTISCLASSIFIED,
    MATERIALCOMPONENTISMISSING,
    MATERIALCOMPONENTISPHANTOMITEM,
    MATERIALCOMPONENTSECONDTEXT,
    MATERIALCOMPONENTSORTTEXT,
    MATERIALCOMPONENTTEXT,
    MATERIALCOMPORIGINALQUANTITY,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALISDIRECTLYPROCURED,
    MATERIALISDIRECTLYPRODUCED,
    MATERIALPLANNINGRELEVANCE,
    MATERIALPROVISIONTYPE,
    MATERIALQTYTOBASEQTYDNMNTR,
    MATERIALQTYTOBASEQTYNMRTR,
    MATERIALREVISIONLEVEL,
    MATERIALSTAGING,
    MATLCOMPDISCONTINUATIONTYPE,
    MATLCOMPFREEDEFINEDATTRIBUTE,
    MATLCOMPISCONFIGURABLE,
    MATLCOMPISFOLLOWUPMATERIAL,
    MATLCOMPISMARKEDFORBACKFLUSH,
    MATLCOMPISMARKEDFORDELETION,
    MATLCOMPISTEXTITEM,
    MATLCOMPONENTSPAREPARTTYPE,
    MATLCOMPREQUIREMENTDATE,
    MATLCOMPREQUIREMENTTIME,
    NUMBEROFPRICEUNITS,
    OBJECTINTERNALID,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONLEADTIMEOFFSETUNIT,
    OPERATIONSCRAPINPERCENT,
    ORDERCATEGORY,
    ORDERID,
    ORDERINTERNALID,
    ORDERLEVELVALUE,
    ORDEROPERATION,
    ORDEROPERATIONINTERNALID,
    ORDERPATHVALUE,
    ORDERTYPE,
    PRODUCTCONFIGURATION,
    PRODUCTIONPLANT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERSCHEDULELINE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    QUANTITYISFIXED,
    REQUIREDQUANTITY,
    REQUIREMENTSEGMENT,
    REQUIREMENTTYPE,
    RESERVATIONISFINALLYISSUED,
    RESERVATIONITEMCREATIONCODE,
    SALESORDER,
    SALESORDERITEM,
    SEQUENCE,
    SEQUENCECATEGORY,
    STOCKSEGMENT,
    STORAGEBIN,
    STORAGELOCATION,
    STORAGETYPE,
    SUPPLIER,
    SUPPLYAREA,
    UNLOADINGPOINTNAME,
    USAGEPROBABILITYPERCENT,
    VARIABLESIZECOMPFORMULAKEY,
    VARIABLESIZECOMPONENTQUANTITY,
    VARIABLESIZECOMPONENTUNIT,
    VARIABLESIZEDIMENSION1,
    VARIABLESIZEDIMENSION2,
    VARIABLESIZEDIMENSION3,
    VARIABLESIZEDIMENSIONUNIT,
    VARIABLESIZEITEMQUANTITY,
    WAREHOUSE,
    WBSELEMENTINTERNALID,
    WITHDRAWNQUANTITY,
    WITHDRAWNQUANTITYAMOUNT,
    PRIMARY KEY (MATERIAL, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM)
);