SAP table LINV (Inventory data per quant)

SAP table LINV has 6 primary key fields being MANDT,LGNUM,IVNUM,IVPOS,LQNUM,NANUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
IVNUM Number of system inventory record CHAR 10 0 LVS_IVNUM
IVPOS Item number in inventory document NUMC 4 0 LVS_IVPOS
LQNUM Quant NUMC 10 0 LVS_LQNUM
NANUM Inventory recount number NUMC 2 0 LINV_NANUM
ISTAT Item status of inventory at quant level CHAR 1 0 LINV_ISTAT
NVERS Inventory recount version NUMC 2 0 LINV_NVERS
ISEIT Inventory page NUMC 4 0 LVS_ISEIT
LGTYP Storage Type CHAR 3 0 T301 LGTYP
LGPLA Storage Bin CHAR 10 0 LAGP LGPLA
PLPOS Position in storage bin CHAR 2 0 LVS_PLPOS
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
CHARG Batch Number CHAR 10 0 CHARG_D
LETYP Storage Unit Type CHAR 3 0 T307 LVS_LETYP
ANZLE Number of storage units corresponding to counted quantity DEC 9 3 LINV_ANZLE
MENGE Counted quantity in stockkeeping unit QUAN 13 3 LINV_MENGE
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MENGA Counted quantity in alternative unit of measure QUAN 13 3 LINV_MENGA
ALTME Alternative Unit of Measure for Stockkeeping Unit UNIT 3 0 T006 LRMEI
UMREZ Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
UMREN Denominator for conversion to base units of measure DEC 5 0 UMREN
BESTQ Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
SONUM Special Stock Number CHAR 16 0 LVS_SONUM
WDATU Date of Goods Receipt DATS 8 0 LVS_WDATU
GESME Total Quantity QUAN 13 3 LQUA_GESME
IDATU Date of inventory DATS 8 0 LVS_IDATU
KZINV Inventory method CHAR 2 0 LVS_KZINV
No inventory
CC Cycle counting
DC Dynamic Cycle Count
MA Manual inventory
PE Continuous inventory upon placement into stock
PN Continuous inventory based on zero stock check
PZ Continuous inventory
ST Annual inventory
IRNUM Inventory reference number CHAR 10 0 LVS_IRNUM
TANUM Transfer order number of continuous inventory procedure NUMC 10 0 LINV_TANUM
TAPOS Transfer order item of continuous inventory procedure NUMC 4 0 LINV_TAPOS
LENUM Storage Unit Number CHAR 20 0 LEIN LENUM
VFDAT Shelf Life Expiration or Best-Before Date DATS 8 0 VFDAT
LGORT Storage location CHAR 4 0 T001L LGORT_D
UNAME Name of counter for system inventory record CHAR 25 0 LINV_UNAME
QUINV Indicator for quant inventory CHAR 1 0 LINK_QUINV
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT

LINV foreign key relationships

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