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 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
|
||||||||||
| SIGN | Debit/credit sign (+/-) | FC_SIGN | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ITUSE | Where-applied indicator | FC_ITUSE | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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
|
||||||||||
| CITEMIND | Consolidation item | FC_CITEM_I | CHAR | 1 | 0 |
Possible values
|
||||||||||
| APPNIIND | Appropriation item | FC_APPNI_I | CHAR | 1 | 0 |
Possible values
|
||||||||||
| CIIND | Carry forward the net balance | FC_CIIND | CHAR | 1 | 0 |
Possible values
|
||||||||||
| DEIND | Totals item may be entered/posted to | FC_DEIND | CHAR | 1 | 0 |
Possible values
|
||||||||||
| IDEIND | Item blocked against entry and posting | FC_IDEIND | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 |
