I_MATERIALDOCUMENTRECORD

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.

-- Basis view for MATDOC table
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALDOCUMENTRECORD (
    COMPANYCODE,
    GLACCOUNT,
    GOODSMOVEMENTTYPE,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSTOCKTYPE,
    ISSUINGORRECEIVINGPLANT,
    MANDT,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTKEY1,
    MATERIALDOCUMENTKEY2,
    MATERIALDOCUMENTKEY3,
    MATERIALDOCUMENTKEY4,
    MATERIALDOCUMENTKEY5,
    MATERIALDOCUMENTKEY6,
    MATERIALDOCUMENTYEAR,
    PL_GOODSMOVEMENTTYPECATEGORY,
    PLANT,
    POSTINGDATE,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    SPECIALSTOCKIDFGCUSTOMER,
    SPECIALSTOCKIDFGSALESORDER,
    SPECIALSTOCKIDFGSALESORDERITEM,
    SPECIALSTOCKIDFGSTOCKOWNER,
    SPECIALSTOCKIDFGSUPPLIER,
    SPECIALSTOCKIDFGWBSELEMENT,
    STOCKIDENTIFYINGBATCH,
    STOCKIDENTIFYINGMATERIAL,
    STOCKIDFGSTORAGELOCATION,
    STORAGELOCATION,
    _BPSTOCKOWNER,
    _CUSTOMER,
    _CUSTOMERCOMPANYBYPLANT,
    _GOODSMVTTYPEBYSPCLSTKINDT,
    _ISSUINGORRECEIVINGSTORAGELOC,
    _MATERIAL,
    _MATERIALBASEUNIT,
    _PLANT,
    _STORAGELOCATION,
    _SUPPLIER,
    _SUPPLIERCOMPANYBYPLANT,
    ACCOUNTASSIGNMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    ACTIVITYINWAREHOUSEISPENDING,
    BATCH,
    BILLOFLADING,
    BUSINESSAREA,
    CALENDARDAY,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    COMMITMENTITEM,
    COMMITMENTITEMSHORTID,
    COMPANYCODECURRENCY,
    CONSUMPTIONPOSTING,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTESTIMATE,
    COSTOBJECT,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CUSTOMER,
    DEBITCREDITCODE,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    DELIVERYINMATLDOCUMENTHEADER,
    DELIVERYQUANTITYUNIT,
    DOCUMENTDATE,
    DOCUMENTYEAR,
    EMPLOYMENTINTERNALID,
    ENTEREDSLSAMTINCOCODECRCY,
    ENTRYUNIT,
    EWMSTORAGEBIN,
    EWMWAREHOUSE,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GDSMVTEXTAMTINCOCODECRCY,
    GOODSMOVEMENTCANCELLATIONTYPE,
    GOODSMOVEMENTISCANCELLED,
    GOODSMOVEMENTREASONCODE,
    GOODSMOVEMENTREFDOCTYPE,
    GOODSMOVEMENTSTKAMTINCCCRCY,
    GOODSMVTCNSMPNAMTINCCCRCY,
    GOODSRECEIPTISNONVALUATED,
    GOODSRECEIPTQTYINORDERUNIT,
    GOODSRECEIPTTYPE,
    GOODSRECIPIENTNAME,
    GRANTID,
    HANDLINGUNITEXTERNALID,
    HASMULTIPLEACCOUNTASSIGNMENT,
    HIERARCHYNODELEVEL,
    INVENTORYSPECIALSTOCKVALNTYPE,
    INVENTORYTRANSACTIONTYPE,
    INVENTORYUSABILITYCODE,
    INVENTORYVALUATIONTYPE,
    INVTRYMGMTREFDOCUMENTITEM,
    INVTRYMGMTREFERENCEDOCUMENT,
    ISAUTOMATICALLYCREATED,
    ISCOMPLETELYDELIVERED,
    ISMATERIALDOCUMENTHEADER,
    ISREVERSALMOVEMENTTYPE,
    ISSGORRCVGBATCH,
    ISSGORRCVGMATERIAL,
    ISSGORRCVGRESOURCEID,
    ISSGORRCVGSALESORDER,
    ISSGORRCVGSALESORDERITEM,
    ISSGORRCVGSPCLSTOCKIND,
    ISSGORRCVGSTOCKSEGMENT,
    ISSGORRCVGWBSELEMENT,
    ISSUINGORRECEIVINGSTOCKTYPE,
    ISSUINGORRECEIVINGSTORAGELOC,
    ISSUINGORRECEIVINGVALTYPE,
    MAINTORDEROPERATIONCOUNTER,
    MAINTORDERROUTINGNUMBER,
    MANUFACTUREDATE,
    MANUFACTURERMATERIAL,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERITEM,
    MASTERFIXEDASSET,
    MATERIALDOCUMENTHEADERTEXT,
    MATERIALDOCUMENTITEMTEXT,
    MATERIALDOCUMENTLINE,
    MATERIALDOCUMENTPARENTLINE,
    MATERIALDOCUMENTRECORDTYPE,
    MATLCNSMPNQTYINMATLBASEUNIT,
    MATLSTKCHANGEQTYINBASEUNIT,
    MULTIACCTASSGMTORIGLMATLDOCITM,
    MULTIPLEACCOUNTASSIGNMENTCODE,
    NUMBEROFLABELSTOBEPRINTED,
    NUMBEROFSLIPSTOBEPRINTED,
    ORDERID,
    ORDERITEM,
    ORDERPRICEUNIT,
    ORDERQUANTITYUNIT,
    ORIGINALMATERIALDOCUMENTITEM,
    PL_MMDOCUMENTHASALWAYSPRICEAMT,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTCOLLECTION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PROFITABILITYSEGMENT,
    PROFITABILITYSEGMENT_2,
    PROFITCENTER,
    PROJECTNETWORK,
    QTYINPURCHASEORDERPRICEUNIT,
    QUANTITYINBASEUNIT,
    QUANTITYINDELIVERYQTYUNIT,
    QUANTITYINENTRYUNIT,
    REFERENCEDOCUMENT,
    RESERVATION,
    RESERVATIONISFINALLYISSUED,
    RESERVATIONITEM,
    RESERVATIONRECORDTYPE,
    RESOURCEID,
    REVERSEDMATERIALDOCUMENT,
    REVERSEDMATERIALDOCUMENTITEM,
    REVERSEDMATERIALDOCUMENTYEAR,
    RVSLOFGOODSRECEIPTISALLOWED,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERSCHEDULELINE,
    SERVICEPERFORMER,
    SERVICESRENDEREDDATE,
    SHELFLIFEEXPIRATIONDATE,
    SHIPGINSTRNSUPPLIERCOMPLIANCE,
    SHIPPINGINSTRUCTION,
    SLSPRCAMTINCLVATINCOCODECRCY,
    STOCKOWNER,
    STOCKSEGMENT,
    STORAGEBIN,
    STORAGETYPE,
    SUPPLIER,
    TOTALGOODSMVTAMTINCCCRCY,
    TRANSACTIONCODE,
    TRANSFERPRIORITY,
    TRANSFERREQUIREMENTNUMBER,
    UNLOADINGPOINTNAME,
    VERSIONFORPRINTINGSLIP,
    WAREHOUSENUMBER,
    WBSELEMENTINTERNALID,
    WEEKDAY,
    WORKITEM,
    YEARDAY,
    YEARMONTH,
    YEARPERIOD,
    YEARQUARTER,
    YEARWEEK,
    PRIMARY KEY (COMPANYCODE, GLACCOUNT, GOODSMOVEMENTTYPE, INVENTORYSPECIALSTOCKTYPE, INVENTORYSTOCKTYPE, ISSUINGORRECEIVINGPLANT, MANDT, MATERIAL, MATERIALBASEUNIT, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTKEY1, MATERIALDOCUMENTKEY2, MATERIALDOCUMENTKEY3, MATERIALDOCUMENTKEY4, MATERIALDOCUMENTKEY5, MATERIALDOCUMENTKEY6, MATERIALDOCUMENTYEAR, PL_GOODSMOVEMENTTYPECATEGORY, PLANT, POSTINGDATE, PURCHASEORDER, PURCHASEORDERITEM, SPECIALSTOCKIDFGCUSTOMER, SPECIALSTOCKIDFGSALESORDER, SPECIALSTOCKIDFGSALESORDERITEM, SPECIALSTOCKIDFGSTOCKOWNER, SPECIALSTOCKIDFGSUPPLIER, SPECIALSTOCKIDFGWBSELEMENT, STOCKIDENTIFYINGBATCH, STOCKIDENTIFYINGMATERIAL, STOCKIDFGSTORAGELOCATION, STORAGELOCATION)
);