SAP table LQUA (Quants)

SAP table LQUA has 3 primary key fields being MANDT,LGNUM,LQNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
LQNUM Quant NUMC 10 0 LVS_LQNUM
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
CHARG Batch Number CHAR 10 0 CHARG_D
BESTQ Stock Category in the Warehouse Management System CHAR 1 0 BESTQ
Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
SONUM Special Stock Number CHAR 16 0 LVS_SONUM
LGTYP Storage Type CHAR 3 0 T301 LGTYP
LGPLA Storage Bin CHAR 10 0 LAGP LGPLA
PLPOS Position in storage bin CHAR 2 0 LVS_PLPOS
SKZUE Blocking indicator: for putaways (user) CHAR 1 0 LQUA_SKZUE
SKZUA Blocking Indicator: For Stock Removals (User) CHAR 1 0 LQUA_SKZUA
SKZSE Blocking indicator: current placement into stock (system) CHAR 1 0 LQUA_SKZSE
SKZSA Blocking Indicator: Current Stock Removal (System) CHAR 1 0 LQUA_SKZSA
SKZSI Blocking Indicator: Current Inventory (System) CHAR 1 0 LQUA_SKZSI
SPGRU Blocking reason CHAR 1 0 T330 LVS_SPGRU
ZEUGN Certificate Number CHAR 10 0 LVS_ZEUGN
BDATU Date of last movement DATS 8 0 LQUA_BDATU
BZEIT Time of last movement TIMS 6 0 LQUA_BZEIT
BTANR Document Number of Last Stock Change in Quant NUMC 10 0 LQUA_BTANR
BTAPS Item in transfer order of last stock transfer NUMC 4 0 LQUA_BTAPS
EDATU Date of last placement into stock DATS 8 0 LQUA_EDATU
EZEIT Time of last placement into stock TIMS 6 0 LQUA_EZEIT
ADATU Date of last stock removal DATS 8 0 LQUA_ADATU
AZEIT Time of last stock removal TIMS 6 0 LQUA_AZEIT
ZDATU Date of last addition to existing stock DATS 8 0 LQUA_ZDATU
WDATU Date of Goods Receipt DATS 8 0 LVS_WDATU
WENUM Goods Receipt Number CHAR 10 0 LVS_WENUM
WEPOS Goods receipt item NUMC 4 0 LVS_WEPOS
LETYP Storage Unit Type CHAR 3 0 T307 LVS_LETYP
MEINS Base Unit of Measure UNIT 3 0 MEINS
GESME Total Quantity QUAN 13 3 LQUA_GESME
VERME Available stock QUAN 13 3 LQUA_VERME
EINME Stock for putaway QUAN 13 3 LQUA_EINME
AUSME Quantity to remove QUAN 13 3 LQUA_AUSME
MGEWI Weight of material DEC 11 3 LQUA_MGEWI
GEWEI Weight Unit UNIT 3 0 GEWEI
TBNUM Transfer Requirement Number NUMC 10 0 TBNUM
IVNUM Number of system inventory record CHAR 10 0 LVS_IVNUM
IVPOS Item number in inventory document NUMC 4 0 LVS_IVPOS
BETYP Requirement Type CHAR 1 0 LVS_BETYP
BENUM Requirement Number CHAR 10 0 LVS_BENUM
LENUM Storage Unit Number CHAR 20 0 LEIN LENUM
QPLOS Inspection Lot Number NUMC 12 0 QPLOS
VFDAT Shelf Life Expiration or Best-Before Date DATS 8 0 VFDAT
QKAPV Capacity usage of quant DEC 11 3 LQUA_QKAPV
KOBER Picking Area CHAR 3 0 KOBER
LGORT Storage location CHAR 4 0 T001L LGORT_D
VIRGO Quant does not contain GR data CHAR 1 0 LQUA_VIRGO
TRAME Open Transfer Quantity QUAN 13 3 LQUA_TRAME
KZHUQ Indicator: Quant is on a handling unit CHAR 1 0 LQUA_KZHUQ
VBELN Delivery CHAR 10 0 VBELN_VL
POSNR Delivery Item NUMC 6 0 POSNR_VL
IDATU Date of last inventory of quant DATS 8 0 LQUA_IDATU
MSR_INSP_GUID Inspection GUID RAW 16 0 MSR_INSP_GUID
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT

LQUA foreign key relationships

Table Field Check Table Check Field
0 LQUA LENUM LEIN Storage unit header records MANDT
0 LQUA LENUM LEIN Storage unit header records LENUM
1 LQUA LETYP T307 Storage Unit Types MANDT
1 LQUA LETYP T307 Storage Unit Types LGNUM
0 LQUA LGNUM T300 WM Warehouse Numbers MANDT
0 LQUA LGNUM T300 WM Warehouse Numbers LGNUM
1 LQUA LGORT T001L Storage Locations MANDT
1 LQUA LGORT T001L Storage Locations WERKS
0 LQUA LGPLA LAGP Storage bins MANDT
0 LQUA LGPLA LAGP Storage bins LGNUM
0 LQUA LGPLA LAGP Storage bins LGPLA
1 LQUA LGTYP T301 WM Storage Types MANDT
1 LQUA LGTYP T301 WM Storage Types LGNUM
1 LQUA LGTYP T301 WM Storage Types LGTYP
0 LQUA MATNR MARA General Material Data MANDT
0 LQUA MATNR MARA General Material Data MATNR
1 LQUA SOBKZ T148 Special Stock Indicator MANDT
1 LQUA SOBKZ T148 Special Stock Indicator SOBKZ
0 LQUA SPGRU T330 Blocking Reasons MANDT
0 LQUA SPGRU T330 Blocking Reasons LGNUM
0 LQUA SPGRU T330 Blocking Reasons SPGRU
1 LQUA WERKS T001W Plants/Branches MANDT
1 LQUA WERKS T001W Plants/Branches WERKS