SAP ABAP Table EISEG (Import ISEG for FM physical inventory)

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	INTTAB	Structure
Structure	EISEG	Table Relationship Diagram
Short Description	Import ISEG for FM physical inventory

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in