- Home
- Resources
- SAP Tables
- 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.
Source: TF500 (Document Types)
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 |
Possible values
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 |
Possible values
|
LCIND |
Post in local currency |
FC_LCUR |
|
CHAR |
|
1 |
0 |
Possible values
|
GCIND |
Post in group currency |
FC_CGCUR |
|
CHAR |
|
1 |
0 |
Possible values
|
CUTYP |
Exchange rate indicator |
FC_EXRIND |
TF420
|
CHAR |
|
1 |
0 |
|
BLCHK |
Balance check for consolidation document |
FC_BLCHK |
|
CHAR |
|
1 |
0 |
Possible values
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 |
Possible values
|
DTAXC |
Debit deferred income taxes |
FC_TAXC |
|
CHAR |
|
1 |
0 |
Possible values
|
MNPOS |
Manual Posting |
FC_MANPOS |
|
CHAR |
|
1 |
0 |
Possible values
|
QNTIN |
Post quantities |
FC_QNTIN |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not Selected |
X |
Selected |
|
ADTIN |
Use of custom characteristics |
FC_ADTIN |
|
CHAR |
|
1 |
0 |
Possible values
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 |
Possible values
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 |
Possible values
NULL |
Not Selected |
X |
Selected |
|
TF500 foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
TF500 |
CUTYP |
TF500 |
MANDT |
TF420 |
Exchange Rate Indicators |
MANDT |
TF500 |
CUTYP |
TF500 |
CUTYP |
TF420 |
Exchange Rate Indicators |
KURSA |
TF500 |
DIMEN |
TF500 |
MANDT |
TF150 |
Dimensions |
MANDT |
TF500 |
DIMEN |
TF500 |
DIMEN |
TF150 |
Dimensions |
DIMEN |
TF500 |
MANDT |
TF500 |
MANDT |
T000 |
Clients |
MANDT |