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 | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Possible values
|
||||||||||||||||||
SKZUE | Blocking indicator: for putaways (user) | LAGP_SKZUE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
SKZSA | Blocking Indicator: Current Stock Removal (System) | LAGP_SKZSA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
SKZSE | Blocking indicator: current stock placement (system) | LAGP_SKZSE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
SKZSI | Blocking indicator: current inventory (system) | LAGP_SKZSI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
KZLER | Indicator whether storage bin is empty | LAGP_KZLER | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
KZVOL | Indicator whether storage bin is full | LAGP_KZVOL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
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 | MANDT | T309 | Fire-Containment Sections | MANDT |
LAGP | BRAND | LAGP | LGNUM | T309 | Fire-Containment Sections | LGNUM |
LAGP | BRAND | LAGP | BRAND | T309 | Fire-Containment Sections | BRAND |
LAGP | GEWEI | LAGP | MANDT | T006 | Units of Measurement | MANDT |
LAGP | GEWEI | LAGP | GEWEI | T006 | Units of Measurement | MSEHI |
LAGP | KOBER | LAGP | LGTYP | T30A | WM Picking Areas | LGTYP |
LAGP | KOBER | LAGP | KOBER | T30A | WM Picking Areas | KOBER |
LAGP | KOBER | LAGP | MANDT | T30A | WM Picking Areas | MANDT |
LAGP | KOBER | LAGP | LGNUM | T30A | WM Picking Areas | LGNUM |
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 | LGBER | LAGP | MANDT | T302 | WM Storage Sections | MANDT |
LAGP | LGNUM | LAGP | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
LAGP | LGNUM | LAGP | MANDT | T300 | WM Warehouse Numbers | MANDT |
LAGP | LGTYP | LAGP | MANDT | T301 | WM Storage Types | MANDT |
LAGP | LGTYP | LAGP | LGNUM | T301 | WM Storage Types | LGNUM |
LAGP | LGTYP | LAGP | LGTYP | T301 | WM Storage Types | LGTYP |
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 | MANDT | T330 | Blocking Reasons | MANDT |
LAGP | SPGRU | LAGP | LGNUM | T330 | Blocking Reasons | LGNUM |
LAGP | SPGRU | LAGP | SPGRU | T330 | Blocking Reasons | SPGRU |