SAP Table LAGP
Storage bins
LAGP (Storage bins) 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 LAGP to other SAP tables.
LAGP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
SKZUE
Blocking indicator: for putaways (user)
|
LAGP_SKZUE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
SKZSA
Blocking Indicator: Current Stock Removal (System)
|
LAGP_SKZSA |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
SKZSE
Blocking indicator: current stock placement (system)
|
LAGP_SKZSE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
SKZSI
Blocking indicator: current inventory (system)
|
LAGP_SKZSI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
KZLER
Indicator whether storage bin is empty
|
LAGP_KZLER |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
KZVOL
Indicator whether storage bin is full
|
LAGP_KZVOL |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
LAGP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| LAGP | BRAND | LAGP | BRAND |
T309
Fire-Containment Sections
|
BRAND |
| LAGP | BRAND | LAGP | MANDT |
T309
Fire-Containment Sections
|
MANDT |
| LAGP | BRAND | LAGP | LGNUM |
T309
Fire-Containment Sections
|
LGNUM |
| LAGP | GEWEI | LAGP | MANDT |
T006
Units of Measurement
|
MANDT |
| LAGP | GEWEI | LAGP | GEWEI |
T006
Units of Measurement
|
MSEHI |
| LAGP | KOBER | LAGP | MANDT |
T30A
WM Picking Areas
|
MANDT |
| LAGP | KOBER | LAGP | LGNUM |
T30A
WM Picking Areas
|
LGNUM |
| LAGP | KOBER | LAGP | LGTYP |
T30A
WM Picking Areas
|
LGTYP |
| LAGP | KOBER | LAGP | KOBER |
T30A
WM Picking Areas
|
KOBER |
| LAGP | LGBER | LAGP | MANDT |
T302
WM Storage Sections
|
MANDT |
| LAGP | LGBER | LAGP | LGNUM |
T302
WM Storage Sections
|
LGNUM |
| LAGP | LGBER | LAGP | LGTYP |
T302
WM Storage Sections
|
LGTYP |
| LAGP | LGBER | LAGP | LGBER |
T302
WM Storage Sections
|
LGBER |
| LAGP | LGNUM | LAGP | MANDT |
T300
WM Warehouse Numbers
|
MANDT |
| LAGP | LGNUM | LAGP | LGNUM |
T300
WM Warehouse Numbers
|
LGNUM |
| LAGP | LGTYP | LAGP | LGTYP |
T301
WM Storage Types
|
LGTYP |
| LAGP | LGTYP | LAGP | MANDT |
T301
WM Storage Types
|
MANDT |
| LAGP | LGTYP | LAGP | LGNUM |
T301
WM Storage Types
|
LGNUM |
| LAGP | LPTYP | LAGP | MANDT |
T303
WM Storage Bin Types
|
MANDT |
| LAGP | LPTYP | LAGP | LGNUM |
T303
WM Storage Bin Types
|
LGNUM |
| LAGP | LPTYP | LAGP | LPTYP |
T303
WM Storage Bin Types
|
LPTYP |
| LAGP | SPGRU | LAGP | LGNUM |
T330
Blocking Reasons
|
LGNUM |
| LAGP | SPGRU | LAGP | SPGRU |
T330
Blocking Reasons
|
SPGRU |
| LAGP | SPGRU | LAGP | MANDT |
T330
Blocking Reasons
|
MANDT |