SAP table T821S (Distribution keys)

SAP table T821S has 2 primary key fields being MANDT,SPRED.

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
SPRED Distribution Key CHAR 4 0 SPRED
REFSP Reference Distribution Key CHAR 4 0 T821S REFSP
CRNAM Created By CHAR 12 0 CRNAM
CRDAT Creation date DATS 8 0 CRDAT
UPNAM Last Changed By CHAR 12 0 UPNAM
UPDAT Date on which object was last changed DATS 8 0 UPDAT
BRGRU Authorization Group CHAR 4 0 TBRG BRGRU
PERFLAG Period-type indicator CHAR 1 0 PERFLAG
1 Periods according to fiscal year variant
2 Calendar weeks
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
APERIO Initial year/period NUMC 7 0 APERIO
ZYKEL Cyclic distribution key CHAR 1 0 DZYKEL

T821S foreign key relationships

Table Field Check Table Check Field
0 T821S BRGRU TBRG Authorization groups MANDT
0 T821S BRGRU TBRG Authorization groups BRGRU
1 T821S PERIV T009 Fiscal Year Variants MANDT
1 T821S PERIV T009 Fiscal Year Variants PERIV
0 T821S REFSP T821S Distribution keys MANDT
0 T821S REFSP T821S Distribution keys SPRED