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]
    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]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, MATERIALDOCUMENTYEAR, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, DRAFTUUID)
);