SAP ABAP Table TF140 (Selected FS Items)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ EC-CS (Application Component) Consolidation
     ⤷ FC01_UC (Package) Cons: Master records items, consolidation units, etc.

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TF140	Table Relationship Diagram
Short Description	Selected FS Items

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RVERS	☑	FC_FIXVS	FC_FIXVS	CHAR	3	0	Version: Selected FS items	TF212
3	ITCLG	☑	FC_ITCLG	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts	TF120
4	ITBG	☐	FC_ITBG	FC_ITEM	CHAR	10	0	Item for retained earnings on the balance sheet	TF100
5	SITYP_BG	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
6	SITEM_BG	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
7	ITERG	☐	FC_ITERG	FC_ITEM	CHAR	10	0	Item for retained earnings on the income statement	TF100
8	SITYP_ERG	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
9	SITEM_ERG	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
10	ITLABD	☐	FC_ITLABD	FC_ITEM	CHAR	10	0	Balance sheet item for deferred income taxes (debit)	TF100
11	SITYP_LABD	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
12	SITEM_LABD	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
13	ITLABC	☐	FC_ITLABC	FC_ITEM	CHAR	10	0	B/S item for provisions for deferred income taxes (credit)	TF100
14	SITYP_LABC	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
15	SITEM_LABC	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
16	ITLAGD	☐	FC_ITLAGD	FC_ITEM	CHAR	10	0	Income statement item: Deferred taxes (debit)	TF100
17	SITYP_LAGD	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
18	SITEM_LAGD	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
19	ITLAGC	☐	FC_ITLAGC	FC_ITEM	CHAR	10	0	Income statement item: deferred income taxes (credit)	TF100
20	SITYP_LAGC	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
21	SITEM_LAGC	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
22	CFWDIT	☐	FC_CFWDIT	FC_ITEM	CHAR	10	0	Unappr.retained earnings carryforward item (debit)	TF100
23	CFWDST	☐	FC_CFWDST	FC_SITYP	CHAR	3	0	Subitem category	TF110
24	CFWDSI	☐	FC_CFWDSI	FC_SITEM	CHAR	10	0	Subitem - debit	TF115
25	CFWCIT	☐	FC_CFWCIT	FC_ITEM	CHAR	10	0	Unappr.retained earnings carryforward item(credit)	TF100
26	CFWCST	☐	FC_CFWCST	FC_SITYP	CHAR	3	0	Subitem category	TF110
27	CFWCSI	☐	FC_CFWCSI	FC_SITEM	CHAR	10	0	Subitem - credit	TF115
28	NISTAT	☐	FC_NISTAT	FC_ITEM	CHAR	10	0	Annual net income - statistical item	TF100
29	NICONT	☐	FC_NICONT	FC_ITEM	CHAR	10	0	Annual net income - offsetting item	TF100
30	MISTAT	☐	FC_MISTAT	FC_ITEM	CHAR	10	0	Minority interest in ANI - statistical item	TF100
31	MICONT	☐	FC_MICONT	FC_ITEM	CHAR	10	0	Minority interest in ANI - offsetting item	TF100
32	NISADJ	☐	FC_NISADJ	FC_ITEM	CHAR	10	0	Statistical item for adjusted annual net income	TF100
33	MISADJ	☐	FC_MISADJ	FC_ITEM	CHAR	10	0	Statistical item for minority interest in adjusted ANI	TF100
34	NISADJGW	☐	FC_NISADJGW	FC_ITEM	CHAR	10	0	Adjusted Annual Net Income, Statistical (Goodwill)	TF100
35	MISADJGW	☐	FC_MISADJGW	FC_ITEM	CHAR	10	0	Minority Int. in Annual Net Income, Statistical (Goodwill)	TF100
36	NISADJEQ	☐	FC_NISADJEQ	FC_ITEM	CHAR	10	0	Adjusted Annual Net Income, Statistical (Equity Method)	TF100
37	MISADJEQ	☐	FC_MISADJEQ	FC_ITEM	CHAR	10	0	Minority Int. in Annual Net Income, Statistical (Equity M.)	TF100
38	NIAPUA	☐	FC_NIAPUA	FC_ITEM	CHAR	10	0	Annual Net Income from Push-down Method, Statistical Item	TF100
39	MIAPUA	☐	FC_MIAPUA	FC_ITEM	CHAR	10	0	Minority Interest in ANI, Push-down Method, Statistical Item	TF100
40	GECONT	☐	FC_GECONT	FC_ITEM	CHAR	10	0	Overall statistical offsetting item	TF100
41	TOTANI	☐	FC_TOTANI	FC_ITEM	CHAR	10	0	Totals item for appropriation of retained earnings	TF100
42	NIPRFC	☐	FC_NIPRFC	FC_ITEM	CHAR	10	0	'Annual net income prior to first consolidation' item	TF100
43	NIPRCP	☐	FC_NIPRCP	FC_ITEM	CHAR	10	0	FS item: Annual net income prior to proportion change	TF100
44	NIPU	☐	FC_NIPU	FC_ITEM	CHAR	10	0	Annual Net Income Item for Push-down Method	TF100
45	NIOC	☐	FC_NIOC	FC_ITEM	CHAR	10	0	Annual Net Income Item, Organizational Change	TF100
46	NIMC	☐	FC_NIMC	FC_ITEM	CHAR	10	0	Annual Net Income Item for Method Change	TF100
47	NIMERG	☐	FC_NIMERG	FC_ITEM	CHAR	10	0	Net Income Item for Merger	TF100
48	NIDEMG	☐	FC_NIDEMG	FC_ITEM	CHAR	10	0	Net Income Item for Demerger	TF100
49	NIDIVP	☐	FC_NIDIVP	FC_ITEM	CHAR	10	0	Net Income Item for Partial Divestitures	TF100
50	APPRMDI	☐	FC_APPRMDI	FC_ITEM	CHAR	10	0	Item: Transfers to Minority Interest	TF100
51	APPRMDT	☐	FC_APPRMDT	FC_SITYP	CHAR	3	0	Subitem Category: Transfers to Minority Interest	TF110
52	APPRMDS	☐	FC_APPRMDS	FC_SITEM	CHAR	10	0	Subitem: Transfers to Minority Interest, Debit	TF115
53	APPRMCT	☐	FC_APPRMCT	FC_SITYP	CHAR	3	0	Subitem Category: Transfers to Minority Interest	TF110
54	APPRMCS	☐	FC_APPRMCS	FC_SITEM	CHAR	10	0	Subitems Transfers to Minority Interest Credit	TF115
55	TRANMD	☐	FC_TRANMD	FC_ITEM	CHAR	10	0	Item for transfers to minority interest in ret.earnings	TF100
56	TRANMC	☐	FC_TRANMC	FC_ITEM	CHAR	10	0	Item: Deductions from min.int. in ret. earnings	TF100
57	ELICOI	☐	FC_ELICOI	FC_ITEM	CHAR	10	0	Item: clearing of consolidation of investments	TF100
58	ELICOT	☐	FC_ELICOT	FC_SITYP	CHAR	3	0	Subitem category: Clearing of consolidation of investments	TF110
59	ELICDS	☐	FC_ELICDS	FC_SITEM	CHAR	10	0	Subitem: Clearing of consolidation of investments - debit	TF115
60	ELICCS	☐	FC_ELICCS	FC_SITEM	CHAR	10	0	Subitem: Clearing of consolidation of investments - credit	TF115
61	HRMINIT	☐	FC_HRMINIT	FC_ITEM	CHAR	10	0	Item for minority interest in hidden reserves	TF100
62	DIVSTDI	☐	FC_DIVSTDI	FC_ITEM	CHAR	10	0	FS item: Losses from divestitures	TF100
63	DIVSTDT	☐	FC_DIVSTDT	FC_SITYP	CHAR	3	0	Subitem category: Losses from divestitures	TF110
64	DIVSTDS	☐	FC_DIVSTDS	FC_SITEM	CHAR	10	0	Subitem: Losses from divestitures	TF115
65	DIVSTCI	☐	FC_DIVSTCI	FC_ITEM	CHAR	10	0	FS item: Gains from divestitures	TF100
66	DIVSTCT	☐	FC_DIVSTCT	FC_SITYP	CHAR	3	0	Subitem category: Gains from divestitures	TF110
67	DIVSTCS	☐	FC_DIVSTCS	FC_SITEM	CHAR	10	0	Subitem: Gains from divestitures	TF115
68	DIVEQDI	☐	FC_DIVEQDI	FC_ITEM	CHAR	10	0	FS item for divestiture expense from equity method	TF100
69	DIVEQDT	☐	FC_DIVEQDT	FC_SITYP	CHAR	3	0	Subitem category for divestiture expense from equity method	TF110
70	DIVEQDS	☐	FC_DIVEQDS	FC_SITEM	CHAR	10	0	Subitem for divestiture expense from equity method	TF115
71	DIVEQCI	☐	FC_DIVEQCI	FC_ITEM	CHAR	10	0	FS item for divestiture revenue from equity method	TF100
72	DIVEQCT	☐	FC_DIVEQCT	FC_SITYP	CHAR	3	0	Subitem category for divestiture revenue from equity method	TF110
73	DIVEQCS	☐	FC_DIVEQCS	FC_SITEM	CHAR	10	0	Subitem for divestiture revenue from equity method	TF115
74	DIVMIDI	☐	FC_DIVMIDI	FC_ITEM	CHAR	10	0	Item: Expense for divestitures, minority share	TF100
75	DIVMIDT	☐	FC_DIVMIDT	FC_SITYP	CHAR	3	0	Subitem category: Minority share of losses from divestitures	TF110
76	DIVMIDS	☐	FC_DIVMIDS	FC_SITEM	CHAR	10	0	Subitem: Minority share of losses from divestitures	TF115
77	DIVMICI	☐	FC_DIVMICI	FC_ITEM	CHAR	10	0	Item: Revenue from divestitures, minority share	TF100
78	DIVMICT	☐	FC_DIVMICT	FC_SITYP	CHAR	3	0	Subitem category: Minority share of gains from divestitures	TF110
79	DIVMICS	☐	FC_DIVMICS	FC_SITEM	CHAR	10	0	Subitem: Minority share of gains from divestitures	TF115
80	DIVITEM	☐	FC_DIVITEM	FC_ITEM	CHAR	10	0	Clearing item for transaction currency difference split	TF100
81	GPCNT1	☐	FC_GPCNT1I	FC_ITEM	CHAR	10	0	FS item for group share	TF100
82	GPCNT2	☐	FC_GPCNT2I	FC_ITEM	CHAR	10	0	FS item for group share in voting stock	TF100
83	GPCNT3	☐	FC_GPCNT3I	FC_ITEM	CHAR	10	0	Item for group share in non-voting stock	TF100
84	GPCNT4	☐	FC_GPCNT4I	FC_ITEM	CHAR	10	0	Item for group share in annual net income	TF100
85	GPCNT5	☐	FC_GPCNT5I	FC_ITEM	CHAR	10	0	Item for group share - direct investment	TF100
86	INVEXT	☐	FC_INVEXT	FC_ITEM	CHAR	10	0	Third-party Investment	TF100
87	FGWBEG	☐	FC_FGWBEG	FC_ITEM	CHAR	10	0	Full Goodwill at Beginning of Period	TF100
88	FGWEND	☐	FC_FGWEND	FC_ITEM	CHAR	10	0	Full Goodwill at End of Period	TF100
89	GWRESI	☐	FC_GWRESI	FC_ITEM	CHAR	10	0	Item: Appropriations for Goodwill	TF100
90	GWREST	☐	FC_GWREST	FC_SITYP	CHAR	3	0	Subitem Category: Appropriations for Goodwill	TF110
91	GWRESS	☐	FC_GWRESS	FC_SITEM	CHAR	10	0	Subitem: Appropriations for Goodwill	TF115
92	GWTADI	☐	FC_GWTADI	FC_ITEM	CHAR	10	0	Item: Currency Translation for Goodwill	TF100
93	GWTADT	☐	FC_GWTADT	FC_SITYP	CHAR	3	0	Subitem Category: Currency Translation for Goodwill	TF110
94	GWTADS	☐	FC_GWTADS	FC_SITEM	CHAR	10	0	Subitem: Currency Translation for Goodwill	TF115
95	NIGWAQI	☐	FC_NIGWAQI	FC_ITEM	CHAR	10	0	Item for goodwill accum.amortization item/neg. inv. BV	TF100
96	NIGWAQT	☐	FC_NIGWAQT	FC_SITYP	CHAR	3	0	Subitem cat. goodwill accum.amortization/neg. investment BV	TF110
97	NIGWAQS	☐	FC_NIGWAQS	FC_SITEM	CHAR	10	0	Subitem goodwill accum.amortization/negative investment BV	TF115
98	NIGWAMI	☐	FC_NIGWAMI	FC_ITEM	CHAR	10	0	Goodwill amortization item / negative investment book value	TF100
99	NIGWAMT	☐	FC_NIGWAMT	FC_SITYP	CHAR	3	0	SI cat. for goodwill amortization/neg. investment book value	TF110
100	NIGWAMS	☐	FC_NIGWAMS	FC_SITEM	CHAR	10	0	Subitem for Goodwill amortization/neg. investement bookvalue	TF115
101	ITBAG	☐	FC_ITBAG	FC_ITEM	CHAR	10	0	Balancing adjustment item for bus. area/profit center cons	TF100
102	PIWDI	☐	FC_PIWDI	FC_ITEM	CHAR	10	0	Item for Investment Amortization	TF100
103	PIWDT	☐	FC_PIWDT	FC_SITYP	CHAR	3	0	Subitem Category for Investment Amortization	TF110
104	PIWDS	☐	FC_PIWDS	FC_SITEM	CHAR	10	0	Subitem for Investment Amortization	TF115
105	PIWUI	☐	FC_PIWUI	FC_ITEM	CHAR	10	0	Item for Investment Writeup	TF100
106	PIWUT	☐	FC_PIWUT	FC_SITYP	CHAR	3	0	Subitem Category for Investment Writeup	TF110
107	PIWUS	☐	FC_PIWUS	FC_SITEM	CHAR	10	0	Subitem for Investment Writeup	TF115
108	LDTEQI	☐	FC_LDTEQI	FC_ITEM	CHAR	10	0	Equity Item for Legacy Data Transfer	TF100
109	LDTEQT	☐	FC_LDTEQT	FC_SITYP	CHAR	3	0	Subitem Category for Legacy Data Transfer	TF110
110	LDTEQS	☐	FC_LDTEQS	FC_SITEM	CHAR	10	0	Subitem for Legacy Data Transfer	TF115

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TF140	APPRMCS	TF115	SITEM
2	TF140	APPRMCT	TF110	SITYP
3	TF140	APPRMDI	TF100	ITEM
4	TF140	APPRMDS	TF115	SITEM
5	TF140	APPRMDT	TF110	SITYP
6	TF140	CFWCIT	TF100	ITEM
7	TF140	CFWCSI	TF115	SITEM
8	TF140	CFWCST	TF110	SITYP
9	TF140	CFWDIT	TF100	ITEM
10	TF140	CFWDSI	TF115	SITEM
11	TF140	CFWDST	TF110	SITYP
12	TF140	DIVEQCI	TF100	ITEM	KEY	1	CN
13	TF140	DIVEQCS	TF115	SITEM	KEY	1	CN
14	TF140	DIVEQCT	TF110	SITYP	KEY	1	CN
15	TF140	DIVEQDI	TF100	ITEM	KEY	1	CN
16	TF140	DIVEQDS	TF115	SITEM	KEY	1	CN
17	TF140	DIVEQDT	TF110	SITYP	KEY	1	CN
18	TF140	DIVITEM	TF100	ITEM
19	TF140	DIVMICI	TF100	ITEM		1	CN
20	TF140	DIVMICS	TF115	SITEM		1	CN
21	TF140	DIVMICT	TF110	SITYP		1	CN
22	TF140	DIVMIDI	TF100	ITEM	KEY	1	CN
23	TF140	DIVMIDS	TF115	SITEM		1	CN
24	TF140	DIVMIDT	TF110	SITYP	KEY	1	CN
25	TF140	DIVSTCI	TF100	ITEM
26	TF140	DIVSTCS	TF115	SITEM
27	TF140	DIVSTCT	TF110	SITYP
28	TF140	DIVSTDI	TF100	ITEM
29	TF140	DIVSTDS	TF115	SITEM
30	TF140	DIVSTDT	TF110	SITYP
31	TF140	ELICCS	TF115	SITEM
32	TF140	ELICDS	TF115	SITEM
33	TF140	ELICOI	TF100	ITEM
34	TF140	ELICOT	TF110	SITYP
35	TF140	FGWBEG	TF100	ITEM
36	TF140	FGWEND	TF100	ITEM
37	TF140	GECONT	TF100	ITEM
38	TF140	GPCNT1	TF100	ITEM
39	TF140	GPCNT2	TF100	ITEM
40	TF140	GPCNT3	TF100	ITEM
41	TF140	GPCNT4	TF100	ITEM
42	TF140	GPCNT5	TF100	ITEM
43	TF140	GWRESI	TF100	ITEM
44	TF140	GWRESS	TF115	SITEM
45	TF140	GWREST	TF110	SITYP
46	TF140	GWTADI	TF100	ITEM
47	TF140	GWTADS	TF115	SITEM
48	TF140	GWTADT	TF110	SITYP
49	TF140	HRMINIT	TF100	ITEM
50	TF140	INVEXT	TF100	ITEM
51	TF140	ITBAG	TF100	ITEM	KEY	1	CN
52	TF140	ITBG	TF100	ITEM	KEY	1	CN
53	TF140	ITCLG	TF120	ITCLG	KEY	1	CN
54	TF140	ITERG	TF100	ITEM	KEY	1	CN
55	TF140	ITLABC	TF100	ITEM	KEY	1	CN
56	TF140	ITLABD	TF100	ITEM	KEY	1	CN
57	TF140	ITLAGC	TF100	ITEM	KEY	1	CN
58	TF140	ITLAGD	TF100	ITEM	KEY	1	CN
59	TF140	LDTEQI	TF100	ITEM
60	TF140	LDTEQS	TF115	SITEM
61	TF140	LDTEQT	TF110	SITYP
62	TF140	MANDT	T000	MANDT	KEY	1	CN
63	TF140	MIAPUA	TF100	ITEM
64	TF140	MICONT	TF100	ITEM
65	TF140	MISADJ	TF100	ITEM
66	TF140	MISADJEQ	TF100	ITEM
67	TF140	MISADJGW	TF100	ITEM
68	TF140	MISTAT	TF100	ITEM
69	TF140	NIAPUA	TF100	ITEM
70	TF140	NICONT	TF100	ITEM
71	TF140	NIDEMG	TF100	ITEM
72	TF140	NIDIVP	TF100	ITEM
73	TF140	NIGWAMI	TF100	ITEM
74	TF140	NIGWAMS	TF115	SITEM
75	TF140	NIGWAMT	TF110	SITYP
76	TF140	NIGWAQI	TF100	ITEM
77	TF140	NIGWAQS	TF115	SITEM
78	TF140	NIGWAQT	TF110	SITYP
79	TF140	NIMC	TF100	ITEM
80	TF140	NIMERG	TF100	ITEM
81	TF140	NIOC	TF100	ITEM
82	TF140	NIPRCP	TF100	ITEM
83	TF140	NIPRFC	TF100	ITEM
84	TF140	NIPU	TF100	ITEM
85	TF140	NISADJ	TF100	ITEM
86	TF140	NISADJEQ	TF100	ITEM
87	TF140	NISADJGW	TF100	ITEM
88	TF140	NISTAT	TF100	ITEM
89	TF140	PIWDI	TF100	ITEM
90	TF140	PIWDS	TF115	SITEM
91	TF140	PIWDT	TF110	SITYP
92	TF140	PIWUI	TF100	ITEM
93	TF140	PIWUS	TF115	SITEM
94	TF140	PIWUT	TF110	SITYP
95	TF140	RVERS	TF212	FIXVS	KEY	1	CN
96	TF140	SITEM_BG	TF115	SITEM	KEY	1	CN
97	TF140	SITEM_ERG	TF115	SITEM	KEY	1	CN
98	TF140	SITEM_LABC	TF115	SITEM	KEY	1	CN
99	TF140	SITEM_LABD	TF115	SITEM	KEY	1	CN
100	TF140	SITEM_LAGC	TF115	SITEM	KEY	1	CN
101	TF140	SITEM_LAGD	TF115	SITEM	KEY	1	CN
102	TF140	SITYP_BG	TF110	SITYP	KEY	1	CN
103	TF140	SITYP_ERG	TF110	SITYP	KEY	1	CN
104	TF140	SITYP_LABC	TF110	SITYP	KEY	1	CN
105	TF140	SITYP_LABD	TF110	SITYP	KEY	1	CN
106	TF140	SITYP_LAGC	TF110	SITYP	KEY	1	CN
107	TF140	SITYP_LAGD	TF110	SITYP	KEY	1	CN
108	TF140	TOTANI	TF100	ITEM
109	TF140	TRANMC	TF100	ITEM
110	TF140	TRANMD	TF100	ITEM

History

Last changed by/on	SAP	20110901
SAP Release Created in