SAP Table
T312S Profile for Sorting
SAP table T312S has 4 primary key fields being MANDT,SORPO,LGNUM,SOKNZ.
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
T312S columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeySORPO | Sorting pool | CHAR | 30 | 0 | DD02L | T312SSORPO | |
| KeyLGNUM | Warehouse Number / Warehouse Complex | CHAR | 3 | 0 | T300 | LGNUM | |
| KeySOKNZ | Sort profile for transfer order | NUMC | 2 | 0 | LVS_SOPRF | ||
| SRT00 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT01 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT02 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT03 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT04 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT05 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT06 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT07 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT08 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT09 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT10 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT11 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT12 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT13 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| SRT14 | Sort field | CHAR | 30 | 0 | DD03L | LVS_SRTFD | |
| GRW00 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW01 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW02 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW03 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW04 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW05 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW06 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW07 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW08 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW09 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW10 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW11 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW12 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW13 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| GRW14 | Group change when printing combined list | CHAR | 1 | 0 | T312SGRUWE | ||
| SRI00 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI01 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI02 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI03 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI04 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI05 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI06 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI07 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI08 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI09 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI10 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI11 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI12 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI13 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SRI14 | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI | ||
| SORRI | Sort direction for sorting in WM | CHAR | 1 | 0 | T312SSORRI |
/ Relationships
T312S foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T312S | LGNUM | T300 | WM Warehouse Numbers | MANDT |
| T312S | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| T312S | MANDT | T000 | Clients | MANDT |
| T312S | SORPO | DD02L | SAP Tables | TABNAME |
| T312S | SORPO | DD02L | SAP Tables | AS4LOCAL |
| T312S | SORPO | DD02L | SAP Tables | AS4VERS |
| T312S | SRT00 | DD03L | Table Fields | TABNAME |
| T312S | SRT00 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT00 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT00 | DD03L | Table Fields | AS4VERS |
| T312S | SRT01 | DD03L | Table Fields | TABNAME |
| T312S | SRT01 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT01 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT01 | DD03L | Table Fields | AS4VERS |
| T312S | SRT02 | DD03L | Table Fields | TABNAME |
| T312S | SRT02 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT02 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT02 | DD03L | Table Fields | AS4VERS |
| T312S | SRT03 | DD03L | Table Fields | TABNAME |
| T312S | SRT03 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT03 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT03 | DD03L | Table Fields | AS4VERS |
| T312S | SRT04 | DD03L | Table Fields | TABNAME |
| T312S | SRT04 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT04 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT04 | DD03L | Table Fields | AS4VERS |
| T312S | SRT05 | DD03L | Table Fields | TABNAME |
| T312S | SRT05 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT05 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT05 | DD03L | Table Fields | AS4VERS |
| T312S | SRT06 | DD03L | Table Fields | TABNAME |
| T312S | SRT06 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT06 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT06 | DD03L | Table Fields | AS4VERS |
| T312S | SRT07 | DD03L | Table Fields | TABNAME |
| T312S | SRT07 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT07 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT07 | DD03L | Table Fields | AS4VERS |
| T312S | SRT08 | DD03L | Table Fields | TABNAME |
| T312S | SRT08 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT08 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT08 | DD03L | Table Fields | AS4VERS |
| T312S | SRT09 | DD03L | Table Fields | TABNAME |
| T312S | SRT09 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT09 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT09 | DD03L | Table Fields | AS4VERS |
| T312S | SRT10 | DD03L | Table Fields | TABNAME |
| T312S | SRT10 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT10 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT10 | DD03L | Table Fields | AS4VERS |
| T312S | SRT11 | DD03L | Table Fields | TABNAME |
| T312S | SRT11 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT11 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT11 | DD03L | Table Fields | AS4VERS |
| T312S | SRT12 | DD03L | Table Fields | TABNAME |
| T312S | SRT12 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT12 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT12 | DD03L | Table Fields | AS4VERS |
| T312S | SRT13 | DD03L | Table Fields | TABNAME |
| T312S | SRT13 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT13 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT13 | DD03L | Table Fields | AS4VERS |
| T312S | SRT14 | DD03L | Table Fields | TABNAME |
| T312S | SRT14 | DD03L | Table Fields | FIELDNAME |
| T312S | SRT14 | DD03L | Table Fields | AS4LOCAL |
| T312S | SRT14 | DD03L | Table Fields | AS4VERS |