SAP table T021M (Sort Variants)
SAP table T021M has 4 primary key fields being MANDT,PROGN,ANWND,SRVAR.
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
Client
CLNT
3
0
MANDT
Program Name
CHAR
8
0
PROGN_021M
Possible values
FAGL_AB
Flexible Balance Display
RFDKLI*
Credit management
RFEPOS00
Line item display
RFFO*
Payment medium
RFKORD*
Correspondence
SAPF150D
Dunning printout
Application
CHAR
5
0
ANWND_021M
Possible values
EPOS
Line items
FLEXG
Flexible Balance Display
KLI40
Credit overview
KORB
Internal documents
KORK
Correspondence
KORP
Line items
MHND
Dunning notice item
MHNK
Dunning notice header
REGUH
Correspondence
REGUP
Line items
Sort Variant
CHAR
3
0
SRVAR_021M
FELD1
Field Name
CHAR
30
0
FELDN_021M
FELD2
Field Name
CHAR
30
0
FELDN_021M
FELD3
Field Name
CHAR
30
0
FELDN_021M
FELD4
Field Name
CHAR
30
0
FELDN_021M
FELD5
Field Name
CHAR
30
0
FELDN_021M
TNAM1
Table Name
CHAR
30
0
DD02L
TABNAME
TNAM2
Table Name
CHAR
30
0
DD02L
TABNAME
TNAM3
Table Name
CHAR
30
0
DD02L
TABNAME
TNAM4
Table Name
CHAR
30
0
DD02L
TABNAME
TNAM5
Table Name
CHAR
30
0
DD02L
TABNAME
OFFS1
Offset in Field
NUMC
2
0
OFFSE
OFFS2
Offset in Field
NUMC
2
0
OFFSE
OFFS3
Offset in Field
NUMC
2
0
OFFSE
OFFS4
Offset in Field
NUMC
2
0
OFFSE
OFFS5
Offset in Field
NUMC
2
0
OFFSE
LENG1
Display Length
NUMC
2
0
LENGT
LENG2
Display Length
NUMC
2
0
LENGT
LENG3
Display Length
NUMC
2
0
LENGT
LENG4
Display Length
NUMC
2
0
LENGT
LENG5
Display Length
NUMC
2
0
LENGT
SABST
Indicator: Sort in Descending Order?
CHAR
1
0
SABST_021M
T021M foreign key relationships
Table
Field
Check Table
Check Field
0 T021M
TNAM1
DD02L SAP Tables
TABNAME
0 T021M
TNAM1
DD02L SAP Tables
AS4LOCAL
0 T021M
TNAM1
DD02L SAP Tables
AS4VERS
1 T021M
TNAM2
DD02L SAP Tables
TABNAME
1 T021M
TNAM2
DD02L SAP Tables
AS4LOCAL
1 T021M
TNAM2
DD02L SAP Tables
AS4VERS
0 T021M
TNAM3
DD02L SAP Tables
TABNAME
0 T021M
TNAM3
DD02L SAP Tables
AS4LOCAL
0 T021M
TNAM3
DD02L SAP Tables
AS4VERS
1 T021M
TNAM4
DD02L SAP Tables
TABNAME
1 T021M
TNAM4
DD02L SAP Tables
AS4LOCAL
1 T021M
TNAM4
DD02L SAP Tables
AS4VERS
0 T021M
TNAM5
DD02L SAP Tables
TABNAME
0 T021M
TNAM5
DD02L SAP Tables
AS4LOCAL
0 T021M
TNAM5
DD02L SAP Tables
AS4VERS