1. Home
  2. Resources
  3. SAP Tables
  4. RL070 - All LQUA and LINV Fields

SAP Table RL070

All LQUA and LINV Fields

RL070 (All LQUA and LINV Fields) 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 RL070 to other SAP tables.

RL070 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
NANUM Inventory recount number LINV_NANUM NUMC 2 0
ISTAT Item status of inventory at quant level LINV_ISTAT CHAR 1 0
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
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
ALTME Alternative Unit of Measure for Stockkeeping Unit LRMEI UNIT 3 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
MENGA Counted quantity in alternative unit of measure LINV_MENGA QUAN 13 3
LINV_IDATU Date of inventory LVS_IDATU DATS 8 0
KZINV Inventory method LVS_KZINV CHAR 2 0
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
UNAME Name of counter for system inventory record LINV_UNAME CHAR 25 0
ICON Status ICON_RLINV070 CHAR 132 0
QUINV Indicator for quant inventory LINK_QUINV CHAR 1 0
X Yes
NULL No
LSONR Special Stock Number LVS_LSONR CHAR 24 0
LINV_GESME Total Quantity LQUA_GESME QUAN 13 3

RL070 foreign key relationships

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