SAP ABAP Table ISEG (Physical Inventory Document Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ISEG	Table Relationship Diagram
Short Description	Physical Inventory Document Items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	IBLNR	☑	IBLNR	BELNR	CHAR	10	0	Physical inventory document
3	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	ZEILI	☑	DZEILE	ZEILE	NUMC	3	0	Line Number
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
7	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	MARD
8	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
9	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
10	BSTAR	☐	I_BSTAR	BSTAR	CHAR	1	0	Stock Type (Physical Inventory	T064B
11	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
12	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
13	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
14	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
15	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
16	PLPLA	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
17	USNAM	☐	USNAA	USNAM	CHAR	12	0	Changed by
18	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
19	USNAZ	☐	USNAZ	USNAM	CHAR	12	0	Counted By
20	ZLDAT	☐	DZLDAT	DATUM	DATS	8	0	Date of last count
21	USNAD	☐	USNAD	USNAM	CHAR	12	0	Adjustment posting made by
22	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
23	XBLNI	☐	XBLNI1	XBLNR1	CHAR	16	0	Reference Number for Physical Inventory
24	XZAEL	☐	XZAEL	XFELD	CHAR	1	0	Item has been counted
25	XDIFF	☐	XDIFF	XFELD	CHAR	1	0	Difference posted
26	XNZAE	☐	XNZAE	XFELD	CHAR	1	0	Item will be recounted
27	XLOEK	☐	I_XLOEK	XFELD	CHAR	1	0	Item is Deleted (Physical Inventory)
28	XAMEI	☐	XAMEI	XFELD	CHAR	1	0	Handling in Alternative Unit of Measure
29	BUCHM	☐	BUCHM	MENGV13	QUAN	13	3	Book quantity immediately prior to count
30	XNULL	☐	XNULL	XFELD	CHAR	1	0	Zero count
31	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
32	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
33	ERFMG	☐	I_ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry (physical inventory)
34	ERFME	☐	I_ERFME	MEINS	UNIT	3	0	Unit of entry (physical inventory)	T006
35	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
36	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
37	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
38	NBLNR	☐	NBLNR	BELNR	CHAR	10	0	Number of recount document
39	DMBTR	☐	DIFWR	WERT7	CURR	13	2	Difference amount in local currency
40	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
41	ABCIN	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting	T159C
42	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
43	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
44	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
45	BUCHW	☐	BUCHW	WERT13N	CURR	13	2	Book value based on sales prices (SP) at time of count
46	KWART	☐	XWART	XFELD	CHAR	1	0	Indicates that the value-only material is to be inventoried
47	VKWRA	☐	VKWRA	WERT7	CURR	13	2	Value at sales prices excluding value-added tax
48	VKMZL	☐	VKMZL	WERT7	CURR	13	2	Sales Value of Inv. Differences (with VAT) on Count Entry
49	VKNZL	☐	VKNZL	WERT7	CURR	13	2	Sales Value of Inventory Difference (w/o VAT) on Count Entry
50	WRTZL	☐	WRTZL	WERT7	CURR	13	2	Value of physical inventory count
51	WRTBM	☐	WRTBM	WERT7	CURR	13	2	Value of book quantity
52	DIWZL	☐	DIWZL	WERT7	CURR	13	2	Inventory difference value upon count entry
53	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
54	GRUND	☐	GRDIF	MB_GRBEW	NUMC	4	0	Reason for inventory diff.	T157D
55	SAMAT	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
56	XDISPATCH	☐	XDISPATCH	XFELD	CHAR	1	0	Distribution of Physical Inventory Differences
57	.INCLU--AP	☐				0	0	Retail Append for Physical Inventory Document Item
58	WSTI_COUNTDATE	☐	WSTI_COUNTDATE	WSTI_COUNTDATE	DATS	8	0	Date of Count During Opening Time
59	WSTI_COUNTTIME	☐	WSTI_COUNTTIME	WSTI_COUNTTIME	TIMS	6	0	Time of Count During Opening Time
60	WSTI_FREEZEDATE	☐	WSTI_FREEZEDATE	WSTI_FREEZEDATE	DATS	8	0	Freeze Date for Inventory Balance
61	WSTI_FREEZETIME	☐	WSTI_FREEZETIME	WSTI_FREEZETIME	TIMS	6	0	Freeze Time for Inventory Balance
62	WSTI_POSM	☐	WSTI_POSM	MENGV13	QUAN	13	3	Quantity to Which Book Quantity was Changed
63	WSTI_POSW	☐	WSTI_POSW	WERT13N	CURR	13	2	Retail Value to Which Retail Book Value was Changed
64	WSTI_XCALC	☐	WSTI_XCALC	XFELD	CHAR	1	0	Book Inventory Calculated at Count Time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISEG	ABCIN	T159C	ABCIN	KEY	1	CN
2	ISEG	BSTAR	T064B	BSTAR	REF	C	CN
3	ISEG	CHARG	MCHA	CHARG	REF	C	CN
4	ISEG	ERFME	T006	MSEHI	REF	1	N
5	ISEG	GRUND	T157D	GRUND	REF	C	CN
6	ISEG	KDAUF	VBUK	VBELN	REF	C	CN
7	ISEG	KUNNR	KNA1	KUNNR	REF	C	CN
8	ISEG	LGORT	MARD	LGORT	REF	C	CN
9	ISEG	LIFNR	LFA1	LIFNR	REF	C	CN
10	ISEG	MANDT	T000	MANDT	KEY	1	CN
11	ISEG	MATNR	MARA	MATNR	REF	C	CN
12	ISEG	MEINS	T006	MSEHI	REF	1	N
13	ISEG	PS_PSP_PNR	PRPS	PSPNR	REF	1	CN
14	ISEG	SAMAT	MARA	MATNR
15	ISEG	SOBKZ	T148	SOBKZ	REF	C	CN
16	ISEG	WAERS	TCURC	WAERS	REF	1	CN
17	ISEG	WERKS	MARC	WERKS	REF	C	CN

History

Last changed by/on	SAP	20030326
SAP Release Created in