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.
TF100 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
SIGN
Debit/credit sign (+/-)
|
FC_SIGN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ITUSE
Where-applied indicator
|
FC_ITUSE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
CITEMIND
Consolidation item
|
FC_CITEM_I |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
APPNIIND
Appropriation item
|
FC_APPNI_I |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
CIIND
Carry forward the net balance
|
FC_CIIND |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
DEIND
Totals item may be entered/posted to
|
FC_DEIND |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
IDEIND
Item blocked against entry and posting
|
FC_IDEIND |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ITGRP |
TF103
Breakdown Categories
|
ITGRP |
| TF100 | ITGRP | TF100 | MANDT |
TF103
Breakdown Categories
|
MANDT |
| TF100 | ITGRP | TF100 | ITCLG |
TF103
Breakdown Categories
|
ITCLG |
| 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 |