1. Home
  2. Resources
  3. SAP Tables
  4. EISEG - Import ISEG for FM physical inventory

SAP Table EISEG

Import ISEG for FM physical inventory

EISEG (Import ISEG for FM physical inventory) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EISEG to other SAP tables.

Source: EISEG (Import ISEG for FM physical inventory)

EISEG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
IBLNR Physical Inventory Document IBLNR CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
ZEILI Line Number DZEILE NUMC 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MARC CHAR 4 0
LGORT Storage Location LGORT_D MARD CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
BSTAR Stock Type (Physical Inventory I_BSTAR T064B CHAR 1 0
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
KUNNR Account Number of Customer EKUNN KNA1 CHAR 10 0
PLPLA Distribution of Differences PLPLA CHAR 10 0
USNAM Changed by USNAA CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
USNAZ Counted By USNAZ CHAR 12 0
ZLDAT Date of last count DZLDAT DATS 8 0
USNAD Adjustment posting made by USNAD CHAR 12 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
XBLNI Reference Number for Physical Inventory XBLNI1 CHAR 16 0
XZAEL Item has been counted XZAEL CHAR 1 0
X Yes
NULL No
XDIFF Difference posted XDIFF CHAR 1 0
X Yes
NULL No
XNZAE Item will be recounted XNZAE CHAR 1 0
X Yes
NULL No
XLOEK Item is Deleted (Physical Inventory) I_XLOEK CHAR 1 0
X Yes
NULL No
XAMEI Handling in Alternative Unit of Measure XAMEI CHAR 1 0
X Yes
NULL No
BUCHM Book quantity immediately prior to count BUCHM QUAN 13 3
XNULL Zero count XNULL CHAR 1 0
X Yes
NULL No
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
ERFMG Quantity in unit of entry (physical inventory) I_ERFMG QUAN 13 3
ERFME Unit of entry (physical inventory) I_ERFME T006 UNIT 3 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
ZEILE Item in Material Document MBLPO NUMC 4 0
NBLNR Number of recount document NBLNR CHAR 10 0
DMBTR Difference amount in local currency DIFWR CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
ABCIN Physical inventory indicator for cycle counting ABCIN T159C CHAR 1 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
VKWRT Value at Sales Prices Including Value-Added Tax VKWRT CURR 13 2
EXVKW Externally Entered Sales Value in Local Currency EXVKW CURR 13 2
BUCHW Book value based on sales prices (SP) at time of count BUCHW CURR 13 2
KWART Indicates that the value-only material is to be inventoried XWART CHAR 1 0
X Yes
NULL No
VKWRA Value at sales prices excluding value-added tax VKWRA CURR 13 2
VKMZL Sales Value of Inv. Differences (with VAT) on Count Entry VKMZL CURR 13 2
VKNZL Sales Value of Inventory Difference (w/o VAT) on Count Entry VKNZL CURR 13 2
WRTZL Value of physical inventory count WRTZL CURR 13 2
WRTBM Value of book quantity WRTBM CURR 13 2
DIWZL Inventory difference value upon count entry DIWZL CURR 13 2
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
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 diff. GRDIF T157D NUMC 4 0
SAMAT Cross-Plant Configurable Material SATNR MARA CHAR 18 0
XDISPATCH Distribution of Physical Inventory Differences XDISPATCH CHAR 1 0
X Yes
NULL No
/CWM/BUCHM Book Quantity for Counting in PUoM /CWM/BUCHM QUAN 13 3
/CWM/XNULL Zero Count /CWM/XNULL CHAR 1 0
X Yes
NULL No
/CWM/MENGE Quantity in Parallel Unit of Measure /CWM/MENGE QUAN 13 3
/CWM/MEINS Parallel Unit of Measure /CWM/MEINS T006 UNIT 3 0
/CWM/ERFMG Quantity in Parallel Unit of Entry /CWM/ERFMG QUAN 13 3
/CWM/ERFME PUoM Entry Unit of Measure /CWM/ERFME T006 UNIT 3 0
/CWM/ZEILE2 Number of Line Item of 2 Quantity of Material Document /CWM/ZEILE2 NUMC 3 0
DISUB_OWNER Owner of stock OWNER_D CHAR 10 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
WSTI_COUNTDATE Date of Count During Opening Time WSTI_COUNTDATE DATS 8 0
WSTI_COUNTTIME Time of Count During Opening Time WSTI_COUNTTIME TIMS 6 0
WSTI_FREEZEDATE Freeze Date for Inventory Balance WSTI_FREEZEDATE DATS 8 0
WSTI_FREEZETIME Freeze Time for Inventory Balance WSTI_FREEZETIME TIMS 6 0
WSTI_POSM Quantity to Which Book Quantity was Changed WSTI_POSM QUAN 13 3
WSTI_POSW Retail Value to Which Retail Book Value was Changed WSTI_POSW CURR 13 2
WSTI_XCALC Book Inventory Calculated at Count Time WSTI_XCALC CHAR 1 0
X Yes
NULL No
WSTI_ENTERDATE Entry Date of Physical Inventory Count in System WSTI_ENTERDATE DATS 8 0
WSTI_ENTERTIME Entry Time of Physical Inventory Count in System WSTI_ENTERTIME TIMS 6 0
SUBRC Return Code SYSUBRC INT4 10 0
MSGID Message identification MSGID CHAR 20 0
MSGNO System Message Number MSGNO CHAR 3 0
MSGTY Message Type MSGTY CHAR 1 0
S Message on next screen
I Information
A Cancel
E Error
W Warning
MSGV1 Message variable 01 MSGV1 CHAR 50 0
MSGV2 Message variable 02 MSGV2 CHAR 50 0
MSGV3 Message variable 03 MSGV3 CHAR 50 0
MSGV4 Message variable 04 MSGV4 CHAR 50 0

EISEG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EISEG /CWM/ERFME EISEG /CWM/ERFME T006 Units of Measurement MSEHI
EISEG /CWM/ERFME EISEG MANDT T006 Units of Measurement MANDT
EISEG /CWM/MEINS EISEG /CWM/MEINS T006 Units of Measurement MSEHI
EISEG /CWM/MEINS EISEG MANDT T006 Units of Measurement MANDT
EISEG ABCIN EISEG WERKS T159C Value table for counting cycles in cycle counting WERKS
EISEG ABCIN EISEG ABCIN T159C Value table for counting cycles in cycle counting ABCIN
EISEG ABCIN SY MANDT T159C Value table for counting cycles in cycle counting MANDT
EISEG BSTAR EISEG BSTAR T064B Stock Types and Texts for Physical Inventory BSTAR
EISEG BSTAR SY MANDT T064B Stock Types and Texts for Physical Inventory SPRAS
EISEG CHARG SY MANDT MCHA Batches MANDT
EISEG CHARG EISEG CHARG MCHA Batches CHARG
EISEG CHARG EISEG WERKS MCHA Batches WERKS
EISEG CHARG EISEG MATNR MCHA Batches MATNR
EISEG ERFME SY MANDT T006 Units of Measurement MANDT
EISEG ERFME EISEG ERFME T006 Units of Measurement MSEHI
EISEG GRUND EISEG GRUND T157D Reason for Movement GRUND
EISEG GRUND * T157D Reason for Movement BWART
EISEG GRUND EISEG MANDT T157D Reason for Movement MANDT
EISEG KDAUF EISEG KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
EISEG KDAUF SY MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
EISEG KUNNR SY MANDT KNA1 General Data in Customer Master MANDT
EISEG KUNNR EISEG KUNNR KNA1 General Data in Customer Master KUNNR
EISEG LGORT SY MANDT MARD Storage Location Data for Material MANDT
EISEG LGORT EISEG LGORT MARD Storage Location Data for Material LGORT
EISEG LGORT EISEG MATNR MARD Storage Location Data for Material MATNR
EISEG LGORT EISEG WERKS MARD Storage Location Data for Material WERKS
EISEG LIFNR SY MANDT LFA1 Vendor Master (General Section) MANDT
EISEG LIFNR EISEG LIFNR LFA1 Vendor Master (General Section) LIFNR
EISEG MANDT EISEG MANDT T000 Clients MANDT
EISEG MATNR SY MANDT MARA General Material Data MANDT
EISEG MATNR EISEG MATNR MARA General Material Data MATNR
EISEG MEINS EISEG MEINS T006 Units of Measurement MSEHI
EISEG MEINS SY MANDT T006 Units of Measurement MANDT
EISEG PS_PSP_PNR SY MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
EISEG PS_PSP_PNR EISEG PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
EISEG SAMAT EISEG SAMAT MARA General Material Data MATNR
EISEG SAMAT EISEG MANDT MARA General Material Data MANDT
EISEG SOBKZ SY MANDT T148 Special Stock Indicator MANDT
EISEG SOBKZ EISEG SOBKZ T148 Special Stock Indicator SOBKZ
EISEG WAERS SY MANDT TCURC Currency Codes MANDT
EISEG WAERS EISEG WAERS TCURC Currency Codes WAERS
EISEG WERKS EISEG WERKS MARC Plant Data for Material WERKS
EISEG WERKS EISEG MATNR MARC Plant Data for Material MATNR
EISEG WERKS SY MANDT MARC Plant Data for Material MANDT