SAP ABAP Table LINV (Inventory data per quant)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ LVS (Package) Application development Warehouse Management (WM)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	LINV	Table Relationship Diagram
Short Description	Inventory data per quant

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	LGNUM	☑	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
3	IVNUM	☑	LVS_IVNUM	BELNR	CHAR	10	0	Number of system inventory record
4	IVPOS	☑	LVS_IVPOS	LVS_IVPOS	NUMC	4	0	Item number in inventory document
5	LQNUM	☑	LVS_LQNUM	LVS_LQNUM	NUMC	10	0	Quant
6	NANUM	☑	LINV_NANUM	LVS_NANUM	NUMC	2	0	Inventory recount number
7	ISTAT	☐	LINV_ISTAT	LVS_ISTAT	CHAR	1	0	Item status of inventory at quant level
8	NVERS	☐	LINV_NVERS	LVS_NANUM	NUMC	2	0	Inventory recount version
9	ISEIT	☐	LVS_ISEIT	LVS_ISEIT	NUMC	4	0	Inventory page
10	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
11	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
12	PLPOS	☐	LVS_PLPOS	LVS_PLPOS	CHAR	2	0	Position in storage bin
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
15	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
16	LETYP	☐	LVS_LETYP	LVS_LETYP	CHAR	3	0	Storage Unit Type	T307
17	ANZLE	☐	LINV_ANZLE	LAGP_ANZLE	DEC	9	3	Number of storage units corresponding to counted quantity
18	MENGE	☐	LINV_MENGE	MENG13	QUAN	13	3	Counted quantity in stockkeeping unit
19	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
20	MENGA	☐	LINV_MENGA	MENG13	QUAN	13	3	Counted quantity in alternative unit of measure
21	ALTME	☐	LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	T006
22	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
23	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
24	BESTQ	☐	BESTQ	BESTQ	CHAR	1	0	Stock Category in the Warehouse Management System
25	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
26	SONUM	☐	LVS_SONUM	LVS_SONUM	CHAR	16	0	Special Stock Number
27	WDATU	☐	LVS_WDATU	DATUM	DATS	8	0	Date of goods receipt
28	GESME	☐	LQUA_GESME	MENSH	QUAN	13	3	Total Quantity
29	IDATU	☐	LVS_IDATU	DATUM	DATS	8	0	Date of inventory
30	KZINV	☐	LVS_KZINV	LVS_KZINV	CHAR	2	0	Inventory method
31	IRNUM	☐	LVS_IRNUM	LVS_IRNUM	CHAR	10	0	Inventory reference number
32	TANUM	☐	LINV_TANUM	TANUM	NUMC	10	0	Transfer order number of continuous inventory procedure
33	TAPOS	☐	LINV_TAPOS	TAPOS	NUMC	4	0	Transfer order item of continuous inventory procedure
34	LENUM	☐	LENUM	LENUM	CHAR	20	0	Storage Unit Number	LEIN
35	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
36	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
37	UNAME	☐	LINV_UNAME	CHAR25	CHAR	25	0	Name of counter for system inventory record
38	QUINV	☐	LINK_QUINV	XFELD	CHAR	1	0	Indicator for quant inventory

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LINV	ALTME	T006	MSEHI	REF	C	CN
2	LINV	LENUM	LEIN	LENUM	REF	C	CN
3	LINV	LETYP	T307	LETYP	REF	C	CN
4	LINV	LGNUM	T300	LGNUM
5	LINV	LGORT	T001L	LGORT
6	LINV	LGPLA	LAGP	LGPLA	REF	1	CN
7	LINV	LGTYP	T301	LGTYP
8	LINV	MATNR	MARA	MATNR
9	LINV	MEINS	T006	MSEHI	REF	1	CN
10	LINV	SOBKZ	T148	SOBKZ	REF	C	CN
11	LINV	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in