SAP Table LINV

Inventory data per quant

LINV (Inventory data per quant) 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 LINV to other SAP tables.

LINV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LGNUM Warehouse Number / Warehouse Complex LGNUM T300 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
LQNUM Quant LVS_LQNUM NUMC 10 0
NANUM Inventory recount number LINV_NANUM 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
NVERS Inventory recount version LINV_NVERS NUMC 2 0
ISEIT Inventory page LVS_ISEIT NUMC 4 0
LGTYP Storage Type LGTYP T301 CHAR 3 0
LGPLA Storage Bin LGPLA LAGP CHAR 10 0
PLPOS Position in storage bin LVS_PLPOS CHAR 2 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
LETYP Storage Unit Type LVS_LETYP T307 CHAR 3 0
ANZLE Number of storage units corresponding to counted quantity LINV_ANZLE DEC 9 3
MENGE Counted quantity in stockkeeping unit LINV_MENGE QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MENGA Counted quantity in alternative unit of measure LINV_MENGA QUAN 13 3
ALTME Alternative Unit of Measure for Stockkeeping Unit LRMEI T006 UNIT 3 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 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
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
SONUM Special Stock Number LVS_SONUM CHAR 16 0
WDATU Date of Goods Receipt LVS_WDATU DATS 8 0
GESME Total Quantity LQUA_GESME QUAN 13 3
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
TANUM Transfer order number of continuous inventory procedure LINV_TANUM NUMC 10 0
TAPOS Transfer order item of continuous inventory procedure LINV_TAPOS NUMC 4 0
LENUM Storage Unit Number LENUM LEIN CHAR 20 0
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
UNAME Name of counter for system inventory record LINV_UNAME CHAR 25 0
QUINV Indicator for quant inventory LINK_QUINV CHAR 1 0
X Yes
NULL No

LINV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LINV ALTME LINV MANDT T006 Units of Measurement MANDT
LINV ALTME LINV ALTME T006 Units of Measurement MSEHI
LINV LENUM LINV MANDT LEIN Storage unit header records MANDT
LINV LENUM LINV LENUM LEIN Storage unit header records LENUM
LINV LETYP LINV MANDT T307 Storage Unit Types MANDT
LINV LETYP LINV LGNUM T307 Storage Unit Types LGNUM
LINV LETYP LINV LETYP T307 Storage Unit Types LETYP
LINV LGNUM LINV MANDT T300 WM Warehouse Numbers MANDT
LINV LGNUM LINV LGNUM T300 WM Warehouse Numbers LGNUM
LINV LGORT LINV MANDT T001L Storage Locations MANDT
LINV LGORT LINV WERKS T001L Storage Locations WERKS
LINV LGORT LINV LGORT T001L Storage Locations LGORT
LINV LGPLA LINV MANDT LAGP Storage bins MANDT
LINV LGPLA LINV LGNUM LAGP Storage bins LGNUM
LINV LGPLA LINV LGTYP LAGP Storage bins LGTYP
LINV LGPLA LINV LGPLA LAGP Storage bins LGPLA
LINV LGTYP LINV LGNUM T301 WM Storage Types LGNUM
LINV LGTYP LINV LGTYP T301 WM Storage Types LGTYP
LINV LGTYP LINV MANDT T301 WM Storage Types MANDT
LINV MATNR LINV MANDT MARA General Material Data MANDT
LINV MATNR LINV MATNR MARA General Material Data MATNR
LINV MEINS LINV MEINS T006 Units of Measurement MSEHI
LINV MEINS LINV MANDT T006 Units of Measurement MANDT
LINV SOBKZ LINV MANDT T148 Special Stock Indicator MANDT
LINV SOBKZ LINV SOBKZ T148 Special Stock Indicator SOBKZ
LINV WERKS LINV MANDT T001W Plants/Branches MANDT
LINV WERKS LINV WERKS T001W Plants/Branches WERKS