SAP table ISEG (Physical Inventory Document Items)

SAP table ISEG has 4 primary key fields being MANDT,IBLNR,GJAHR,ZEILI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
IBLNR Physical Inventory Document CHAR 10 0 IBLNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
ZEILI Line Number NUMC 3 0 DZEILE
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 MARC WERKS_D
LGORT Storage location CHAR 4 0 MARD LGORT_D
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
BSTAR Stock Type (Physical Inventory) CHAR 1 0 T064B I_BSTAR
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
KDEIN Delivery schedule for sales order NUMC 4 0 KDEIN
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
KUNNR Account number of customer CHAR 10 0 KNA1 EKUNN
PLPLA Distribution of Differences CHAR 10 0 PLPLA
USNAM Changed By CHAR 12 0 USNAA
AEDAT Last Changed On DATS 8 0 AEDAT
USNAZ Counted By CHAR 12 0 USNAZ
ZLDAT Date of Last Count DATS 8 0 DZLDAT
USNAD Adjustment Posting Made By CHAR 12 0 USNAD
BUDAT Posting Date in the Document DATS 8 0 BUDAT
XBLNI Reference Number for Physical Inventory CHAR 16 0 XBLNI1
XZAEL Item has been counted CHAR 1 0 XZAEL
XDIFF Difference posted CHAR 1 0 XDIFF
XNZAE Item will be recounted CHAR 1 0 XNZAE
XLOEK Item is Deleted (Physical Inventory) CHAR 1 0 I_XLOEK
XAMEI Handling in Alternative Unit of Measure CHAR 1 0 XAMEI
BUCHM Book Quantity Immediately Prior to Count QUAN 13 3 BUCHM
XNULL Zero Count CHAR 1 0 XNULL
MENGE Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
ERFMG Quantity in Unit of Entry (Physical Inventory) QUAN 13 3 I_ERFMG
ERFME Unit of Entry (Physical Inventory) UNIT 3 0 T006 I_ERFME
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
ZEILE Item in Material Document NUMC 4 0 MBLPO
NBLNR Number of Recount Document CHAR 10 0 NBLNR
DMBTR Difference Amount in Local Currency CURR 13 2 DIFWR
WAERS Currency Key CUKY 5 0 TCURC WAERS
ABCIN Physical Inventory Indicator for Cycle Counting CHAR 1 0 T159C ABCIN
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
VKWRT Value at Sales Prices Including Value-Added Tax CURR 13 2 VKWRT
EXVKW Externally Entered Sales Value in Local Currency CURR 13 2 EXVKW
BUCHW Book Value Based on Sales Prices at Time of Count CURR 13 2 BUCHW
KWART Indicates that the value-only material is to be inventoried CHAR 1 0 XWART
VKWRA Value at Sales Prices Excluding Value Added Tax CURR 13 2 VKWRA
VKMZL Sales Value of Inv. Differences (with VAT) on Count Entry CURR 13 2 VKMZL
VKNZL Sales Value of Inventory Difference (w/o VAT) on Count Entry CURR 13 2 VKNZL
WRTZL Value of Physical Inventory Count CURR 13 2 WRTZL
WRTBM Value of Book Quantity CURR 13 2 WRTBM
DIWZL Inventory Difference Value Upon Count Entry CURR 13 2 DIWZL
ATTYP Material Category CHAR 2 0 ATTYP
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
GRUND Reason for Inventory Difference NUMC 4 0 T157D GRDIF
SAMAT Cross-Plant Configurable Material CHAR 40 0 MARA SATNR
XDISPATCH Distribution of Physical Inventory Differences CHAR 1 0 XDISPATCH
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
LASTCHANGE_DATETIME Last Change Timestamp DEC 21 7 PI_LAST_CHANGED
DUMMY_ISEG_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
/CWM/BUCHM Book Quantity for Counting in PUoM QUAN 13 3 /CWM/BUCHM
/CWM/XNULL Zero Count CHAR 1 0 /CWM/XNULL
/CWM/MENGE Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/MENGE
/CWM/MEINS Parallel Unit of Measure UNIT 3 0 T006 /CWM/MEINS
/CWM/ERFMG Quantity in Parallel Unit of Entry QUAN 13 3 /CWM/ERFMG
/CWM/ERFME PUoM Entry Unit of Measure UNIT 3 0 T006 /CWM/ERFME
/CWM/ZEILE2 Number of Line Item of 2 Quantity of Material Document NUMC 3 0 /CWM/ZEILE2
DISUB_OWNER Owner of stock CHAR 10 0 * OWNER_D
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
WSTI_COUNTDATE Date of Count During Opening Time DATS 8 0 WSTI_COUNTDATE
WSTI_COUNTTIME Time of Count During Opening Time TIMS 6 0 WSTI_COUNTTIME
WSTI_FREEZEDATE Freeze Date for Inventory Balance DATS 8 0 WSTI_FREEZEDATE
WSTI_FREEZETIME Freeze Time for Inventory Balance TIMS 6 0 WSTI_FREEZETIME
WSTI_POSM Quantity to Which Book Quantity was Changed QUAN 13 3 WSTI_POSM
WSTI_POSW Retail Value to Which Retail Book Value was Changed CURR 13 2 WSTI_POSW
WSTI_XCALC Book Inventory Calculated at Count Time CHAR 1 0 WSTI_XCALC
WSTI_ENTERDATE Entry Date of Physical Inventory Count in System DATS 8 0 WSTI_ENTERDATE
WSTI_ENTERTIME Entry Time of Physical Inventory Count in System TIMS 6 0 WSTI_ENTERTIME

