IMRS_D_DOC_ITEM

Transparent Table Application Table
55 Fields 2 CDS Views

Draft table for entity R_RESERVATIONDOCUMENTITEMTP

IMRS_D_DOC_ITEM is an SAP database table in S/4HANA. Draft table for entity R_RESERVATIONDOCUMENTITEMTP. It contains 55 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ReservationDocumentItemDraft view_entity from EXTENSION Reservation Dft Item Table - Extension
R_ReservationDocumentItemDraft view_entity from BASIC Reservation Item - Draft

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY reservation RSNUM Reservation
KEY reservationitem RSPOS Item no.
KEY recordtype RSART Record type
plant WERKS_D Plant
storagelocation LGORT_D Location
product MATNR Material
batch CHARG_D Batch
valuationtype BWTAR_D Valuation Type
inventoryspecialstocktype SOBKZ Special Stock
specialstockidfgwbselement PS_S4_PSPNR WBS Internal ID
goodsmovementtype BWART Movement Type
requirementtype BDART RequirementType
reservationitemcreationcode RSSTA Reserv. status
matlcomprequirementdate BDTER Reqmts date
manufacturingorderoperation VORNR Activity
goodsmovementisallowed XWAOK Mvt Allowed
debitcreditcode SHKZG Debit/Credit
baseunit MEINS Base Unit
glaccount SAKNR G/L Account
entryunit ERFME Unit of Entry
quantityisfixed FMENG Qty. is fixed
companycodecurrency WAERS Currency
issuingorreceivingplant UMWRK Receiving plant
issuingorreceivingstorageloc UMLGO Receiving SLoc.
purchasingdocument EBELN Purchasing Doc.
purchasingdocumentitem EBELP Item
resvnitmrequiredqtyinbaseunit BDMNG Requirement qty
confdqtyforatpinbaseuom VMENG Qty.f.avail.chk
reservationitemisfinallyissued KZEAR Final Issue
reservationitmismarkedfordeltn XLOEK Deleted
resvnitmrequiredqtyinentryunit ERFMG Quantity in UnE
resvnitmwithdrawnqtyinbaseunit ENMNG Withdrawal Qty
resvnitmwithdrawnamtincccrcy ENWRT Withdr. Value
supplier LIFNR Supplier
materialgroup MATKL Material Group
goodsrecipientname WEMPF Recipient
unloadingpointname ABLAD Unloading Point
reservationitemtext SGTXT Text
resvnaccountisenteredmanually KTOMA Acct manually
serviceobjecttype SWO_OBJTYP Object Type
servicedocument CRMT_OBJECT_ID_CO Bus.Trans.
servicedocumentitem CRMS4_NUMBER_INT Item Number in Doc.
resvnitmsrvcdoctypeasacctasgt FCO_SRVDOC_TYPE Service Doc. Type
resvnitmsrvcdocasacctasgt FCO_SRVDOC_ID Service Document
resvnitmsrvcdocitmasacctasgt FCO_SRVDOC_ITEM_ID Service Doc. Item
recipientlocationcode RECIPIENT_LOCATION_CODE Recipient Loc.
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_rdi_ps CFD_DUMMY Dummy
zz1_goodsprovided_res ZZ1_GOODSPROVIDED

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]
    PLANT,                           -- Plant [WERKS_D]
    STORAGELOCATION,                 -- Location [LGORT_D]
    PRODUCT,                         -- Material [MATNR]
    BATCH,                           -- Batch [CHARG_D]
    VALUATIONTYPE,                   -- Valuation Type [BWTAR_D]
    INVENTORYSPECIALSTOCKTYPE,       -- Special Stock [SOBKZ]
    SPECIALSTOCKIDFGWBSELEMENT,      -- WBS Internal ID [PS_S4_PSPNR]
    GOODSMOVEMENTTYPE,               -- Movement Type [BWART]
    REQUIREMENTTYPE,                 -- RequirementType [BDART]
    RESERVATIONITEMCREATIONCODE,     -- Reserv. status [RSSTA]
    MATLCOMPREQUIREMENTDATE,         -- Reqmts date [BDTER]
    MANUFACTURINGORDEROPERATION,     -- Activity [VORNR]
    GOODSMOVEMENTISALLOWED,          -- Mvt Allowed [XWAOK]
    DEBITCREDITCODE,                 -- Debit/Credit [SHKZG]
    BASEUNIT,                        -- Base Unit [MEINS]
    GLACCOUNT,                       -- G/L Account [SAKNR]
    ENTRYUNIT,                       -- Unit of Entry [ERFME]
    QUANTITYISFIXED,                 -- Qty. is fixed [FMENG]
    COMPANYCODECURRENCY,             -- Currency [WAERS]
    ISSUINGORRECEIVINGPLANT,         -- Receiving plant [UMWRK]
    ISSUINGORRECEIVINGSTORAGELOC,    -- Receiving SLoc. [UMLGO]
    PURCHASINGDOCUMENT,              -- Purchasing Doc. [EBELN]
    PURCHASINGDOCUMENTITEM,          -- Item [EBELP]
    RESVNITMREQUIREDQTYINBASEUNIT,   -- Requirement qty [BDMNG]
    CONFDQTYFORATPINBASEUOM,         -- Qty.f.avail.chk [VMENG]
    RESERVATIONITEMISFINALLYISSUED,  -- Final Issue [KZEAR]
    RESERVATIONITMISMARKEDFORDELTN,  -- Deleted [XLOEK]
    RESVNITMREQUIREDQTYINENTRYUNIT,  -- Quantity in UnE [ERFMG]
    RESVNITMWITHDRAWNQTYINBASEUNIT,  -- Withdrawal Qty [ENMNG]
    RESVNITMWITHDRAWNAMTINCCCRCY,    -- Withdr. Value [ENWRT]
    SUPPLIER,                        -- Supplier [LIFNR]
    MATERIALGROUP,                   -- Material Group [MATKL]
    GOODSRECIPIENTNAME,              -- Recipient [WEMPF]
    UNLOADINGPOINTNAME,              -- Unloading Point [ABLAD]
    RESERVATIONITEMTEXT,             -- Text [SGTXT]
    RESVNACCOUNTISENTEREDMANUALLY,   -- Acct manually [KTOMA]
    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]
    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]
    DUMMY_RDI_PS,                    -- Dummy [CFD_DUMMY]
    ZZ1_GOODSPROVIDED_RES,           -- ZZ1_GOODSPROVIDED
    PRIMARY KEY (MANDT, RESERVATION, RESERVATIONITEM, RECORDTYPE)
);

Learn More