SAP Table T821S
Distribution keys
T821S (Distribution keys) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T821S to other SAP tables.
T821S table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
SPRED
Distribution Key
|
SPRED |
CHAR
|
4 | 0 | ||||||||||
|
REFSP
Reference distribution key
|
REFSP | T821S |
CHAR
|
4 | 0 | |||||||||
|
CRNAM
Created By
|
CRNAM |
CHAR
|
12 | 0 | ||||||||||
|
CRDAT
Creation date
|
CRDAT |
DATS
|
8 | 0 | ||||||||||
|
UPNAM
Last Changed By
|
UPNAM |
CHAR
|
12 | 0 | ||||||||||
|
UPDAT
Date on which object was last changed
|
UPDAT |
DATS
|
8 | 0 | ||||||||||
|
BRGRU
Authorization Group
|
BRGRU | TBRG |
CHAR
|
4 | 0 | |||||||||
|
PERFLAG
Period-type indicator
|
PERFLAG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
PERIV
Fiscal Year Variant
|
PERIV | T009 |
CHAR
|
2 | 0 | |||||||||
|
APERIO
Initial year/period
|
APERIO |
NUMC
|
7 | 0 | ||||||||||
|
ZYKEL
Cyclic distribution key
|
DZYKEL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
T821S foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T821S | BRGRU | TBRG | BROBJ |
TBRG
Authorization groups
|
BROBJ |
| T821S | BRGRU | T821S | BRGRU |
TBRG
Authorization groups
|
BRGRU |
| T821S | BRGRU | T821S | MANDT |
TBRG
Authorization groups
|
MANDT |
| T821S | MANDT | T821S | MANDT |
T000
Clients
|
MANDT |
| T821S | PERIV | T821S | MANDT |
T009
Fiscal Year Variants
|
MANDT |
| T821S | PERIV | T821S | PERIV |
T009
Fiscal Year Variants
|
PERIV |
| T821S | REFSP | T821S | MANDT |
T821S
Distribution keys
|
MANDT |
| T821S | REFSP | T821S | REFSP |
T821S
Distribution keys
|
SPRED |