SAP Table E1LINVX

IDoc confirm physical inventory count in WM

E1LINVX (IDoc confirm physical inventory count in WM) 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 E1LINVX to other SAP tables.

E1LINVX table fields

Field Data element Checktable Datatype Length Decimals
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
IVNUM Number of system inventory record LVS_IVNUM CHAR 10 0
IVPOS Physical inventory item LIDO_IVPOS CHAR 4 0
LGTYP Storage Type LGTYP CHAR 3 0
LGPLA Storage Bin LGPLA CHAR 10 0
PLPOS Position in storage bin LVS_PLPOS CHAR 2 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
LSONR Special Stock Number LVS_LSONR CHAR 24 0
BESTQ Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
WDATU Date of goods receipt LIDO_WDATU CHAR 8 0
LENUM Storage Unit Number LENUM CHAR 20 0
MENGA Quantity for counting result entry LIDO_MENGA CHAR 15 0
ALTME Unit of measure EDI6411_E CHAR 3 0
LQNUM Quant number LIDO_LQNUM CHAR 10 0
NANUM Inventory recount number LIDO_NANUM CHAR 2 0
NVERS Inventory recount version LIDO_NVERS CHAR 2 0
ISTAT Item status of inventory at quant level LINV_ISTAT CHAR 1 0
A Partially counted
L Cleared
N Not counted
Z Counted
S canceled
D Dynamic Cycle Count
IDATU Date of physical inventory LIDO_IDATU CHAR 8 0
KZINV Inventory method LVS_KZINV CHAR 2 0
NULL No inventory
PE Continuous inventory upon placement into stock
PN Continuous inventory based on zero stock check
PZ Continuous inventory
ST Annual inventory
MA Manual inventory
CC Cycle counting
DC Dynamic Cycle Count
IRNUM Inventory reference number LVS_IRNUM CHAR 10 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
ISEIT Inventory page LIDO_ISEIT CHAR 4 0
LETYP Storage Unit Type LVS_LETYP CHAR 3 0
KZNUL Indicator: storage bin empty or quant does not exist RL04IKZNUL CHAR 1 0
X Yes
NULL No
VFDAT Expiration Date or Best-Before Date (IDoc) LIDO_VFDAT CHAR 8 0
LGORT CHAR 4 0
UNAME CHAR 25 0
MATNR_EXTERNAL CHAR 40 0
MATNR_VERSION CHAR 10 0
MATNR_GUID CHAR 32 0