- Home
- Resources
- SAP Tables
- TF100 - Financial Statement Items
SAP Table TF100
Financial Statement Items
TF100 (Financial Statement Items) 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 TF100 to other SAP tables.
Source: TF100 (Financial Statement Items)
TF100 table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| ITCLG |
Consolidation chart of accounts |
FC_ITCLG |
TF120
|
CHAR |
|
2 |
0 |
|
| ITEM |
Financial statement item |
FC_ITEM |
|
CHAR |
|
10 |
0 |
|
| ITCGY |
FS item type |
FC_ITCGY |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
Value item |
| 2 |
Totals item |
| 3 |
Text item |
|
| SIGN |
Debit/credit sign (+/-) |
FC_SIGN |
|
CHAR |
|
1 |
0 |
Possible values
| + |
Debit (increase) |
| - |
Credit (decrease) |
|
| ITUSE |
Where-applied indicator |
FC_ITUSE |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Asset |
| B |
Liability/stockholders' equity |
| C |
Income statement |
| D |
Statistical |
|
| ITGRP |
Breakdown category |
FC_ITGRP |
TF103
|
CHAR |
|
4 |
0 |
|
| ITTYP |
FS item category |
FC_ITTYP |
TF105
|
CHAR |
|
1 |
0 |
|
| SBLNCIND |
Check the sign of the balance |
FC_SBLNC_I |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| CITEMIND |
Consolidation item |
FC_CITEM_I |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| APPNIIND |
Appropriation item |
FC_APPNI_I |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| CIIND |
Carry forward the net balance |
FC_CIIND |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| DEIND |
Totals item may be entered/posted to |
FC_DEIND |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| IDEIND |
Item blocked against entry and posting |
FC_IDEIND |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| CTRITEM |
Contra item |
FC_CTRITEM |
TF100
|
CHAR |
|
10 |
0 |
|
TF100 foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| TF100 |
CTRITEM |
TF100 |
MANDT |
TF100 |
Financial Statement Items |
MANDT |
| TF100 |
CTRITEM |
TF100 |
ITCLG |
TF100 |
Financial Statement Items |
ITCLG |
| TF100 |
CTRITEM |
TF100 |
CTRITEM |
TF100 |
Financial Statement Items |
ITEM |
| TF100 |
ITCLG |
TF100 |
MANDT |
TF120 |
Consolidation Charts of Accounts |
MANDT |
| TF100 |
ITCLG |
TF100 |
ITCLG |
TF120 |
Consolidation Charts of Accounts |
ITCLG |
| TF100 |
ITGRP |
TF100 |
MANDT |
TF103 |
Breakdown Categories |
MANDT |
| TF100 |
ITGRP |
TF100 |
ITCLG |
TF103 |
Breakdown Categories |
ITCLG |
| TF100 |
ITGRP |
TF100 |
ITGRP |
TF103 |
Breakdown Categories |
ITGRP |
| TF100 |
ITTYP |
TF100 |
MANDT |
TF105 |
FS Item Categories |
MANDT |
| TF100 |
ITTYP |
TF100 |
ITTYP |
TF105 |
FS Item Categories |
ITTYP |
| TF100 |
MANDT |
TF100 |
MANDT |
T000 |
Clients |
MANDT |
