SAP Table RL030

Join LAGP and LQUA (RLS10030 and RLS10034)

RL030 (Join LAGP and LQUA (RLS10030 and RLS10034)) 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 RL030 to other SAP tables.

RL030 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
LGTYP Storage Type LGTYP T301 CHAR 3 0
LGPLA Storage Bin LGPLA CHAR 10 0
LGBER Storage Section LGBER T302 CHAR 3 0
LPTYP Storage bin type LVS_LPTYP T303 CHAR 2 0
PLAUF Section of a storage bin LVS_PLAUF CHAR 1 0
SKZUA Blocking Indicator: For Stock Removals (User) LAGP_SKZUA CHAR 1 0
X Yes
NULL No
SKZUE Blocking indicator: for putaways (user) LAGP_SKZUE CHAR 1 0
X Yes
NULL No
SKZSA Blocking Indicator: Current Stock Removal (System) LAGP_SKZSA CHAR 1 0
X Yes
NULL No
SKZSE Blocking indicator: current stock placement (system) LAGP_SKZSE CHAR 1 0
X Yes
NULL No
SKZSI Blocking indicator: current inventory (system) LAGP_SKZSI CHAR 1 0
X Yes
NULL No
SPGRU Blocking reason LVS_SPGRU T330 CHAR 1 0
ANZQU Number of quants in storage bin LAGP_ANZQU DEC 7 0
MAXQU Maximum number of quants in storage bin LAGP_MAXQU DEC 7 0
ANZLE Number of storage units in storage bin LAGP_ANZLE DEC 9 3
MAXLE Maximum number of storage units in storage bin LAGP_MAXLE DEC 5 0
KZDYN Indicator: dynamic storage bin LVS_KZDYN CHAR 1 0
X Yes
NULL No
LGEWI Load Capacity of Storage Bin LAGP_LGEWI DEC 11 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
MGEWI Weight of materials in storage bin LAGP_MGEWI DEC 11 3
BDATU Date of last movement LAGP_BDATU DATS 8 0
BZEIT Time of last movement LAGP_BZEIT TIMS 6 0
BTANR Transfer order number of last stock transfer LAGP_BTANR NUMC 10 0
BTAPS Item in transfer order of last stock transfer LAGP_BTAPS NUMC 4 0
RDATU Date of last bin clearing LAGP_RDATU DATS 8 0
RZEIT Time of last clearing LAGP_RZEIT TIMS 6 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
IDATU Date of last inventory for this storage bin LAGP_IDATU DATS 8 0
IVNUM Number of system inventory record LVS_IVNUM CHAR 10 0
IVPOS Item number in inventory document LVS_IVPOS NUMC 4 0
IVIVO Inventory in preparation LVS_IVIVO CHAR 1 0
X Yes
NULL No
KZLER Indicator whether storage bin is empty LAGP_KZLER CHAR 1 0
X Yes
NULL No
KZVOL Indicator whether storage bin is full LAGP_KZVOL CHAR 1 0
X Yes
NULL No
SORLP Sort field for storage bin (cross-line storage) LAGP_SORLP CHAR 6 0
BRAND Fire-containment section LVS_BRAND T309 CHAR 2 0
UNAME Last changed by LAGP_UNAME CHAR 12 0
LAEDT Date of last change LAGP_LAEDT DATS 8 0
LKAPV Total capacity of storage bin LAGP_LKAPV DEC 11 3
RKAPV Available capacity in storage bin LAGP_RKAPV DEC 11 3
KOBER Picking Area KOBER T30A CHAR 3 0
REIHF Sort field for storage bin (TO items, picking) LAGP_REIHF CHAR 6 0
VERIF Verification Field for Mobile Data Entry LAGP_VERIF CHAR 10 0
LZONE Zone LAGP_LZONE CHAR 10 0
XCORD X Coordinate LAGP_XCORD QUAN 10 3
YCORD Y Coordinate LAGP_YCORD QUAN 10 3
ZCORD Z Coordinate LAGP_ZCORD QUAN 10 3
LQUA_MANDT Client MANDT CLNT 3 0
LQUA_LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
LQNUM Quant LVS_LQNUM NUMC 10 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D 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 CHAR 1 0
SONUM Special Stock Number LVS_SONUM CHAR 16 0
LQUA_LGTYP Storage Type LGTYP CHAR 3 0
LQUA_LGPLA Storage Bin LGPLA CHAR 10 0
PLPOS Position in storage bin LVS_PLPOS CHAR 2 0
LQUA_SKZUE Blocking indicator: for putaways (user) LQUA_SKZUE CHAR 1 0
X Yes
NULL No
LQUA_SKZUA Blocking Indicator: For Stock Removals (User) LQUA_SKZUA CHAR 1 0
X Yes
NULL No
LQUA_SKZSE Blocking indicator: current placement into stock (system) LQUA_SKZSE CHAR 1 0
X Yes
NULL No
LQUA_SKZSA Blocking Indicator: Current Stock Removal (System) LQUA_SKZSA CHAR 1 0
X Yes
NULL No
LQUA_SKZSI Blocking Indicator: Current Inventory (System) LQUA_SKZSI CHAR 1 0
X Yes
NULL No
LQUA_SPGRU Blocking reason LVS_SPGRU CHAR 1 0
ZEUGN Certificate Number LVS_ZEUGN CHAR 10 0
LQUA_BDATU Date of last movement LQUA_BDATU DATS 8 0
LQUA_BZEIT Time of last movement LQUA_BZEIT TIMS 6 0
LQUA_BTANR Document Number of Last Stock Change in Quant LQUA_BTANR NUMC 10 0
LQUA_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 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
LQUA_MGEWI Weight of material LQUA_MGEWI DEC 11 3
LQUA_GEWEI Weight Unit GEWEI UNIT 3 0
TBNUM Transfer Requirement Number TBNUM NUMC 10 0
LQUA_IVNUM Number of system inventory record LVS_IVNUM CHAR 10 0
LQUA_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 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
LQUA_KOBER Picking Area KOBER CHAR 3 0
LGORT Storage Location LGORT_D CHAR 4 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
LQUA_IDATU Date of last inventory of quant LQUA_IDATU DATS 8 0

