SAP table LAGPL (Generated Table for View)
SAP table LAGPL 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 | ||
| SKZUE | Blocking indicator: for putaways (user) | CHAR | 1 | 0 | LAGP_SKZUE | ||
| SKZSI | Blocking indicator: current inventory (system) | CHAR | 1 | 0 | LAGP_SKZSI | ||
| 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 | ||
| RKAPV | Available capacity in storage bin | DEC | 11 | 3 | LAGP_RKAPV |
LAGPL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 LAGPL | LGBER | T302 | WM Storage Sections | MANDT |
| 0 LAGPL | LGBER | T302 | WM Storage Sections | LGNUM |
| 1 LAGPL | LGNUM | T300 | WM Warehouse Numbers | MANDT |
| 1 LAGPL | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| 0 LAGPL | LGTYP | T301 | WM Storage Types | MANDT |
| 0 LAGPL | LGTYP | T301 | WM Storage Types | LGNUM |
| 0 LAGPL | LGTYP | T301 | WM Storage Types | LGTYP |
| 1 LAGPL | LPTYP | T303 | WM Storage Bin Types | MANDT |
| 1 LAGPL | LPTYP | T303 | WM Storage Bin Types | LGNUM |