ISEG foreign key relationships

Table Field Check Table Check Field
0 ISEG /CWM/ERFME T006 Units of Measurement MANDT
0 ISEG /CWM/ERFME T006 Units of Measurement MSEHI
1 ISEG /CWM/MEINS T006 Units of Measurement MANDT
1 ISEG /CWM/MEINS T006 Units of Measurement MSEHI
0 ISEG ABCIN T159C Value table for counting cycles in cycle counting MANDT
0 ISEG ABCIN T159C Value table for counting cycles in cycle counting WERKS
0 ISEG ABCIN T159C Value table for counting cycles in cycle counting ABCIN
1 ISEG BSTAR T064B Stock Types and Texts for Physical Inventory SPRAS
1 ISEG BSTAR T064B Stock Types and Texts for Physical Inventory BSTAR
0 ISEG CHARG MCHA Batches MANDT
0 ISEG CHARG MCHA Batches WERKS
0 ISEG CHARG MCHA Batches CHARG
1 ISEG ERFME T006 Units of Measurement MANDT
0 ISEG GRUND T157D Reason for Movement MANDT
1 ISEG KUNNR KNA1 General Data in Customer Master MANDT
1 ISEG KUNNR KNA1 General Data in Customer Master KUNNR
0 ISEG LGORT MARD Storage Location Data for Material MANDT
0 ISEG LGORT MARD Storage Location Data for Material MATNR
0 ISEG LGORT MARD Storage Location Data for Material WERKS
0 ISEG LGORT MARD Storage Location Data for Material LGORT
1 ISEG LIFNR LFA1 Supplier Master (General Section) MANDT
1 ISEG LIFNR LFA1 Supplier Master (General Section) LIFNR
0 ISEG MANDT T000 Clients MANDT
1 ISEG MATNR MARA General Material Data MANDT
1 ISEG MATNR MARA General Material Data MATNR
0 ISEG MEINS T006 Units of Measurement MANDT
0 ISEG MEINS T006 Units of Measurement MSEHI
1 ISEG PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 ISEG PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 ISEG SAMAT MARA General Material Data MATNR
1 ISEG SOBKZ T148 Special Stock Indicator MANDT
1 ISEG SOBKZ T148 Special Stock Indicator SOBKZ
0 ISEG WAERS TCURC Currency Codes MANDT
0 ISEG WAERS TCURC Currency Codes WAERS
1 ISEG WERKS MARC Plant Data for Material MANDT
1 ISEG WERKS MARC Plant Data for Material MATNR
1 ISEG WERKS MARC Plant Data for Material WERKS