DMATDOCITEMDRAFT

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.

-- Draft table for entity R_MATERIALDOCUMENTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMATDOCITEMDRAFT (
    MANDT,                           -- Client [mandt]
    MATERIALDOCUMENTYEAR,            -- Material Document Year [nsdm_mjahr]
    MATERIALDOCUMENT,                -- Material Doc. [mblnr]
    MATERIALDOCUMENTITEM,            -- Material Document Item [nsdm_mblpo]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    MATERIALDOCUMENTLINE,            -- Line ID [nsdm_mb_line_id]
    MATERIALDOCUMENTPARENTLINE,      -- Parent ID [mb_parent_id]
    GOODSMOVEMENTTYPE,               -- Movement Type [bwart]
    MATERIAL,                        -- Material [matnr]
    PLANT,                           -- Plant [werks_d]
    STORAGELOCATION,                 -- Location [lgort_d]
    STORAGETYPE,                     -- Storage Type [lgtyp]
    STORAGEBIN,                      -- Storage Bin [lgpla]
    INVENTORYUSABILITYCODE,          -- Posting Control Stock Type [nsdm_insmk]
    QUANTITYINENTRYUNIT,             -- Quantity in UnE [erfmg]
    ENTRYUNIT,                       -- Unit of Entry [erfme]
    QUANTITYINBASEUNIT,              -- Quantity [menge_d]
    MATERIALBASEUNIT,                -- Base Unit [meins]
    BATCH,                           -- Batch [charg_d]
    SHELFLIFEEXPIRATIONDATE,         -- SLED/BBD [vfdat]
    MANUFACTUREDATE,                 -- Date of Manuf. [hsdat]
    INVENTORYSPECIALSTOCKTYPE,       -- Special Stock Type [nsdm_spcl_stock_type]
    INVENTORYSTOCKTYPE,              -- Stock Type [nsdm_lbbsa]
    CUSTOMER,                        -- Customer [ekunn]
    SUPPLIER,                        -- Supplier [elifn]
    ISSGORRCVGMATERIAL,              -- Transfer Material [nsdm_umat]
    ISSUINGORRECEIVINGPLANT,         -- Transfer Plant [nsdm_plant]
    ISSUINGORRECEIVINGSTORAGELOC,    -- Receiving SLoc. [umlgo]
    ISSGORRCVGBATCH,                 -- Transfer Batch [nsdm_umcha]
    ISSGORRCVGSPCLSTOCKIND,          -- Special Stock [sobkz]
    ISSUINGORRECEIVINGVALTYPE,       -- Val. Type Tfr. [umbar]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [ps_s4_pspnr]
    RESERVATION,                     -- Reservation [rsnum]
    RESERVATIONITEM,                 -- Reservation Item [nsdm_rspos]
    ORIGINALMATERIALDOCUMENTITEM,    -- Orig. line itm [urzei]
    GOODSMOVEMENTREFDOCTYPE,         -- Reference Doc. Type [nsdm_kzbew]
    GOODSMOVEMENTREASONCODE,         -- Reason for Mvmt [mb_grbew]
    MATERIALDOCUMENTPOSTINGTYPE,     -- Type of posting [kzsto]
    PURCHASEORDER,                   -- Purchase order [bstnr]
    PURCHASEORDERITEM,               -- Item [ebelp]
    COSTCENTER,                      -- Cost Center [kostl]
    GLACCOUNT,                       -- G/L Account [saknr]
    COMPANYCODE,                     -- Company Code [bukrs]
    POSTINGDATE,                     -- Posting Date [budat]
    DOCUMENTDATE,                    -- Document Date [bldat]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    COSTOBJECT,                      -- Cost Object [kstrg]
    PROFITCENTER,                    -- Profit Center [prctr]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    ACCOUNTASSIGNMENTCATEGORY,       -- Account Assignment Category [nsdm_knttp]
    BUSINESSAREA,                    -- Business Area [gsber]
    SALESORDER,                      -- Sales Order [kdauf]
    SALESORDERITEM,                  -- Sales Order Item [nsdm_sales_order_item]
    SALESORDERSCHEDULELINE,          -- Sales Order Schedule [nsdm_kdein]
    REFERENCEDOCUMENTFISCALYEAR,     -- Fisc.yr.ref.doc [lfbja]
    INVTRYMGMTREFDOCUMENTITEM,       -- Ref. Doc. Item [lfpos]
    INVTRYMGMTREFERENCEDOCUMENT,     -- Reference Doc. [lfbnr]
    DELIVERYDOCUMENT,                -- Delivery [vbeln_vl]
    DELIVERYDOCUMENTITEM,            -- Delivery Item [nsdm_delivery_document_item]
    REVERSEDMATERIALDOCUMENTYEAR,    -- Reversed Doc Year [nsdm_sjahr]
    REVERSEDMATERIALDOCUMENT,        -- Reversed Mat Doc [nsdm_smbln]
    REVERSEDMATERIALDOCUMENTITEM,    -- Reversed Doc Item [nsdm_smblp]
    INVENTORYVALUATIONTYPE,          -- Valuation Type [bwtar_d]
    GOODSMOVEMENTISCANCELLED,        -- Is Item Cancelled [nsdm_cancelled_ind]
    GOODSRECIPIENTNAME,              -- Recipient [wempf]
    UNLOADINGPOINTNAME,              -- Unloading Point [ablad]
    RESERVATIONISFINALLYISSUED,      -- Res Final Issue [nsdm_kzear]
    PROJECTNETWORK,                  -- Network [nplnr]
    MANUFACTURINGORDER,              -- Manufacturing Order [nsdm_manufacturing_order]
    MANUFACTURINGORDERITEM,          -- Manufacturing Order Item [nsdm_manufacturing_order_item]
    SPECIALSTOCKIDFGSALESORDER,      -- Sales order [mat_kdauf]
    SPECIALSTOCKIDFGSALESORDERITEM,  -- Sales ord. item [mat_kdpos]
    SPECIALSTOCKIDFGWBSELEMENT,      -- WBS Element Special Stock [nsdm_wbselement_internal_id]
    FISCALYEAR,                      -- Fiscal Year [gjahr]
    FISCALYEARPERIOD,                -- Fiscal Year & Period from Posting date [nsdm_jahrper]
    FISCALYEARVARIANT,               -- FY Variant [periv]
    ISCOMPLETELYDELIVERED,           -- Deliv. Compl. [elikz]
    MATERIALDOCUMENTITEMTEXT,        -- Text [sgtxt]
    EWMWAREHOUSE,                    -- Warehouse No. [/scwm/lgnum]
    EWMSTORAGEBIN,                   -- Storage Bin [/scwm/lgpla]
    COMPANYCODECURRENCY,             -- Company Code Currency [nsdm_comp_code_currency]
    GDSMVTEXTAMTINCOCODECRCY,        -- Ext. Amount LC [exbwr]
    PRODUCTSTANDARDID,               -- GTIN [globaltradeitemnumber]
    ISAUTOMATICALLYCREATED,          -- Automat. Created [nsdm_xauto]
    SERIALNUMBERSARECREATEDAUTOMLY,  -- SerialNo. auto. [xsaut]
    DEBITCREDITCODE,                 -- Debit/Credit [shkzg]
    RESERVATIONITEMRECORDTYPE,       -- Reservation Record Type [nsdm_reservation_record_type]
    PRIMARY KEY (MANDT, MATERIALDOCUMENTYEAR, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, DRAFTUUID)
);