SAP table T312B (Profile for Transfer Order Split)
SAP table T312B has 3 primary key fields being MANDT,LGNUM,PRSPL.
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 | T000 | MANDT | |
| LGNUM | Warehouse Number / Warehouse Complex | CHAR | 3 | 0 | T300 | LGNUM | |
| PRSPL | Profile for transfer order split | CHAR | 6 | 0 | T312_PRSPL | ||
| SPLKB | Split by picking area | CHAR | 1 | 0 | LVS_SPLKB | ||
| GWSOZ | Limiting value based on planned TO processing time | QUAN | 13 | 3 | LVS_GWSOZ | ||
| GWGEW | Limiting value based on weight | DEC | 11 | 3 | LVS_GWGEW | ||
| GWVOL | Limiting value based on volume | QUAN | 13 | 3 | LVS_GWVOL | ||
| SOKNZ | Sort profile for transfer order | NUMC | 2 | 0 | T312S | LVS_SOPRF | |
| ZEIEI | Time unit for target time | UNIT | 3 | 0 | T006 | T312B_ZEIEI |
T312B foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T312B | LGNUM | T300 | WM Warehouse Numbers | MANDT |
| 0 T312B | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| 1 T312B | MANDT | T000 | Clients | MANDT |
| 0 T312B | SOKNZ | T312S | Profile for Sorting | MANDT |
| 0 T312B | SOKNZ | T312S | Profile for Sorting | LGNUM |
| 1 T312B | ZEIEI | T006 | Units of Measurement | MANDT |
| 1 T312B | ZEIEI | T006 | Units of Measurement | MSEHI |