SAP Table T820
Planning Parameters
T820 (Planning Parameters) 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 T820 to other SAP tables.
T820 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
RPLAN
Plan parameters
|
RPLAN |
CHAR
|
8 | 0 | ||||||||
|
SETNR
Identification of a set
|
SETID |
CHAR
|
34 | 0 | ||||||||
|
DIPER
Frequency of planned periods
|
DIPER |
NUMC
|
3 | 0 | ||||||||
|
FRPER
First Posting Period Allowed (in Interval 1)
|
FRPER |
NUMC
|
3 | 0 | ||||||||
|
TOPER
Last Posting Period Allowed (in Interval 1)
|
TOPER |
NUMC
|
3 | 0 | ||||||||
|
CUTYP
Exchange Rate Type
|
KURST | TCURV |
CHAR
|
4 | 0 | |||||||
|
MACUD
Maximum currency deviation
|
MACUD |
NUMC
|
2 | 0 | ||||||||
|
CSPRED
Distribution key for currency amounts
|
CSPRED | T821S |
CHAR
|
4 | 0 | |||||||
|
QSPRED
Distribution key for quantities
|
QSPRED | T821S |
CHAR
|
4 | 0 | |||||||
|
DOCTY
FI-SL Document Type
|
DOCTY | T889 |
CHAR
|
2 | 0 | |||||||
|
VALDIS
Ind.: Display field contents of single values of dimension?
|
VALDIS |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TXTDIS
Ind.: Display field description for outlined dimension?
|
TXTDIS |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
GL
Ind.: FI-SL part is maintained?
|
PLANGL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
RKK
Ind. Is CO primary cost planning maintained?
|
PLANRKK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TRCUR
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
CCCUR
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
LCCUR
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ACCUR
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
RCCUR
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
OCCUR
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
QUANT
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ATQNT
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
RKL
Ind. Is CO activity type planning maintained?
|
PLANRKL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AAQNT
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AKQNT
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AOQNT
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TFCUR
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TVCUR
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
RKB
Ind.:Is CO statistical key figure planning maintained?
|
PLANRKB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SAQNT
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SMQNT
Ind.: Plan field group manually?
|
PLANMANUAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TRDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
CCDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
LCDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ACDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
RCDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
OCDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
QUDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ATDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AADIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AKDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AODIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TFDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TVDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SADIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SMDIS
Ind.: Display field group in the summary/period screen?
|
FGDISPLAY |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
CLASS
Planning parameter class
|
CLASS_D | T822 |
CHAR
|
6 | 0 | |||||||
|
BRGRU
Authorization Group
|
BRGRU | TBRG |
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 | ||||||||
|
SET_FIELD
Field name
|
SETFLD |
CHAR
|
30 | 0 | ||||||||
|
CONDENSE
Summarized Planning
|
GLX_CONDENSE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
T820 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T820 | BRGRU | T820 | BRGRU |
TBRG
Authorization groups
|
BRGRU |
| T820 | BRGRU | T820 | MANDT |
TBRG
Authorization groups
|
MANDT |
| T820 | BRGRU | TBRG | BROBJ |
TBRG
Authorization groups
|
BROBJ |
| T820 | CLASS | T820 | CLASS |
T822
Planning Parameter Classes
|
CLASS |
| T820 | CLASS | T820 | MANDT |
T822
Planning Parameter Classes
|
MANDT |
| T820 | CSPRED | T820 | MANDT |
T821S
Distribution keys
|
MANDT |
| T820 | CSPRED | T820 | CSPRED |
T821S
Distribution keys
|
SPRED |
| T820 | CUTYP | T820 | MANDT |
TCURV
Exchange rate types for currency translation
|
MANDT |
| T820 | CUTYP | T820 | CUTYP |
TCURV
Exchange rate types for currency translation
|
KURST |
| T820 | DOCTY | T820 | MANDT |
T889
FI-SL Document Types
|
MANDT |
| T820 | DOCTY | T820 | DOCTY |
T889
FI-SL Document Types
|
DOCTY |
| T820 | MANDT | T820 | MANDT |
T000
Clients
|
MANDT |
| T820 | QSPRED | T820 | MANDT |
T821S
Distribution keys
|
MANDT |
| T820 | QSPRED | T820 | QSPRED |
T821S
Distribution keys
|
SPRED |