- Home
- Resources
- SAP Tables
- LINV - Inventory data per quant
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.
Source: LINV (Inventory data per quant)
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 |
Possible values
| 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 |
Possible values
| 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 |
Possible values
| 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 |
Possible values
|
LINV foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| LINV |
ALTME |
LINV |
ALTME |
T006 |
Units of Measurement |
MSEHI |
| LINV |
ALTME |
LINV |
MANDT |
T006 |
Units of Measurement |
MANDT |
| LINV |
LENUM |
LINV |
LENUM |
LEIN |
Storage unit header records |
LENUM |
| LINV |
LENUM |
LINV |
MANDT |
LEIN |
Storage unit header records |
MANDT |
| LINV |
LETYP |
LINV |
LETYP |
T307 |
Storage Unit Types |
LETYP |
| LINV |
LETYP |
LINV |
LGNUM |
T307 |
Storage Unit Types |
LGNUM |
| LINV |
LETYP |
LINV |
MANDT |
T307 |
Storage Unit Types |
MANDT |
| LINV |
LGNUM |
LINV |
MANDT |
T300 |
WM Warehouse Numbers |
MANDT |
| LINV |
LGNUM |
LINV |
LGNUM |
T300 |
WM Warehouse Numbers |
LGNUM |
| LINV |
LGORT |
LINV |
WERKS |
T001L |
Storage Locations |
WERKS |
| LINV |
LGORT |
LINV |
MANDT |
T001L |
Storage Locations |
MANDT |
| 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 |
LGTYP |
T301 |
WM Storage Types |
LGTYP |
| LINV |
LGTYP |
LINV |
MANDT |
T301 |
WM Storage Types |
MANDT |
| LINV |
LGTYP |
LINV |
LGNUM |
T301 |
WM Storage Types |
LGNUM |
| LINV |
MATNR |
LINV |
MANDT |
MARA |
General Material Data |
MANDT |
| LINV |
MATNR |
LINV |
MATNR |
MARA |
General Material Data |
MATNR |
| LINV |
MEINS |
LINV |
MANDT |
T006 |
Units of Measurement |
MANDT |
| LINV |
MEINS |
LINV |
MEINS |
T006 |
Units of Measurement |
MSEHI |
| 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 |
