DPIDOCITEMDRAFT

Transparent Table Application Table
56 Fields 2 CDS Views

Draft table for entity R_PHYSINVTRYDOCUMENTITEMTP

DPIDOCITEMDRAFT is an SAP database table in S/4HANA. Draft table for entity R_PHYSINVTRYDOCUMENTITEMTP. It contains 56 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_PhysInvtryDocumentItemDraft view from EXTENSION Physical Inventory Doc Item - Extension
R_PhysInvtryDocumentItemDraft view_entity from BASIC View for PI Item table-draft

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fiscalyear gjahr Fiscal Year
KEY physicalinventorydocument pi_item_document Physical Inventory Document
KEY physicalinventorydocumentitem pi_item_number Physical Inventory Document Item
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
material matnr Material
plant werks_d Plant
storagelocation lgort_d Location
batch charg_d Batch
valuationtype bwtar_d Valuation Type
inventoryspecialstocktype nsdm_spcl_stock_type Special Stock Type
physicalinventorystocktype i_bstar Stock Type
salesorder kdauf Sales Order
salesorderitem pi_sales_order_item Sales Order Item
scheduleline pi_sales_order_sched_line Sales Order Schedule
supplier elifn Supplier
customer ekunn Customer
stockowner owner_d Owner of stock
lastchangedbyuser usnaa Changed By
lastchangedate aedat Changed On
countedbyuser usnaz Counted By
physicalinventorylastcountdate dzldat Count Date
adjustmentpostingmadebyuser pi_item_adjustment_posting_usr Adjustment Posting Made By
postingdate budat Posting Date
physicalinventoryitemiscounted pi_is_item_counted Is Counted
physinvtrydifferenceisposted pi_is_item_difference_posted Is Difference Posted
physinvtryitemisrecounted pi_is_item_recounted Is Recounted
physinvtryitemisdeleted pi_is_item_deleted Is Deleted
ishandledinaltvunitofmsr pi_item_is_handled_in_altv_uom Without Unit of Measure Proposal
bookqtybfrcountinmatlbaseunit buchm Book Quantity
physicalinventoryitemiszero pi_item_is_zero_count Zero Counted
quantity pi_item_cntd_qty Counted Qty
materialbaseunit meins Base Unit
quantityinunitofentry pi_item_qty_in_entry_uom Counted Quantity in Entry Unit
unitofentry pi_item_entry_uom Entry Unit
materialdocumentyear nsdm_mjahr Material Document Year
materialdocument mblnr Material Doc.
materialdocumentitem nsdm_mblpo Material Document Item
physinvtryrecountdocument nblnr Recount Doc.
differenceamountincocodecrcy pi_item_diff_value Difference Val.
currency nsdm_comp_code_currency Company Code Currency
cyclecounttype pi_item_cycle_count_type Cycle Count Type
wbselementinternalid ps_s4_pspnr WBS Internal ID
slsprcamtinclvatincocodecrcy vkwrt SalVal inc. VAT
slsprcamtexclvatincocodecrcy vkwra SalVal w/o VAT
diffamountoncountentryincccrcy diwzl Diff. Value
enteredslsamtincocodecrcy pi_item_ext_value_sp Sales Price Counted Value
slspriceamountincocodecrcy pi_item_sp_of_book_qty Sales Price Book Value
isvalueonlymaterial pi_item_is_value_only_mat Is Value-Only Material
physinvtryctamtincocodecrcy pi_item_counted_qty_value Counted Quantity Value
bookqtyamountincocodecrcy pi_item_book_value Book Value
productcategory attyp Matl Category
reasonforphysinvtrydifference pi_item_difference_reason Difference Reason
crossplantconfigurablematerial pi_item_cross_plant_cnf_mat Cross-Plant Configurable Material
physinvtrydiffisdistributed pi_item_is_diff_distributed Difference Distributed

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_PHYSINVTRYDOCUMENTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DPIDOCITEMDRAFT (
    MANDT,                           -- Client [mandt]
    FISCALYEAR,                      -- Fiscal Year [gjahr]
    PHYSICALINVENTORYDOCUMENT,       -- Physical Inventory Document [pi_item_document]
    PHYSICALINVENTORYDOCUMENTITEM,   -- Physical Inventory Document Item [pi_item_number]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    MATERIAL,                        -- Material [matnr]
    PLANT,                           -- Plant [werks_d]
    STORAGELOCATION,                 -- Location [lgort_d]
    BATCH,                           -- Batch [charg_d]
    VALUATIONTYPE,                   -- Valuation Type [bwtar_d]
    INVENTORYSPECIALSTOCKTYPE,       -- Special Stock Type [nsdm_spcl_stock_type]
    PHYSICALINVENTORYSTOCKTYPE,      -- Stock Type [i_bstar]
    SALESORDER,                      -- Sales Order [kdauf]
    SALESORDERITEM,                  -- Sales Order Item [pi_sales_order_item]
    SCHEDULELINE,                    -- Sales Order Schedule [pi_sales_order_sched_line]
    SUPPLIER,                        -- Supplier [elifn]
    CUSTOMER,                        -- Customer [ekunn]
    STOCKOWNER,                      -- Owner of stock [owner_d]
    LASTCHANGEDBYUSER,               -- Changed By [usnaa]
    LASTCHANGEDATE,                  -- Changed On [aedat]
    COUNTEDBYUSER,                   -- Counted By [usnaz]
    PHYSICALINVENTORYLASTCOUNTDATE,  -- Count Date [dzldat]
    ADJUSTMENTPOSTINGMADEBYUSER,     -- Adjustment Posting Made By [pi_item_adjustment_posting_usr]
    POSTINGDATE,                     -- Posting Date [budat]
    PHYSICALINVENTORYITEMISCOUNTED,  -- Is Counted [pi_is_item_counted]
    PHYSINVTRYDIFFERENCEISPOSTED,    -- Is Difference Posted [pi_is_item_difference_posted]
    PHYSINVTRYITEMISRECOUNTED,       -- Is Recounted [pi_is_item_recounted]
    PHYSINVTRYITEMISDELETED,         -- Is Deleted [pi_is_item_deleted]
    ISHANDLEDINALTVUNITOFMSR,        -- Without Unit of Measure Proposal [pi_item_is_handled_in_altv_uom]
    BOOKQTYBFRCOUNTINMATLBASEUNIT,   -- Book Quantity [buchm]
    PHYSICALINVENTORYITEMISZERO,     -- Zero Counted [pi_item_is_zero_count]
    QUANTITY,                        -- Counted Qty [pi_item_cntd_qty]
    MATERIALBASEUNIT,                -- Base Unit [meins]
    QUANTITYINUNITOFENTRY,           -- Counted Quantity in Entry Unit [pi_item_qty_in_entry_uom]
    UNITOFENTRY,                     -- Entry Unit [pi_item_entry_uom]
    MATERIALDOCUMENTYEAR,            -- Material Document Year [nsdm_mjahr]
    MATERIALDOCUMENT,                -- Material Doc. [mblnr]
    MATERIALDOCUMENTITEM,            -- Material Document Item [nsdm_mblpo]
    PHYSINVTRYRECOUNTDOCUMENT,       -- Recount Doc. [nblnr]
    DIFFERENCEAMOUNTINCOCODECRCY,    -- Difference Val. [pi_item_diff_value]
    CURRENCY,                        -- Company Code Currency [nsdm_comp_code_currency]
    CYCLECOUNTTYPE,                  -- Cycle Count Type [pi_item_cycle_count_type]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [ps_s4_pspnr]
    SLSPRCAMTINCLVATINCOCODECRCY,    -- SalVal inc. VAT [vkwrt]
    SLSPRCAMTEXCLVATINCOCODECRCY,    -- SalVal w/o VAT [vkwra]
    DIFFAMOUNTONCOUNTENTRYINCCCRCY,  -- Diff. Value [diwzl]
    ENTEREDSLSAMTINCOCODECRCY,       -- Sales Price Counted Value [pi_item_ext_value_sp]
    SLSPRICEAMOUNTINCOCODECRCY,      -- Sales Price Book Value [pi_item_sp_of_book_qty]
    ISVALUEONLYMATERIAL,             -- Is Value-Only Material [pi_item_is_value_only_mat]
    PHYSINVTRYCTAMTINCOCODECRCY,     -- Counted Quantity Value [pi_item_counted_qty_value]
    BOOKQTYAMOUNTINCOCODECRCY,       -- Book Value [pi_item_book_value]
    PRODUCTCATEGORY,                 -- Matl Category [attyp]
    REASONFORPHYSINVTRYDIFFERENCE,   -- Difference Reason [pi_item_difference_reason]
    CROSSPLANTCONFIGURABLEMATERIAL,  -- Cross-Plant Configurable Material [pi_item_cross_plant_cnf_mat]
    PHYSINVTRYDIFFISDISTRIBUTED,     -- Difference Distributed [pi_item_is_diff_distributed]
    PRIMARY KEY (MANDT, FISCALYEAR, PHYSICALINVENTORYDOCUMENT, PHYSICALINVENTORYDOCUMENTITEM, DRAFTUUID)
);

Learn More