1. Home
  2. Resources
  3. SAP Tables
  4. TF500 - Document Types

SAP Table TF500

Document Types

TF500 (Document Types) 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 TF500 to other SAP tables.

TF500 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DIMEN Dimension FC_DIMEN TF150 CHAR 2 0
DOCTY Document type FC_DOCTY CHAR 2 0
RLEVL Posting level FC_BLEVL CHAR 2 0
NULL Realtime update
01 Adjustments to reported data
02 Reported data: Cons group change
10 Standardizing entry
12 Standardized data: Cons group change
20 Two-sided elimination entry
21 Reconciliation entry for elimination
22 Two-sided elimination: Cons group change
23 Two-sided elimination: Special logic
24 Two-sided elimination: Cons group change with special logic
30 Consolidation entry
TCIND Post in transaction currency FC_TCUR CHAR 1 0
X Yes
NULL No
LCIND Post in local currency FC_LCUR CHAR 1 0
X Yes
NULL No
GCIND Post in group currency FC_CGCUR CHAR 1 0
X Yes
NULL No
CUTYP Exchange rate indicator FC_EXRIND TF420 CHAR 1 0
BLCHK Balance check for consolidation document FC_BLCHK CHAR 1 0
0 Error when balance not equal to zero
1 Warning when balance not equal to zero
2 No balance check
DTAXD Credit deferred income taxes FC_TAXD CHAR 1 0
X Yes
NULL No
DTAXC Debit deferred income taxes FC_TAXC CHAR 1 0
X Yes
NULL No
MNPOS Manual Posting FC_MANPOS CHAR 1 0
X Yes
NULL No
QNTIN Post quantities FC_QNTIN CHAR 1 0
NULL Not Selected
X Selected
ADTIN Use of custom characteristics FC_ADTIN CHAR 1 0
NULL Not Selected
X Selected
TAXIN Do not use a composite tax rate FC_TAXIN CHAR 1 0
CACTA Business application FC_CACTA CHAR 1 0
1 Elimination of IU payables and receivables
2 Elimination of IU revenue and expense
3 Consolidation of investment income
4 Elimination of IU profit/loss in inventory
5 Elimination of IU profit/loss in transferred assets
6 Consolidation of investments
7 Reclassification
9 Other
CNVIN Translate to group currency FC_CNVIN CHAR 1 0
NULL Not Selected
X Selected

TF500 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TF500 CUTYP TF500 CUTYP TF420 Exchange Rate Indicators KURSA
TF500 CUTYP TF500 MANDT TF420 Exchange Rate Indicators MANDT
TF500 DIMEN TF500 MANDT TF150 Dimensions MANDT
TF500 DIMEN TF500 DIMEN TF150 Dimensions DIMEN
TF500 MANDT TF500 MANDT T000 Clients MANDT