SAP Table LQUA
Quants
LQUA (Quants) 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 LQUA to other SAP tables.
LQUA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||
|
LGNUM
Warehouse Number / Warehouse Complex
|
LGNUM | T300 |
CHAR
|
3 | 0 | |||||||||||
|
LQNUM
Quant
|
LVS_LQNUM |
NUMC
|
10 | 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 | ||||||||||||
|
BESTQ
Stock Category in the Warehouse Management System
|
BESTQ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SOBKZ
Special Stock Indicator
|
SOBKZ | T148 |
CHAR
|
1 | 0 | |||||||||||
|
SONUM
Special Stock Number
|
LVS_SONUM |
CHAR
|
16 | 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 | ||||||||||||
|
SKZUE
Blocking indicator: for putaways (user)
|
LQUA_SKZUE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SKZUA
Blocking Indicator: For Stock Removals (User)
|
LQUA_SKZUA |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SKZSE
Blocking indicator: current placement into stock (system)
|
LQUA_SKZSE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SKZSA
Blocking Indicator: Current Stock Removal (System)
|
LQUA_SKZSA |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SKZSI
Blocking Indicator: Current Inventory (System)
|
LQUA_SKZSI |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SPGRU
Blocking reason
|
LVS_SPGRU | T330 |
CHAR
|
1 | 0 | |||||||||||
|
ZEUGN
Certificate Number
|
LVS_ZEUGN |
CHAR
|
10 | 0 | ||||||||||||
|
BDATU
Date of last movement
|
LQUA_BDATU |
DATS
|
8 | 0 | ||||||||||||
|
BZEIT
Time of last movement
|
LQUA_BZEIT |
TIMS
|
6 | 0 | ||||||||||||
|
BTANR
Document Number of Last Stock Change in Quant
|
LQUA_BTANR |
NUMC
|
10 | 0 | ||||||||||||
|
BTAPS
Item in transfer order of last stock transfer
|
LQUA_BTAPS |
NUMC
|
4 | 0 | ||||||||||||
|
EDATU
Date of last placement into stock
|
LQUA_EDATU |
DATS
|
8 | 0 | ||||||||||||
|
EZEIT
Time of last placement into stock
|
LQUA_EZEIT |
TIMS
|
6 | 0 | ||||||||||||
|
ADATU
Date of last stock removal
|
LQUA_ADATU |
DATS
|
8 | 0 | ||||||||||||
|
AZEIT
Time of last stock removal
|
LQUA_AZEIT |
TIMS
|
6 | 0 | ||||||||||||
|
ZDATU
Date of last addition to existing stock
|
LQUA_ZDATU |
DATS
|
8 | 0 | ||||||||||||
|
WDATU
Date of Goods Receipt
|
LVS_WDATU |
DATS
|
8 | 0 | ||||||||||||
|
WENUM
Goods Receipt Number
|
LVS_WENUM |
CHAR
|
10 | 0 | ||||||||||||
|
WEPOS
Goods receipt item
|
LVS_WEPOS |
NUMC
|
4 | 0 | ||||||||||||
|
LETYP
Storage Unit Type
|
LVS_LETYP | T307 |
CHAR
|
3 | 0 | |||||||||||
|
MEINS
Base Unit of Measure
|
MEINS |
UNIT
|
3 | 0 | ||||||||||||
|
GESME
Total Quantity
|
LQUA_GESME |
QUAN
|
13 | 3 | ||||||||||||
|
VERME
Available stock
|
LQUA_VERME |
QUAN
|
13 | 3 | ||||||||||||
|
EINME
Stock for putaway
|
LQUA_EINME |
QUAN
|
13 | 3 | ||||||||||||
|
AUSME
Quantity to remove
|
LQUA_AUSME |
QUAN
|
13 | 3 | ||||||||||||
|
MGEWI
Weight of material
|
LQUA_MGEWI |
DEC
|
11 | 3 | ||||||||||||
|
GEWEI
Weight Unit
|
GEWEI |
UNIT
|
3 | 0 | ||||||||||||
|
TBNUM
Transfer Requirement Number
|
TBNUM |
NUMC
|
10 | 0 | ||||||||||||
|
IVNUM
Number of system inventory record
|
LVS_IVNUM |
CHAR
|
10 | 0 | ||||||||||||
|
IVPOS
Item number in inventory document
|
LVS_IVPOS |
NUMC
|
4 | 0 | ||||||||||||
|
BETYP
Requirement Type
|
LVS_BETYP |
CHAR
|
1 | 0 | ||||||||||||
|
BENUM
Requirement Number
|
LVS_BENUM |
CHAR
|
10 | 0 | ||||||||||||
|
LENUM
Storage Unit Number
|
LENUM | LEIN |
CHAR
|
20 | 0 | |||||||||||
|
QPLOS
Inspection Lot Number
|
QPLOS |
NUMC
|
12 | 0 | ||||||||||||
|
VFDAT
Shelf Life Expiration or Best-Before Date
|
VFDAT |
DATS
|
8 | 0 | ||||||||||||
|
QKAPV
Capacity usage of quant
|
LQUA_QKAPV |
DEC
|
11 | 3 | ||||||||||||
|
KOBER
Picking Area
|
KOBER |
CHAR
|
3 | 0 | ||||||||||||
|
LGORT
Storage Location
|
LGORT_D | T001L |
CHAR
|
4 | 0 | |||||||||||
|
VIRGO
Quant does not contain GR data
|
LQUA_VIRGO |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
TRAME
Open Transfer Quantity
|
LQUA_TRAME |
QUAN
|
13 | 3 | ||||||||||||
|
KZHUQ
Indicator: Quant is on a handling unit
|
LQUA_KZHUQ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
VBELN
Delivery
|
VBELN_VL |
CHAR
|
10 | 0 | ||||||||||||
|
POSNR
Delivery Item
|
POSNR_VL |
NUMC
|
6 | 0 | ||||||||||||
|
IDATU
Date of last inventory of quant
|
LQUA_IDATU |
DATS
|
8 | 0 | ||||||||||||
|
MSR_INSP_GUID
Inspection GUID
|
MSR_INSP_GUID |
RAW
|
16 | 0 | ||||||||||||
LQUA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| LQUA | LENUM | LQUA | MANDT |
LEIN
Storage unit header records
|
MANDT |
| LQUA | LENUM | LQUA | LENUM |
LEIN
Storage unit header records
|
LENUM |
| LQUA | LETYP | LQUA | LETYP |
T307
Storage Unit Types
|
LETYP |
| LQUA | LETYP | LQUA | MANDT |
T307
Storage Unit Types
|
MANDT |
| LQUA | LETYP | LQUA | LGNUM |
T307
Storage Unit Types
|
LGNUM |
| LQUA | LGNUM | LQUA | LGNUM |
T300
WM Warehouse Numbers
|
LGNUM |
| LQUA | LGNUM | LQUA | MANDT |
T300
WM Warehouse Numbers
|
MANDT |
| LQUA | LGORT | LQUA | MANDT |
T001L
Storage Locations
|
MANDT |
| LQUA | LGORT | LQUA | WERKS |
T001L
Storage Locations
|
WERKS |
| LQUA | LGORT | LQUA | LGORT |
T001L
Storage Locations
|
LGORT |
| LQUA | LGPLA | LQUA | MANDT |
LAGP
Storage bins
|
MANDT |
| LQUA | LGPLA | LQUA | LGNUM |
LAGP
Storage bins
|
LGNUM |
| LQUA | LGPLA | LQUA | LGTYP |
LAGP
Storage bins
|
LGTYP |
| LQUA | LGPLA | LQUA | LGPLA |
LAGP
Storage bins
|
LGPLA |
| LQUA | LGTYP | LQUA | MANDT |
T301
WM Storage Types
|
MANDT |
| LQUA | LGTYP | LQUA | LGNUM |
T301
WM Storage Types
|
LGNUM |
| LQUA | LGTYP | LQUA | LGTYP |
T301
WM Storage Types
|
LGTYP |
| LQUA | MATNR | LQUA | MANDT |
MARA
General Material Data
|
MANDT |
| LQUA | MATNR | LQUA | MATNR |
MARA
General Material Data
|
MATNR |
| LQUA | SOBKZ | LQUA | MANDT |
T148
Special Stock Indicator
|
MANDT |
| LQUA | SOBKZ | LQUA | SOBKZ |
T148
Special Stock Indicator
|
SOBKZ |
| LQUA | SPGRU | LQUA | MANDT |
T330
Blocking Reasons
|
MANDT |
| LQUA | SPGRU | LQUA | LGNUM |
T330
Blocking Reasons
|
LGNUM |
| LQUA | SPGRU | LQUA | SPGRU |
T330
Blocking Reasons
|
SPGRU |
| LQUA | WERKS | LQUA | MANDT |
T001W
Plants/Branches
|
MANDT |
| LQUA | WERKS | LQUA | WERKS |
T001W
Plants/Branches
|
WERKS |