SAP Table
T821S Distribution keys
SAP table T821S has 2 primary key fields being MANDT,SPRED.
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
T821S columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeySPRED | 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 | ||||||||
|
|||||||||||||
| 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 | ||||||||
/ Relationships
T821S foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T821S | BRGRU | TBRG | Authorization groups | MANDT |
| T821S | BRGRU | TBRG | Authorization groups | BRGRU |
| T821S | PERIV | T009 | Fiscal Year Variants | MANDT |
| T821S | PERIV | T009 | Fiscal Year Variants | PERIV |
| T821S | REFSP | T821S | Distribution keys | MANDT |
| T821S | REFSP | T821S | Distribution keys | SPRED |