RL030 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RL030 BRAND RL030 MANDT T309 Fire-Containment Sections MANDT
RL030 BRAND RL030 LGNUM T309 Fire-Containment Sections LGNUM
RL030 BRAND RL030 BRAND T309 Fire-Containment Sections BRAND
RL030 GEWEI RL030 MANDT T006 Units of Measurement MANDT
RL030 GEWEI RL030 GEWEI T006 Units of Measurement MSEHI
RL030 KOBER RL030 LGNUM T30A WM Picking Areas LGNUM
RL030 KOBER RL030 LGTYP T30A WM Picking Areas LGTYP
RL030 KOBER RL030 KOBER T30A WM Picking Areas KOBER
RL030 KOBER RL030 MANDT T30A WM Picking Areas MANDT
RL030 LGBER RL030 MANDT T302 WM Storage Sections MANDT
RL030 LGBER RL030 LGNUM T302 WM Storage Sections LGNUM
RL030 LGBER RL030 LGTYP T302 WM Storage Sections LGTYP
RL030 LGBER RL030 LGBER T302 WM Storage Sections LGBER
RL030 LGNUM RL030 MANDT T300 WM Warehouse Numbers MANDT
RL030 LGNUM RL030 LGNUM T300 WM Warehouse Numbers LGNUM
RL030 LGTYP RL030 MANDT T301 WM Storage Types MANDT
RL030 LGTYP RL030 LGNUM T301 WM Storage Types LGNUM
RL030 LGTYP RL030 LGTYP T301 WM Storage Types LGTYP
RL030 LPTYP RL030 LGNUM T303 WM Storage Bin Types LGNUM
RL030 LPTYP RL030 LPTYP T303 WM Storage Bin Types LPTYP
RL030 LPTYP RL030 MANDT T303 WM Storage Bin Types MANDT
RL030 SPGRU RL030 SPGRU T330 Blocking Reasons SPGRU
RL030 SPGRU RL030 MANDT T330 Blocking Reasons MANDT
RL030 SPGRU RL030 LGNUM T330 Blocking Reasons LGNUM