1. Home
  2. Resources
  3. SAP Tables
  4. LQUA - Quants

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
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
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
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
X Yes
NULL No
SKZUA Blocking Indicator: For Stock Removals (User) LQUA_SKZUA CHAR 1 0
X Yes
NULL No
SKZSE Blocking indicator: current placement into stock (system) LQUA_SKZSE CHAR 1 0
X Yes
NULL No
SKZSA Blocking Indicator: Current Stock Removal (System) LQUA_SKZSA CHAR 1 0
X Yes
NULL No
SKZSI Blocking Indicator: Current Inventory (System) LQUA_SKZSI CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
TRAME Open Transfer Quantity LQUA_TRAME QUAN 13 3
KZHUQ Indicator: Quant is on a handling unit LQUA_KZHUQ CHAR 1 0
X Yes
NULL No
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 MANDT T307 Storage Unit Types MANDT
LQUA LETYP LQUA LGNUM T307 Storage Unit Types LGNUM
LQUA LETYP LQUA LETYP T307 Storage Unit Types LETYP
LQUA LGNUM LQUA MANDT T300 WM Warehouse Numbers MANDT
LQUA LGNUM LQUA LGNUM T300 WM Warehouse Numbers LGNUM
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 LGPLA LAGP Storage bins LGPLA
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 LGTYP LQUA LGTYP T301 WM Storage Types LGTYP
LQUA LGTYP LQUA MANDT T301 WM Storage Types MANDT
LQUA LGTYP LQUA LGNUM T301 WM Storage Types LGNUM
LQUA MATNR LQUA MANDT MARA General Material Data MANDT
LQUA MATNR LQUA MATNR MARA General Material Data MATNR
LQUA SOBKZ LQUA SOBKZ T148 Special Stock Indicator SOBKZ
LQUA SOBKZ LQUA MANDT T148 Special Stock Indicator MANDT
LQUA SPGRU LQUA LGNUM T330 Blocking Reasons LGNUM
LQUA SPGRU LQUA SPGRU T330 Blocking Reasons SPGRU
LQUA SPGRU LQUA MANDT T330 Blocking Reasons MANDT
LQUA WERKS LQUA MANDT T001W Plants/Branches MANDT
LQUA WERKS LQUA WERKS T001W Plants/Branches WERKS