SAP ABAP Table TF692 (Global Chart of Accounts-Based Settings for C/I)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ EC-CS (Application Component) Consolidation
     ⤷ FC06_UC (Package) SAP Consolidation: Consolidation of Investments

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TF692	Table Relationship Diagram
Short Description	Global Chart of Accounts-Based Settings for C/I

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	DIMEN	☑	FC_DIMEN	FC_DIMEN	CHAR	2	0	Dimension	TF150
3	ITCLG	☑	FC_ITCLG	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts	TF120
4	.INCLUDE	☐				0	0	C/I: Optional Global oder Method-dep., Cons Chart Settings
5	GWAAQDI	☐	FC_GWAAQDI	FC_ITEM	CHAR	10	0	Item for the acquisition cost of goodwill	TF100
6	GWAAQDT	☐	FC_GWAAQDT	FC_SITYP	CHAR	3	0	Subitem category for the acquisition cost of goodwill	TF110
7	GWAAQDS	☐	FC_GWAAQDS	FC_SITEM	CHAR	10	0	Subitem for the acquisition cost of goodwill	TF115
8	GWAAQCTPYS	☐	FC_GWAAQCTPYS	FC_SITEM	CHAR	10	0	Subitem Goodwill Amortization CTD Orig.Cost, Opening Balance	TF115
9	GWAAQCTCYS	☐	FC_GWAAQCTCYS	FC_SITEM	CHAR	10	0	Subitem Goodwill Amortization CTD Orig.Cost, Current Year	TF115
10	GWAOFFSDI	☐	FC_GWAOFFSDI	FC_ITEM	CHAR	10	0	Offsetting Item, Goodwill Amortization, Acquisition Cost	TF100
11	GWAOFFSDT	☐	FC_GWAOFFSDT	FC_SITYP	CHAR	3	0	Subitem Categ.: Offsetting Entry, Goodwill Amort., Acq.Cost	TF110
12	GWAOFFSDS	☐	FC_GWAOFFSDS	FC_SITEM	CHAR	10	0	Subitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Debit	TF115
13	GWAOFFSCS	☐	FC_GWAOFFSCS	FC_SITEM	CHAR	10	0	Subitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Credit	TF115
14	GWAAQCI	☐	FC_GWAAQCI	FC_ITEM	CHAR	10	0	Item for the accumulated amortization of goodwill	TF100
15	GWAAQCT	☐	FC_GWAAQCT	FC_SITYP	CHAR	3	0	Subitem category for accumulated amortization of goodwill	TF110
16	GWADPCS	☐	FC_GWADPCS	FC_SITEM	CHAR	10	0	Subitem for the amortization of goodwill	TF115
17	GWADPDS	☐	FC_GWADPDS	FC_SITEM	CHAR	10	0	Subitem for writeups of goodwill	TF115
18	GWADPCTPYS	☐	FC_GWADPCTPYS	FC_SITEM	CHAR	10	0	Subitem Goodwill Amortization CTD Val.Allow., Opening Bal.	TF115
19	GWADPCTCYS	☐	FC_GWADPCTCYS	FC_SITEM	CHAR	10	0	Subitem Goodwill Amortization CTD Val.Allow., Current Year	TF115
20	GWAAMDI	☐	FC_GWAAMDI	FC_ITEM	CHAR	10	0	Item for the amortization of goodwill	TF100
21	GWAAMDT	☐	FC_GWAAMDT	FC_SITYP	CHAR	3	0	Subitem category for the amortization of goodwill	TF110
22	GWAAMDS	☐	FC_GWAAMDS	FC_SITEM	CHAR	10	0	Subitem for the amortization of goodwill	TF115
23	GWAAMCI	☐	FC_GWAAMCI	FC_ITEM	CHAR	10	0	Item for goodwill writeups	TF100
24	GWAAMCT	☐	FC_GWAAMCT	FC_SITYP	CHAR	3	0	Subitem category for goodwill writeups	TF110
25	GWAAMCS	☐	FC_GWAAMCS	FC_SITEM	CHAR	10	0	Subitem for writeups of goodwill	TF115
26	GWASTAT	☐	FC_GWASTAT	FC_ITEM	CHAR	10	0	Item for Goodwill Val.Allowances: Amortization, Statistical	TF100
27	GWASTATCT	☐	FC_GWASTATCT	FC_ITEM	CHAR	10	0	Item Goodwill Amortization CTD, Statistical	TF100
28	GWASTATOFFS	☐	FC_GWASTATOFFS	FC_ITEM	CHAR	10	0	Offsetting Item, Goodwill Amortization, Statistical	TF100
29	GWRAQDI	☐	FC_GWRAQDI	FC_ITEM	CHAR	10	0	Bal.sheet item: periodic reduction of goodwill	TF100
30	GWRAQDT	☐	FC_GWRAQDT	FC_SITYP	CHAR	3	0	Subitem category for B/S item for periodic reduction of GW	TF110
31	GWRAQDS	☐	FC_GWRAQDS	FC_SITEM	CHAR	10	0	Subitem for periodic reduction of goodwill - acquisition	TF115
32	GWRAQCS	☐	FC_GWRAQCS	FC_SITEM	CHAR	10	0	Subitem for periodic reduction of goodwill - divestiture	TF115
33	GWROFFSDI	☐	FC_GWROFFSDI	FC_ITEM	CHAR	10	0	Offset.Item: Goodwill Periodic Reduction, Acquisition Cost	TF100
34	GWROFFSDT	☐	FC_GWROFFSDT	FC_SITYP	CHAR	3	0	Subitem Cat.: Offset.Entry, Goodwill Periodic Reduction, APC	TF110
35	GWROFFSDS	☐	FC_GWROFFSDS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Goodwill Periodic Reduction, Debit	TF115
36	GWROFFSCS	☐	FC_GWROFFSCS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Goodwill Periodic Reduction, Credit	TF115
37	GWRAMDI	☐	FC_GWRAMDI	FC_ITEM	CHAR	10	0	Item for periodic reduction of goodwill: debits	TF100
38	GWRAMDT	☐	FC_GWRAMDT	FC_SITYP	CHAR	3	0	Subitem category for periodic reduction of goodwill: debits	TF110
39	GWRAMDS	☐	FC_GWRAMDS	FC_SITEM	CHAR	10	0	Subitem for periodic reduction of goodwill: debits	TF115
40	GWRAMCI	☐	FC_GWRAMCI	FC_ITEM	CHAR	10	0	Item for periodic reduction of goodwill: credits	TF100
41	GWRAMCT	☐	FC_GWRAMCT	FC_SITYP	CHAR	3	0	Subitem category for periodic reduction of goodwill: credits	TF110
42	GWRAMCS	☐	FC_GWRAMCS	FC_SITEM	CHAR	10	0	Subitem for periodic reduction of goodwill: credits	TF115
43	GWRSTAT	☐	FC_GWRSTAT	FC_ITEM	CHAR	10	0	Item for Goodwill Val.Allow.: Periodic Reduction, Stat.	TF100
44	GWRSTATOFFS	☐	FC_GWRSTATOFFS	FC_ITEM	CHAR	10	0	Offsetting Item: Goodwill Periodic Reduction, Statistical	TF100
45	GWDAQDI	☐	FC_GWDAQDI	FC_ITEM	CHAR	10	0	Item for the direct elimination of goodwill	TF100
46	GWDAQDT	☐	FC_GWDAQDT	FC_SITYP	CHAR	3	0	Subitem category for the direct elimination of goodwill	TF110
47	GWDAQDS	☐	FC_GWDAQDS	FC_SITEM	CHAR	10	0	Subitem for the direct elimination of goodwill	TF115
48	GWDOFFSDI	☐	FC_GWDOFFSDI	FC_ITEM	CHAR	10	0	Offset.Item, Goodwill Direct Elimination, Acquisition Cost	TF100
49	GWDOFFSDT	☐	FC_GWDOFFSDT	FC_SITYP	CHAR	3	0	Subitem Cat.: Offset.Entry, Goodwill Direct Elimination, APC	TF110
50	GWDOFFSDS	☐	FC_GWDOFFSDS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Goodwill Direct Elimination, Debit	TF115
51	GWDOFFSCS	☐	FC_GWDOFFSCS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Goodwill Direct Elimination, Credit	TF115
52	GWDSTAT	☐	FC_GWDSTAT	FC_ITEM	CHAR	10	0	Item for Goodwill Val.Allow.: Direct Elimination, Stat.	TF100
53	GWDSTATOFFS	☐	FC_GWDSTATOFFS	FC_ITEM	CHAR	10	0	Offsetting Item: Goodwill Direct Elimination, Statistical	TF100
54	NGAAQDI	☐	FC_NGAAQDI	FC_ITEM	CHAR	10	0	Item for acquisition cost of negative goodwill	TF100
55	NGAAQDT	☐	FC_NGAAQDT	FC_SITYP	CHAR	3	0	Subitem category for acquisition cost of negative goodwill	TF110
56	NGAAQDS	☐	FC_NGAAQDS	FC_SITEM	CHAR	10	0	Subitem for acquisition cost of negative goodwill	TF115
57	NGAAMCTPYS	☐	FC_NGAAMCTPYS	FC_SITEM	CHAR	10	0	Subitem: Neg. Goodwill Amort., C/T Diff. OC, Opening Balance	TF115
58	NGAAMCTCYS	☐	FC_NGAAMCTCYS	FC_SITEM	CHAR	10	0	Subitem: Neg. Goodwill Amort., C/T Diff. OC Current Year	TF115
59	NGAOFFSDI	☐	FC_NGAOFFSDI	FC_ITEM	CHAR	10	0	Offsetting Item: Negative Goodwill Amortization, Acq.Cost	TF100
60	NGAOFFSDT	☐	FC_NGAOFFSDT	FC_SITYP	CHAR	3	0	Subitem Categ.: Offset.Entry, Negative Goodwill Amort. APC	TF110
61	NGAOFFSDS	☐	FC_NGAOFFSDS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Negative Goodwill Amort. APC, Debit	TF115
62	NGAOFFSCS	☐	FC_NGAOFFSCS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Negative Goodwill Amort. APC, Credit	TF115
63	NGAAQCI	☐	FC_NGAAQCI	FC_ITEM	CHAR	10	0	Item for accumulated amortization of negative goodwill	TF100
64	NGAAQCT	☐	FC_NGAAQCT	FC_SITYP	CHAR	3	0	Subitem category for accum.amortization of negative goodwill	TF110
65	NGADPCS	☐	FC_NGADPCS	FC_SITEM	CHAR	10	0	Subitem for the amortization of negative goodwill	TF115
66	NGADPDS	☐	FC_NGADPDS	FC_SITEM	CHAR	10	0	Subitem for writeups of negative goodwill	TF115
67	NGADPCTPYS	☐	FC_NGADPCTPYS	FC_SITEM	CHAR	10	0	Subitem: Neg. Goodwill Amort., CTD Val.All., Opening Balance	TF115
68	NGADPCTCYS	☐	FC_NGADPCTCYS	FC_SITEM	CHAR	10	0	Subitem: Neg. Goodwill Amort., CTD Val.Allowance, Curr.Year	TF115
69	NGAAMDI	☐	FC_NGAAMDI	FC_ITEM	CHAR	10	0	Item for the amortization of negative goodwill	TF100
70	NGAAMDT	☐	FC_NGAAMDT	FC_SITYP	CHAR	3	0	Subitem category for amortization of negative goodwill	TF110
71	NGAAMDS	☐	FC_NGAAMDS	FC_SITEM	CHAR	10	0	Subitem for the amortization of negative goodwill	TF115
72	NGAAMCI	☐	FC_NGAAMCI	FC_ITEM	CHAR	10	0	Item for writeups of negative goodwill	TF100
73	NGAAMCT	☐	FC_NGAAMCT	FC_SITYP	CHAR	3	0	Subitem category for goodwill writeups	TF110
74	NGAAMCS	☐	FC_NGAAMCS	FC_SITEM	CHAR	10	0	Subitem for writeups of negative goodwill	TF115
75	NGASTAT	☐	FC_NGASTAT	FC_ITEM	CHAR	10	0	Item for Neg.Goodwill Val.Allow.: Amortization, Stat.	TF100
76	NGASTATCT	☐	FC_NGASTATCT	FC_ITEM	CHAR	10	0	Item: Negative Goodwill Amortization, C/T Diff, Statistical	TF100
77	NGASTATOFFS	☐	FC_NGASTATOFFS	FC_ITEM	CHAR	10	0	Offsetting Item: Negative Goodwill Amortization, Statistical	TF100
78	NGRAQDI	☐	FC_NGRAQDI	FC_ITEM	CHAR	10	0	B/S item for periodic reduction of negative GW	TF100
79	NGRAQDT	☐	FC_NGRAQDT	FC_SITYP	CHAR	3	0	Subitem cat. for B/S item for periodic reduction of neg. GW	TF110
80	NGRAQDS	☐	FC_NGRAQDS	FC_SITEM	CHAR	10	0	Subitem for periodic reduction of negative GW: acquisitions	TF115
81	NGRAQCS	☐	FC_NGRAQCS	FC_SITEM	CHAR	10	0	Subitem for periodic reduction of negative GW: divestiture	TF115
82	NGROFFSDI	☐	FC_NGROFFSDI	FC_ITEM	CHAR	10	0	Offsetting Item: Neg.Goodwill Periodic Reduction, Acq.Cost	TF100
83	NGROFFSDT	☐	FC_NGROFFSDT	FC_SITYP	CHAR	3	0	SI Cat.: Offset.Entry, Neg.Goodwill Periodic Reduct., APC	TF110
84	NGROFFSDS	☐	FC_NGROFFSDS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Debit	TF115
85	NGROFFSCS	☐	FC_NGROFFSCS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Credit	TF115
86	NGRAMDI	☐	FC_NGRAMDI	FC_ITEM	CHAR	10	0	Item for periodic reduction of negative GW: debits	TF100
87	NGRAMDT	☐	FC_NGRAMDT	FC_SITYP	CHAR	3	0	Subitem cat. for periodic reduction of negative GW: debits	TF110
88	NGRAMDS	☐	FC_NGRAMDS	FC_SITEM	CHAR	10	0	Subitem for periodic reduction of negative goodwill: debits	TF115
89	NGRAMCI	☐	FC_NGRAMCI	FC_ITEM	CHAR	10	0	Item for periodic reduction of negative goodwill: credit	TF100
90	NGRAMCT	☐	FC_NGRAMCT	FC_SITYP	CHAR	3	0	Subitem cat. for periodic reduction of negative GW: credits	TF110
91	NGRAMCS	☐	FC_NGRAMCS	FC_SITEM	CHAR	10	0	Subitem for periodic reduction of negative goodwill: credits	TF115
92	NGRSTAT	☐	FC_NGRSTAT	FC_ITEM	CHAR	10	0	Item for Neg.Goodwill Val.Allow.: Periodic Reduction, Stat.	TF100
93	NGRSTATOFFS	☐	FC_NGRSTATOFFS	FC_ITEM	CHAR	10	0	Offset.Item: Neg.Goodwill Periodic Reduction, Statistical	TF100
94	NGDAQCI	☐	FC_NGDAQCI	FC_ITEM	CHAR	10	0	Item for direct elimination of negative goodwill	TF100
95	NGDAQCT	☐	FC_NGDAQCT	FC_SITYP	CHAR	3	0	Subitem category for direct elimination of negative goodwill	TF110
96	NGDAQCS	☐	FC_NGDAQCS	FC_SITEM	CHAR	10	0	Subitem for the direct elimination of negative goodwill	TF115
97	NGDOFFSDI	☐	FC_NGDOFFSDI	FC_ITEM	CHAR	10	0	Offsetting Item: Neg.Goodwill Direct Elimination, Acq.Cost	TF100
98	NGDOFFSDT	☐	FC_NGDOFFSDT	FC_SITYP	CHAR	3	0	Subitem Cat.: Offset.Entry, Neg.Goodwill Direct Elim., APC	TF110
99	NGDOFFSDS	☐	FC_NGDOFFSDS	FC_SITEM	CHAR	10	0	Subitem: Offsetting Entry, Neg.Goodwill Direct Elim., Debit	TF115
100	NGDOFFSCS	☐	FC_NGDOFFSCS	FC_SITEM	CHAR	10	0	Subitem: Offset.Entry, Neg.Goodwill Direct Elim., Credit	TF115
101	NGDSTAT	☐	FC_NGDSTAT	FC_ITEM	CHAR	10	0	Item for Neg.Goodwill Val.Allow.: Direct Elimination, Stat.	TF100
102	NGDSTATOFFS	☐	FC_NGDSTATOFFS	FC_ITEM	CHAR	10	0	Offsetting Item: Neg.Goodwill Direct Elim., Statistical	TF100

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TF692	DIMEN	TF150	DIMEN	KEY	1	CN
2	TF692	GWAAMCI	TF100	ITEM
3	TF692	GWAAMCS	TF115	SITEM
4	TF692	GWAAMCT	TF110	SITYP
5	TF692	GWAAMDI	TF100	ITEM
6	TF692	GWAAMDS	TF115	SITEM
7	TF692	GWAAMDT	TF110	SITYP
8	TF692	GWAAQCI	TF100	ITEM
9	TF692	GWAAQCT	TF110	SITYP
10	TF692	GWAAQCTCYS	TF115	SITEM
11	TF692	GWAAQCTPYS	TF115	SITEM
12	TF692	GWAAQDI	TF100	ITEM
13	TF692	GWAAQDS	TF115	SITEM
14	TF692	GWAAQDT	TF110	SITYP
15	TF692	GWADPCS	TF115	SITEM
16	TF692	GWADPCTCYS	TF115	SITEM
17	TF692	GWADPCTPYS	TF115	SITEM
18	TF692	GWADPDS	TF115	SITEM
19	TF692	GWAOFFSCS	TF115	SITEM
20	TF692	GWAOFFSDI	TF100	ITEM
21	TF692	GWAOFFSDS	TF115	SITEM
22	TF692	GWAOFFSDT	TF110	SITYP
23	TF692	GWASTAT	TF100	ITEM
24	TF692	GWASTATCT	TF100	ITEM
25	TF692	GWASTATOFFS	TF100	ITEM
26	TF692	GWDAQDI	TF100	ITEM
27	TF692	GWDAQDS	TF115	SITEM
28	TF692	GWDAQDT	TF110	SITYP
29	TF692	GWDOFFSCS	TF115	SITEM
30	TF692	GWDOFFSDI	TF100	ITEM
31	TF692	GWDOFFSDS	TF115	SITEM
32	TF692	GWDOFFSDT	TF110	SITYP
33	TF692	GWDSTAT	TF100	ITEM
34	TF692	GWDSTATOFFS	TF100	ITEM
35	TF692	GWRAMCI	TF100	ITEM
36	TF692	GWRAMCS	TF115	SITEM
37	TF692	GWRAMCT	TF110	SITYP
38	TF692	GWRAMDI	TF100	ITEM
39	TF692	GWRAMDS	TF115	SITEM
40	TF692	GWRAMDT	TF110	SITYP
41	TF692	GWRAQCS	TF115	SITEM
42	TF692	GWRAQDI	TF100	ITEM
43	TF692	GWRAQDS	TF115	SITEM
44	TF692	GWRAQDT	TF110	SITYP
45	TF692	GWROFFSCS	TF115	SITEM
46	TF692	GWROFFSDI	TF100	ITEM
47	TF692	GWROFFSDS	TF115	SITEM
48	TF692	GWROFFSDT	TF110	SITYP
49	TF692	GWRSTAT	TF100	ITEM
50	TF692	GWRSTATOFFS	TF100	ITEM
51	TF692	ITCLG	TF120	ITCLG	KEY	1	CN
52	TF692	MANDT	T000	MANDT	KEY	1	CN
53	TF692	NGAAMCI	TF100	ITEM
54	TF692	NGAAMCS	TF115	SITEM
55	TF692	NGAAMCT	TF110	SITYP
56	TF692	NGAAMCTCYS	TF115	SITEM
57	TF692	NGAAMCTPYS	TF115	SITEM
58	TF692	NGAAMDI	TF100	ITEM
59	TF692	NGAAMDS	TF115	SITEM
60	TF692	NGAAMDT	TF110	SITYP
61	TF692	NGAAQCI	TF100	ITEM
62	TF692	NGAAQCT	TF110	SITYP
63	TF692	NGAAQDI	TF100	ITEM
64	TF692	NGAAQDS	TF115	SITEM
65	TF692	NGAAQDT	TF110	SITYP
66	TF692	NGADPCS	TF115	SITEM
67	TF692	NGADPCTCYS	TF115	SITEM
68	TF692	NGADPCTPYS	TF115	SITEM
69	TF692	NGADPDS	TF115	SITEM
70	TF692	NGAOFFSCS	TF115	SITEM
71	TF692	NGAOFFSDI	TF100	ITEM
72	TF692	NGAOFFSDS	TF115	SITEM
73	TF692	NGAOFFSDT	TF110	SITYP
74	TF692	NGASTAT	TF100	ITEM
75	TF692	NGASTATCT	TF100	ITEM
76	TF692	NGASTATOFFS	TF100	ITEM
77	TF692	NGDAQCI	TF100	ITEM
78	TF692	NGDAQCS	TF115	SITEM
79	TF692	NGDAQCT	TF110	SITYP
80	TF692	NGDOFFSCS	TF115	SITEM
81	TF692	NGDOFFSDI	TF100	ITEM
82	TF692	NGDOFFSDS	TF115	SITEM
83	TF692	NGDOFFSDT	TF110	SITYP
84	TF692	NGDSTAT	TF100	ITEM
85	TF692	NGDSTATOFFS	TF100	ITEM
86	TF692	NGRAMCI	TF100	ITEM
87	TF692	NGRAMCS	TF115	SITEM
88	TF692	NGRAMCT	TF110	SITYP
89	TF692	NGRAMDI	TF100	ITEM
90	TF692	NGRAMDS	TF115	SITEM
91	TF692	NGRAMDT	TF110	SITYP
92	TF692	NGRAQCS	TF115	SITEM
93	TF692	NGRAQDI	TF100	ITEM
94	TF692	NGRAQDS	TF115	SITEM
95	TF692	NGRAQDT	TF110	SITYP
96	TF692	NGROFFSCS	TF115	SITEM
97	TF692	NGROFFSDI	TF100	ITEM
98	TF692	NGROFFSDS	TF115	SITEM
99	TF692	NGROFFSDT	TF110	SITYP
100	TF692	NGRSTAT	TF100	ITEM
101	TF692	NGRSTATOFFS	TF100	ITEM

History

Last changed by/on	SAP	20091125
SAP Release Created in