SAP Table
LAGP Storage bins
SAP table LAGP has 4 primary key fields being MANDT,LGNUM,LGTYP,LGPLA.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
LAGP columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | * | MANDT | |||||||||||||||||
| KeyLGNUM | Warehouse Number / Warehouse Complex | CHAR | 3 | 0 | T300 | LGNUM | |||||||||||||||||
| KeyLGTYP | Storage Type | CHAR | 3 | 0 | T301 | LGTYP | |||||||||||||||||
| KeyLGPLA | 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 | ||||||||||||||||||
|
|||||||||||||||||||||||
| 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 | ||||||||||||||||||
/ Relationships
LAGP foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| LAGP | BRAND | T309 | Fire-Containment Sections | MANDT |
| LAGP | BRAND | T309 | Fire-Containment Sections | LGNUM |
| LAGP | GEWEI | T006 | Units of Measurement | MANDT |
| LAGP | GEWEI | T006 | Units of Measurement | MSEHI |
| LAGP | KOBER | T30A | WM Picking Areas | MANDT |
| LAGP | KOBER | T30A | WM Picking Areas | LGNUM |
| LAGP | LGBER | T302 | WM Storage Sections | MANDT |
| LAGP | LGBER | T302 | WM Storage Sections | LGNUM |
| LAGP | LGNUM | T300 | WM Warehouse Numbers | MANDT |
| LAGP | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| LAGP | LGTYP | T301 | WM Storage Types | MANDT |
| LAGP | LGTYP | T301 | WM Storage Types | LGNUM |
| LAGP | LGTYP | T301 | WM Storage Types | LGTYP |
| LAGP | LPTYP | T303 | WM Storage Bin Types | MANDT |
| LAGP | LPTYP | T303 | WM Storage Bin Types | LGNUM |
| LAGP | SPGRU | T330 | Blocking Reasons | MANDT |
| LAGP | SPGRU | T330 | Blocking Reasons | LGNUM |
| LAGP | SPGRU | T330 | Blocking Reasons | SPGRU |