SAP table T312S (Profile for Sorting)

SAP table T312S has 4 primary key fields being MANDT,SORPO,LGNUM,SOKNZ.

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
SORPO Sorting pool CHAR 30 0 DD02L T312SSORPO
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
SOKNZ 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

T312S foreign key relationships

Table Field Check Table Check Field
0 T312S LGNUM T300 WM Warehouse Numbers MANDT
0 T312S LGNUM T300 WM Warehouse Numbers LGNUM
1 T312S MANDT T000 Clients MANDT
0 T312S SORPO DD02L SAP Tables TABNAME
0 T312S SORPO DD02L SAP Tables AS4LOCAL
0 T312S SORPO DD02L SAP Tables AS4VERS
1 T312S SRT00 DD03L Table Fields TABNAME
1 T312S SRT00 DD03L Table Fields FIELDNAME
1 T312S SRT00 DD03L Table Fields AS4LOCAL
1 T312S SRT00 DD03L Table Fields AS4VERS
0 T312S SRT01 DD03L Table Fields TABNAME
0 T312S SRT01 DD03L Table Fields FIELDNAME
0 T312S SRT01 DD03L Table Fields AS4LOCAL
0 T312S SRT01 DD03L Table Fields AS4VERS
1 T312S SRT02 DD03L Table Fields TABNAME
1 T312S SRT02 DD03L Table Fields FIELDNAME
1 T312S SRT02 DD03L Table Fields AS4LOCAL
1 T312S SRT02 DD03L Table Fields AS4VERS
0 T312S SRT03 DD03L Table Fields TABNAME
0 T312S SRT03 DD03L Table Fields FIELDNAME
0 T312S SRT03 DD03L Table Fields AS4LOCAL
0 T312S SRT03 DD03L Table Fields AS4VERS
1 T312S SRT04 DD03L Table Fields TABNAME
1 T312S SRT04 DD03L Table Fields FIELDNAME
1 T312S SRT04 DD03L Table Fields AS4LOCAL
1 T312S SRT04 DD03L Table Fields AS4VERS
0 T312S SRT05 DD03L Table Fields TABNAME
0 T312S SRT05 DD03L Table Fields FIELDNAME
0 T312S SRT05 DD03L Table Fields AS4LOCAL
0 T312S SRT05 DD03L Table Fields AS4VERS
1 T312S SRT06 DD03L Table Fields TABNAME
1 T312S SRT06 DD03L Table Fields FIELDNAME
1 T312S SRT06 DD03L Table Fields AS4LOCAL
1 T312S SRT06 DD03L Table Fields AS4VERS
0 T312S SRT07 DD03L Table Fields TABNAME
0 T312S SRT07 DD03L Table Fields FIELDNAME
0 T312S SRT07 DD03L Table Fields AS4LOCAL
0 T312S SRT07 DD03L Table Fields AS4VERS
1 T312S SRT08 DD03L Table Fields TABNAME
1 T312S SRT08 DD03L Table Fields FIELDNAME
1 T312S SRT08 DD03L Table Fields AS4LOCAL
1 T312S SRT08 DD03L Table Fields AS4VERS
0 T312S SRT09 DD03L Table Fields TABNAME
0 T312S SRT09 DD03L Table Fields FIELDNAME
0 T312S SRT09 DD03L Table Fields AS4LOCAL
0 T312S SRT09 DD03L Table Fields AS4VERS
1 T312S SRT10 DD03L Table Fields TABNAME
1 T312S SRT10 DD03L Table Fields FIELDNAME
1 T312S SRT10 DD03L Table Fields AS4LOCAL
1 T312S SRT10 DD03L Table Fields AS4VERS
0 T312S SRT11 DD03L Table Fields TABNAME
0 T312S SRT11 DD03L Table Fields FIELDNAME
0 T312S SRT11 DD03L Table Fields AS4LOCAL
0 T312S SRT11 DD03L Table Fields AS4VERS
1 T312S SRT12 DD03L Table Fields TABNAME
1 T312S SRT12 DD03L Table Fields FIELDNAME
1 T312S SRT12 DD03L Table Fields AS4LOCAL
1 T312S SRT12 DD03L Table Fields AS4VERS
0 T312S SRT13 DD03L Table Fields TABNAME
0 T312S SRT13 DD03L Table Fields FIELDNAME
0 T312S SRT13 DD03L Table Fields AS4LOCAL
0 T312S SRT13 DD03L Table Fields AS4VERS
1 T312S SRT14 DD03L Table Fields TABNAME
1 T312S SRT14 DD03L Table Fields FIELDNAME
1 T312S SRT14 DD03L Table Fields AS4LOCAL
1 T312S SRT14 DD03L Table Fields AS4VERS