SAP table TF100 (Financial Statement Items)
SAP table TF100 has 3 primary key fields being MANDT,ITCLG,ITEM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Consolidation Chart of Accounts
CHAR
2
0
TF120
FC_ITCLG
Financial Statement Item
CHAR
10
0
FC_ITEM
ITCGY
Financial Statement Item Type
CHAR
1
0
FC_ITCGY
Possible values
1
Value item
2
Totals item
3
Text item
SIGN
Debit/credit sign (+/-)
CHAR
1
0
FC_SIGN
Possible values
+
Debit (increase)
-
Credit (decrease)
ITUSE
Where-Applied Indicator
CHAR
1
0
FC_ITUSE
Possible values
A
Asset
B
Liability/stockholders' equity
C
Income statement
D
Statistical
ITGRP
Breakdown Category
CHAR
4
0
TF103
FC_ITGRP
ITTYP
FS Item Category
CHAR
1
0
TF105
FC_ITTYP
SBLNCIND
Check the Sign of Balance
CHAR
1
0
FC_SBLNC_I
CITEMIND
Consolidation Item
CHAR
1
0
FC_CITEM_I
APPNIIND
Appropriation Item
CHAR
1
0
FC_APPNI_I
CIIND
Carry Forward the Net Balance
CHAR
1
0
FC_CIIND
DEIND
Totals Item May Be Entered/Posted to
CHAR
1
0
FC_DEIND
IDEIND
Item Blocked Against Entry and Posting
CHAR
1
0
FC_IDEIND
CTRITEM
Contra Item
CHAR
10
0
TF100
FC_CTRITEM
TF100 foreign key relationships
Table
Field
Check Table
Check Field
0 TF100
CTRITEM
TF100 Financial Statement Items
MANDT
0 TF100
CTRITEM
TF100 Financial Statement Items
ITCLG
1 TF100
ITCLG
TF120 Consolidation Charts of Accounts
MANDT
1 TF100
ITCLG
TF120 Consolidation Charts of Accounts
ITCLG
0 TF100
ITGRP
TF103 Breakdown Categories
MANDT
0 TF100
ITGRP
TF103 Breakdown Categories
ITCLG
0 TF100
ITGRP
TF103 Breakdown Categories
ITGRP
1 TF100
ITTYP
TF105 FS Item Categories
MANDT