IMRS_D_DOC_ITEM

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_RESERVATIONDOCUMENTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IMRS_D_DOC_ITEM (
    MANDT,                           -- Client [mandt]
    RESERVATION,                     -- Reservation [rsnum]
    RESERVATIONITEM,                 -- Item no. [rspos]
    RECORDTYPE,                      -- Record type [rsart]
    REQUIREMENTTYPE,                 -- RequirementType [bdart]
    RESERVATIONITEMCREATIONCODE,     -- Reserv. status [rssta]
    GOODSMOVEMENTTYPE,               -- Movement Type [bwart]
    MATLCOMPREQUIREMENTDATE,         -- Reqmts date [bdter]
    PRODUCT,                         -- Material [matnr]
    PLANT,                           -- Plant [werks_d]
    STORAGELOCATION,                 -- Location [lgort_d]
    RESVNITMREQUIREDQTYINENTRYUNIT,  -- Quantity in UnE [erfmg]
    ENTRYUNIT,                       -- Unit of Entry [erfme]
    RESVNITMREQUIREDQTYINBASEUNIT,   -- Requirement qty [bdmng]
    BASEUNIT,                        -- Base Unit [meins]
    RESVNITMWITHDRAWNQTYINBASEUNIT,  -- Withdrawal Qty [enmng]
    GOODSMOVEMENTISALLOWED,          -- Mvt Allowed [xwaok]
    RESERVATIONITEMISFINALLYISSUED,  -- Final Issue [kzear]
    RESERVATIONITMISMARKEDFORDELTN,  -- Deleted [xloek]
    CONFDQTYFORATPINBASEUOM,         -- Qty.f.avail.chk [vmeng]
    BATCH,                           -- Batch [charg_d]
    VALUATIONTYPE,                   -- Valuation Type [bwtar_d]
    ISSUINGORRECEIVINGPLANT,         -- Receiving plant [umwrk]
    ISSUINGORRECEIVINGSTORAGELOC,    -- Receiving SLoc. [umlgo]
    GLACCOUNT,                       -- G/L Account [saknr]
    GOODSRECIPIENTNAME,              -- Recipient [wempf]
    UNLOADINGPOINTNAME,              -- Unloading Point [ablad]
    RESERVATIONITEMTEXT,             -- Text [sgtxt]
    RESVNACCOUNTISENTEREDMANUALLY,   -- Acct manually [ktoma]
    MATERIALGROUP,                   -- Material Group [matkl]
    DEBITCREDITCODE,                 -- Debit/Credit [shkzg]
    INVENTORYSPECIALSTOCKTYPE,       -- Special Stock [sobkz]
    SPECIALSTOCKIDFGWBSELEMENT,      -- WBS Internal ID [ps_s4_pspnr]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [knttp]
    CONSUMPTIONPOSTING,              -- Consumption [kzvbr]
    INVENTORYSPECIALSTOCKVALNTYPE,   -- Valuation [kzbws]
    SERVICEOBJECTTYPE,               -- Object Type [swo_objtyp]
    SERVICEDOCUMENT,                 -- Bus.Trans. [crmt_object_id_co]
    SERVICEDOCUMENTITEM,             -- Item Number in Doc. [crms4_number_int]
    RESVNITMSRVCDOCTYPEASACCTASGT,   -- Service Doc. Type [fco_srvdoc_type]
    RESVNITMSRVCDOCASACCTASGT,       -- Service Document [fco_srvdoc_id]
    RESVNITMSRVCDOCITMASACCTASGT,    -- Service Doc. Item [fco_srvdoc_item_id]
    RECIPIENTLOCATIONCODE,           -- Recipient Loc. [recipient_location_code]
    MANUFACTURINGORDEROPERATION,     -- Activity [vornr]
    QUANTITYISFIXED,                 -- Qty. is fixed [fmeng]
    COMPANYCODECURRENCY,             -- Currency [waers]
    PURCHASINGDOCUMENT,              -- Purchasing Doc. [ebeln]
    PURCHASINGDOCUMENTITEM,          -- Item [ebelp]
    RESVNITMWITHDRAWNAMTINCCCRCY,    -- Withdr. Value [enwrt]
    SUPPLIER,                        -- Supplier [lifnr]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    PRIMARY KEY (MANDT, RESERVATION, RESERVATIONITEM, RECORDTYPE)
);