SAP table T343 (Storage Bin Structure for Automatic Creation of Storage Bins)
SAP table T343 has 4 primary key fields being MANDT,LGNUM,LGTYP,LFDNR.
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 | * | LGNUM | |
| LGTYP | Storage Type | CHAR | 3 | 0 | T301 | LGTYP | |
| LFDNR | Sequence number | CHAR | 3 | 0 | LVS_LFDNR | ||
| LPTYP | Storage bin type | CHAR | 2 | 0 | T303 | LVS_LPTYP | |
| SCHAB | Format of bin coordinate for automatic creation | CHAR | 10 | 0 | * | T343_SCHAB | |
| STRUK | Structure of storage bins for automatic creation | CHAR | 10 | 0 | * | T343_STRUK | |
| STAWE | Start value of storage bins for automatic creation | CHAR | 10 | 0 | * | T343_STAWE | |
| ENDWE | End value of storage bins for automatic creation | CHAR | 10 | 0 | * | T343_ENDWE | |
| INCRE | Increment for bins for automatic creation | CHAR | 10 | 0 | * | T343_INCRE | |
| LGBER | Storage Section | CHAR | 3 | 0 | T302 | LGBER | |
| LGEWI | Load Capacity of Storage Bin | DEC | 11 | 3 | LAGP_LGEWI | ||
| GEWEI | Weight Unit | UNIT | 3 | 0 | * | GEWEI | |
| BRAND | Fire-containment section | CHAR | 2 | 0 | T309 | LVS_BRAND | |
| LKAPV | Total capacity of storage bin | DEC | 11 | 3 | LAGP_LKAPV | ||
| KOBER | Picking Area | CHAR | 3 | 0 | T30A | KOBER |
T343 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T343 | BRAND | T309 | Fire-Containment Sections | MANDT |
| 0 T343 | BRAND | T309 | Fire-Containment Sections | LGNUM |
| 1 T343 | KOBER | T30A | WM Picking Areas | MANDT |
| 1 T343 | KOBER | T30A | WM Picking Areas | LGNUM |
| 0 T343 | LGBER | T302 | WM Storage Sections | MANDT |
| 0 T343 | LGBER | T302 | WM Storage Sections | LGNUM |
| 1 T343 | LGTYP | T301 | WM Storage Types | MANDT |
| 1 T343 | LGTYP | T301 | WM Storage Types | LGNUM |
| 1 T343 | LGTYP | T301 | WM Storage Types | LGTYP |
| 0 T343 | LPTYP | T303 | WM Storage Bin Types | MANDT |
| 0 T343 | LPTYP | T303 | WM Storage Bin Types | LGNUM |