SAP table RL030 (Join LAGP and LQUA (RLS10030 and RLS10034))

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

RL030 foreign key relationships

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