ISEG

Transparent Table Application Table
61 Fields 5 CDS Views

Physical Inventory Document Items

ISEG is an SAP database table in S/4HANA. Physical Inventory Document Items. It contains 61 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_PhysInvtryDocumentItem view from EXTENSION Physical Inventory Doc Item - Extension
I_PhysInvtryDocItem view from BASIC Physical Inventory Document Item
Mmim_MatDocDocFlow view inner Material Documents Document Flow
P_PhysInvtryConcatForReporting view_entity from BASIC Concat PI fields for Reporting
P_PhysInvtryDocItem2 view_entity from BASIC

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY iblnr iblnr Phys. Inv. Doc.
KEY gjahr gjahr Fiscal Year
KEY zeili dzeile Item
matnr matnr Material
werks werks_d Plant
lgort lgort_d Location
charg charg_d Batch
sobkz sobkz Special Stock
bstar i_bstar Stock Type
kdauf kdauf Sales Order
kdpos kdpos Sales Ord. Item
kdein kdein SOrder schedule
lifnr elifn Supplier
kunnr ekunn Customer
plpla plpla Distribution
usnam usnaa Changed By
aedat aedat Changed On
usnaz usnaz Counted By
zldat dzldat Count Date
usnad usnad Adj. Posting By
budat budat Posting Date
xblni xblni1 Phys.invent.ref
xzael xzael Item Counted
xdiff xdiff Diff. posted
xnzae xnzae Recount
xloek i_xloek Deleted
xamei xamei Altern. Unit
buchm buchm Book Quantity
xnull xnull Zero Count
menge menge_d Quantity
meins meins Base Unit
erfmg i_erfmg Qty in UnE
erfme i_erfme Unit of Entry
mblnr mblnr Material Doc.
mjahr mjahr Mat. Doc. Year
zeile mblpo Mat. Doc.Item
nblnr nblnr Recount Doc.
dmbtr difwr Difference Amt.
waers waers Currency
abcin abcin CC Phys. Inv.
ps_psp_pnr ps_psp_pnr WBS Element
vkwrt vkwrt SalVal inc. VAT
exvkw exvkw Sales Value
buchw buchw Book Value SP
kwart xwart Invent. VO-mat.
vkwra vkwra SalVal w/o VAT
vkmzl vkmzl Diff.SalesPrice
vknzl vknzl Diff.SalesPrice
wrtzl wrtzl Val. Cntd Qty
wrtbm wrtbm Value Book Qty
diwzl diwzl Diff. Value
attyp attyp Matl Category
grund grdif Reason f. Diff.
samat satnr Cross-plant CM
xdispatch xdispatch Distrib. Differences
sgt_scat sgt_scat Stock Segment
lastchange_datetime pi_last_changed Last Change
created_via mm_im_pi_created_via Created Via
counted_via mm_im_pi_counted_via Counted Via
posted_via mm_im_pi_posted_via Posted Via

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.

-- Physical Inventory Document Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISEG (
    MANDT,                -- Client [mandt]
    IBLNR,                -- Phys. Inv. Doc. [iblnr]
    GJAHR,                -- Fiscal Year [gjahr]
    ZEILI,                -- Item [dzeile]
    MATNR,                -- Material [matnr]
    WERKS,                -- Plant [werks_d]
    LGORT,                -- Location [lgort_d]
    CHARG,                -- Batch [charg_d]
    SOBKZ,                -- Special Stock [sobkz]
    BSTAR,                -- Stock Type [i_bstar]
    KDAUF,                -- Sales Order [kdauf]
    KDPOS,                -- Sales Ord. Item [kdpos]
    KDEIN,                -- SOrder schedule [kdein]
    LIFNR,                -- Supplier [elifn]
    KUNNR,                -- Customer [ekunn]
    PLPLA,                -- Distribution [plpla]
    USNAM,                -- Changed By [usnaa]
    AEDAT,                -- Changed On [aedat]
    USNAZ,                -- Counted By [usnaz]
    ZLDAT,                -- Count Date [dzldat]
    USNAD,                -- Adj. Posting By [usnad]
    BUDAT,                -- Posting Date [budat]
    XBLNI,                -- Phys.invent.ref [xblni1]
    XZAEL,                -- Item Counted [xzael]
    XDIFF,                -- Diff. posted [xdiff]
    XNZAE,                -- Recount [xnzae]
    XLOEK,                -- Deleted [i_xloek]
    XAMEI,                -- Altern. Unit [xamei]
    BUCHM,                -- Book Quantity [buchm]
    XNULL,                -- Zero Count [xnull]
    MENGE,                -- Quantity [menge_d]
    MEINS,                -- Base Unit [meins]
    ERFMG,                -- Qty in UnE [i_erfmg]
    ERFME,                -- Unit of Entry [i_erfme]
    MBLNR,                -- Material Doc. [mblnr]
    MJAHR,                -- Mat. Doc. Year [mjahr]
    ZEILE,                -- Mat. Doc.Item [mblpo]
    NBLNR,                -- Recount Doc. [nblnr]
    DMBTR,                -- Difference Amt. [difwr]
    WAERS,                -- Currency [waers]
    ABCIN,                -- CC Phys. Inv. [abcin]
    PS_PSP_PNR,           -- WBS Element [ps_psp_pnr]
    VKWRT,                -- SalVal inc. VAT [vkwrt]
    EXVKW,                -- Sales Value [exvkw]
    BUCHW,                -- Book Value SP [buchw]
    KWART,                -- Invent. VO-mat. [xwart]
    VKWRA,                -- SalVal w/o VAT [vkwra]
    VKMZL,                -- Diff.SalesPrice [vkmzl]
    VKNZL,                -- Diff.SalesPrice [vknzl]
    WRTZL,                -- Val. Cntd Qty [wrtzl]
    WRTBM,                -- Value Book Qty [wrtbm]
    DIWZL,                -- Diff. Value [diwzl]
    ATTYP,                -- Matl Category [attyp]
    GRUND,                -- Reason f. Diff. [grdif]
    SAMAT,                -- Cross-plant CM [satnr]
    XDISPATCH,            -- Distrib. Differences [xdispatch]
    SGT_SCAT,             -- Stock Segment [sgt_scat]
    LASTCHANGE_DATETIME,  -- Last Change [pi_last_changed]
    CREATED_VIA,          -- Created Via [mm_im_pi_created_via]
    COUNTED_VIA,          -- Counted Via [mm_im_pi_counted_via]
    POSTED_VIA,           -- Posted Via [mm_im_pi_posted_via]
    PRIMARY KEY (MANDT, IBLNR, GJAHR, ZEILI)
);

Learn More