SAP table LAGP (Storage bins)

SAP table LAGP has 4 primary key fields being MANDT,LGNUM,LGTYP,LGPLA.

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
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

LAGP foreign key relationships

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