SAP Table E3LINVX

IDoc confirm physical inventory count in WM

E3LINVX (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 E3LINVX to other SAP tables.

Source: E3LINVX (IDoc confirm physical inventory count in WM)

E3LINVX 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 Item number in inventory document LVS_IVPOS NUMC 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 LVS_WDATU DATS 8 0
LENUM Storage Unit Number LENUM CHAR 20 0
MENGA Quantity for counting result entry LIDO_MENGA CHAR 15 0
ALTME Alternative Unit of Measure for Stockkeeping Unit LRMEI UNIT 3 0
LQNUM Quant LVS_LQNUM NUMC 10 0
NANUM Inventory recount number LINV_NANUM NUMC 2 0
NVERS Inventory recount version LINV_NVERS NUMC 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 inventory LVS_IDATU DATS 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 LVS_ISEIT NUMC 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 Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0