SAP LINV Inventory data per quant Table data and field list

LINV is a standard SAP Table which is used to store Inventory data per quant data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The LINV table consists of various fields, each holding specific information or linking keys about Inventory data per quant data available in SAP. These include LGNUM (Warehouse Number / Warehouse Complex), IVNUM (Number of system inventory record), IVPOS (Item number in inventory document), LQNUM (Quant)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

LINV table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP LINV table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the LINV table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
LGNUM	Warehouse Number / Warehouse Complex	LGNUM	CHAR	3	T300		LGNUM	LGN
IVNUM	Number of system inventory record	LVS_IVNUM	CHAR	10		ALPHA	BELNR	IVN
IVPOS	Item number in inventory document	LVS_IVPOS	NUMC	4			LVS_IVPOS
LQNUM	Quant	LVS_LQNUM	NUMC	10			LVS_LQNUM	LQN
NANUM	Inventory recount number	LINV_NANUM	NUMC	2			LVS_NANUM	NAN
ISTAT	Item status of inventory at quant level	LINV_ISTAT	CHAR	1			LVS_ISTAT
NVERS	Inventory recount version	LINV_NVERS	NUMC	2			LVS_NANUM
ISEIT	Inventory page	LVS_ISEIT	NUMC	4			LVS_ISEIT
LGTYP	Storage Type	LGTYP	CHAR	3	T301		LGTYP	LGT	H_T301
LGPLA	Storage Bin	LGPLA	CHAR	10	LAGP		LGPLA	LGP	LAG1
PLPOS	Position in storage bin	LVS_PLPOS	CHAR	2			LVS_PLPOS
MATNR	Material Number	MATNR	CHAR	18	MARA	MATN1	MATNR	MAT	S_MAT1
WERKS	Plant	WERKS_D	CHAR	4	T001W		WERKS	WRK	H_T001W_C
CHARG	Batch Number	CHARG_D	CHAR	10	Assigned to domain		CHARG	CHA
LETYP	Storage Unit Type	LVS_LETYP	CHAR	3	T307		LVS_LETYP
ANZLE	Number of storage units corresponding to counted quantity	LINV_ANZLE	DEC	9(3)			LAGP_ANZLE
MENGE	Counted quantity in stockkeeping unit	LINV_MENGE	QUAN	13(3)			MENG13
MEINS	Base Unit of Measure	MEINS	UNIT	3	T006	CUNIT	MEINS
MENGA	Counted quantity in alternative unit of measure	LINV_MENGA	QUAN	13(3)			MENG13
ALTME	Alternative Unit of Measure for Stockkeeping Unit	LRMEI	UNIT	3	T006	CUNIT	MEINS
UMREZ	Numerator for Conversion to Base Units of Measure	UMREZ	DEC	5			UMBSZ
UMREN	Denominator for conversion to base units of measure	UMREN	DEC	5			UMBSN
BESTQ	Stock Category in the Warehouse Management System	BESTQ	CHAR	1			BESTQ
SOBKZ	Special Stock Indicator	SOBKZ	CHAR	1	T148		SOBKZ
SONUM	Special Stock Number	LVS_SONUM	CHAR	16		ALPHA	LVS_SONUM
WDATU	Date of Goods Receipt	LVS_WDATU	DATS	8			DATUM
GESME	Total Quantity	LQUA_GESME	QUAN	13(3)			MENSH
IDATU	Date of inventory	LVS_IDATU	DATS	8			DATUM
KZINV	Inventory method	LVS_KZINV	CHAR	2			LVS_KZINV
IRNUM	Inventory reference number	LVS_IRNUM	CHAR	10			LVS_IRNUM
TANUM	Transfer order number of continuous inventory procedure	LINV_TANUM	NUMC	10			TANUM	TAN
TAPOS	Transfer order item of continuous inventory procedure	LINV_TAPOS	NUMC	4			TAPOS	TAP
LENUM	Storage Unit Number	LENUM	CHAR	20	LEIN	LENUM	LENUM	LEN
VFDAT	Shelf Life Expiration or Best-Before Date	VFDAT	DATS	8			DATUM
LGORT	Storage Location	LGORT_D	CHAR	4	T001L		LGORT	LAG
UNAME	Name of counter for system inventory record	LINV_UNAME	CHAR	25			CHAR25
QUINV	Indicator for quant inventory	LINK_QUINV	CHAR	1			XFELD

Key field

Non-key field

< LINP_VB - Transfer structure LINP + LINP1 for update task LINV1 - Help fields for loop processing of LINV segments >

How do I retrieve data from SAP table LINV using ABAP code

The following ABAP code Example will allow you to do a basic selection on LINV to SELECT all data from the table
DATA: WA_LINV TYPE LINV.

SELECT SINGLE *
FROM LINV
INTO CORRESPONDING FIELDS OF WA_LINV
WHERE...

How to access SAP table LINV

Within an ECC or HANA version of SAP you can also view further information about LINV and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to LINV

    LAGP - Storage bins
        LINV - Inventory data per quant

    LINK - Inventory document header in WM
        LINP - Inventory document item in WM
            LINV - Inventory data per quant

    LINV - Inventory data per quant

LINV - Inventory data per quant