Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

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

Dictionary Type: Table
Description: Global Chart of Accounts-Based Settings for C/I

ABAP Code to SELECT data from TF692
Related tables to TF692
Access table TF692

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Table field list including key, data, relationships and ABAP select examples

TF692 is a standard SAP Table which is used to store Global Chart of Accounts-Based Settings for C/I data and is available within R/3 SAP systems depending on the version and release level.

The TF692 table consists of various fields, each holding specific information or linking keys about Global Chart of Accounts-Based Settings for C/I data available in SAP. These include DIMEN (Dimension), ITCLG (Consolidation chart of accounts), GWAAQDI (Item for the acquisition cost of goodwill), GWAAQDT (Subitem category for the acquisition cost of goodwill).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP TF692 table fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
DIMEN	Dimension	FC_DIMEN	CHAR	2	TF150		FC_DIMEN	DIN	FC_DIMEN
ITCLG	Consolidation chart of accounts	FC_ITCLG	CHAR	2	TF120		FC_ITCLG	ITC	FC_ITCLG
GWAAQDI	Item for the acquisition cost of goodwill	FC_GWAAQDI	CHAR	10	TF100	BFIMC	FC_ITEM
GWAAQDT	Subitem category for the acquisition cost of goodwill	FC_GWAAQDT	CHAR	3	TF110		FC_SITYP
GWAAQDS	Subitem for the acquisition cost of goodwill	FC_GWAAQDS	CHAR	10	TF115		FC_SITEM
GWAAQCTPYS	Subitem Goodwill Amortization CTD Orig.Cost, Opening Balance	FC_GWAAQCTPYS	CHAR	10	TF115		FC_SITEM
GWAAQCTCYS	Subitem Goodwill Amortization CTD Orig.Cost, Current Year	FC_GWAAQCTCYS	CHAR	10	TF115		FC_SITEM
GWAOFFSDI	Offsetting Item, Goodwill Amortization, Acquisition Cost	FC_GWAOFFSDI	CHAR	10	TF100	BFIMC	FC_ITEM
GWAOFFSDT	Subitem Categ.: Offsetting Entry, Goodwill Amort., Acq.Cost	FC_GWAOFFSDT	CHAR	3	TF110		FC_SITYP
GWAOFFSDS	Subitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Debit	FC_GWAOFFSDS	CHAR	10	TF115		FC_SITEM
GWAOFFSCS	Subitem: Offsetting Entry, Goodwill Amort., Acq.Cost, Credit	FC_GWAOFFSCS	CHAR	10	TF115		FC_SITEM
GWAAQCI	Item for the accumulated amortization of goodwill	FC_GWAAQCI	CHAR	10	TF100	BFIMC	FC_ITEM
GWAAQCT	Subitem category for accumulated amortization of goodwill	FC_GWAAQCT	CHAR	3	TF110		FC_SITYP
GWADPCS	Subitem for the amortization of goodwill	FC_GWADPCS	CHAR	10	TF115		FC_SITEM
GWADPDS	Subitem for writeups of goodwill	FC_GWADPDS	CHAR	10	TF115		FC_SITEM
GWADPCTPYS	Subitem Goodwill Amortization CTD Val.Allow., Opening Bal.	FC_GWADPCTPYS	CHAR	10	TF115		FC_SITEM
GWADPCTCYS	Subitem Goodwill Amortization CTD Val.Allow., Current Year	FC_GWADPCTCYS	CHAR	10	TF115		FC_SITEM
GWAAMDI	Item for the amortization of goodwill	FC_GWAAMDI	CHAR	10	TF100	BFIMC	FC_ITEM
GWAAMDT	Subitem category for the amortization of goodwill	FC_GWAAMDT	CHAR	3	TF110		FC_SITYP
GWAAMDS	Subitem for the amortization of goodwill	FC_GWAAMDS	CHAR	10	TF115		FC_SITEM
GWAAMCI	Item for goodwill writeups	FC_GWAAMCI	CHAR	10	TF100	BFIMC	FC_ITEM
GWAAMCT	Subitem category for goodwill writeups	FC_GWAAMCT	CHAR	3	TF110		FC_SITYP
GWAAMCS	Subitem for writeups of goodwill	FC_GWAAMCS	CHAR	10	TF115		FC_SITEM
GWASTAT	Item for Goodwill Val.Allowances: Amortization, Statistical	FC_GWASTAT	CHAR	10	TF100	BFIMC	FC_ITEM
GWASTATCT	Item Goodwill Amortization CTD, Statistical	FC_GWASTATCT	CHAR	10	TF100	BFIMC	FC_ITEM
GWASTATOFFS	Offsetting Item, Goodwill Amortization, Statistical	FC_GWASTATOFFS	CHAR	10	TF100	BFIMC	FC_ITEM
GWRAQDI	Bal.sheet item: periodic reduction of goodwill	FC_GWRAQDI	CHAR	10	TF100	BFIMC	FC_ITEM
GWRAQDT	Subitem category for B/S item for periodic reduction of GW	FC_GWRAQDT	CHAR	3	TF110		FC_SITYP
GWRAQDS	Subitem for periodic reduction of goodwill - acquisition	FC_GWRAQDS	CHAR	10	TF115		FC_SITEM
GWRAQCS	Subitem for periodic reduction of goodwill - divestiture	FC_GWRAQCS	CHAR	10	TF115		FC_SITEM
GWROFFSDI	Offset.Item: Goodwill Periodic Reduction, Acquisition Cost	FC_GWROFFSDI	CHAR	10	TF100	BFIMC	FC_ITEM
GWROFFSDT	Subitem Cat.: Offset.Entry, Goodwill Periodic Reduction, APC	FC_GWROFFSDT	CHAR	3	TF110		FC_SITYP
GWROFFSDS	Subitem: Offset.Entry, Goodwill Periodic Reduction, Debit	FC_GWROFFSDS	CHAR	10	TF115		FC_SITEM
GWROFFSCS	Subitem: Offset.Entry, Goodwill Periodic Reduction, Credit	FC_GWROFFSCS	CHAR	10	TF115		FC_SITEM
GWRAMDI	Item for periodic reduction of goodwill: debits	FC_GWRAMDI	CHAR	10	TF100	BFIMC	FC_ITEM
GWRAMDT	Subitem category for periodic reduction of goodwill: debits	FC_GWRAMDT	CHAR	3	TF110		FC_SITYP
GWRAMDS	Subitem for periodic reduction of goodwill: debits	FC_GWRAMDS	CHAR	10	TF115		FC_SITEM
GWRAMCI	Item for periodic reduction of goodwill: credits	FC_GWRAMCI	CHAR	10	TF100	BFIMC	FC_ITEM
GWRAMCT	Subitem category for periodic reduction of goodwill: credits	FC_GWRAMCT	CHAR	3	TF110		FC_SITYP
GWRAMCS	Subitem for periodic reduction of goodwill: credits	FC_GWRAMCS	CHAR	10	TF115		FC_SITEM
GWRSTAT	Item for Goodwill Val.Allow.: Periodic Reduction, Stat.	FC_GWRSTAT	CHAR	10	TF100	BFIMC	FC_ITEM
GWRSTATOFFS	Offsetting Item: Goodwill Periodic Reduction, Statistical	FC_GWRSTATOFFS	CHAR	10	TF100	BFIMC	FC_ITEM
GWDAQDI	Item for the direct elimination of goodwill	FC_GWDAQDI	CHAR	10	TF100	BFIMC	FC_ITEM
GWDAQDT	Subitem category for the direct elimination of goodwill	FC_GWDAQDT	CHAR	3	TF110		FC_SITYP
GWDAQDS	Subitem for the direct elimination of goodwill	FC_GWDAQDS	CHAR	10	TF115		FC_SITEM
GWDOFFSDI	Offset.Item, Goodwill Direct Elimination, Acquisition Cost	FC_GWDOFFSDI	CHAR	10	TF100	BFIMC	FC_ITEM
GWDOFFSDT	Subitem Cat.: Offset.Entry, Goodwill Direct Elimination, APC	FC_GWDOFFSDT	CHAR	3	TF110		FC_SITYP
GWDOFFSDS	Subitem: Offset.Entry, Goodwill Direct Elimination, Debit	FC_GWDOFFSDS	CHAR	10	TF115		FC_SITEM
GWDOFFSCS	Subitem: Offset.Entry, Goodwill Direct Elimination, Credit	FC_GWDOFFSCS	CHAR	10	TF115		FC_SITEM
GWDSTAT	Item for Goodwill Val.Allow.: Direct Elimination, Stat.	FC_GWDSTAT	CHAR	10	TF100	BFIMC	FC_ITEM
GWDSTATOFFS	Offsetting Item: Goodwill Direct Elimination, Statistical	FC_GWDSTATOFFS	CHAR	10	TF100	BFIMC	FC_ITEM
NGAAQDI	Item for acquisition cost of negative goodwill	FC_NGAAQDI	CHAR	10	TF100	BFIMC	FC_ITEM
NGAAQDT	Subitem category for acquisition cost of negative goodwill	FC_NGAAQDT	CHAR	3	TF110		FC_SITYP
NGAAQDS	Subitem for acquisition cost of negative goodwill	FC_NGAAQDS	CHAR	10	TF115		FC_SITEM
NGAAMCTPYS	Subitem: Neg. Goodwill Amort., C/T Diff. OC, Opening Balance	FC_NGAAMCTPYS	CHAR	10	TF115		FC_SITEM
NGAAMCTCYS	Subitem: Neg. Goodwill Amort., C/T Diff. OC Current Year	FC_NGAAMCTCYS	CHAR	10	TF115		FC_SITEM
NGAOFFSDI	Offsetting Item: Negative Goodwill Amortization, Acq.Cost	FC_NGAOFFSDI	CHAR	10	TF100	BFIMC	FC_ITEM
NGAOFFSDT	Subitem Categ.: Offset.Entry, Negative Goodwill Amort. APC	FC_NGAOFFSDT	CHAR	3	TF110		FC_SITYP
NGAOFFSDS	Subitem: Offset.Entry, Negative Goodwill Amort. APC, Debit	FC_NGAOFFSDS	CHAR	10	TF115		FC_SITEM
NGAOFFSCS	Subitem: Offset.Entry, Negative Goodwill Amort. APC, Credit	FC_NGAOFFSCS	CHAR	10	TF115		FC_SITEM
NGAAQCI	Item for accumulated amortization of negative goodwill	FC_NGAAQCI	CHAR	10	TF100	BFIMC	FC_ITEM
NGAAQCT	Subitem category for accum.amortization of negative goodwill	FC_NGAAQCT	CHAR	3	TF110		FC_SITYP
NGADPCS	Subitem for the amortization of negative goodwill	FC_NGADPCS	CHAR	10	TF115		FC_SITEM
NGADPDS	Subitem for writeups of negative goodwill	FC_NGADPDS	CHAR	10	TF115		FC_SITEM
NGADPCTPYS	Subitem: Neg. Goodwill Amort., CTD Val.All., Opening Balance	FC_NGADPCTPYS	CHAR	10	TF115		FC_SITEM
NGADPCTCYS	Subitem: Neg. Goodwill Amort., CTD Val.Allowance, Curr.Year	FC_NGADPCTCYS	CHAR	10	TF115		FC_SITEM
NGAAMDI	Item for the amortization of negative goodwill	FC_NGAAMDI	CHAR	10	TF100	BFIMC	FC_ITEM
NGAAMDT	Subitem category for amortization of negative goodwill	FC_NGAAMDT	CHAR	3	TF110		FC_SITYP
NGAAMDS	Subitem for the amortization of negative goodwill	FC_NGAAMDS	CHAR	10	TF115		FC_SITEM
NGAAMCI	Item for writeups of negative goodwill	FC_NGAAMCI	CHAR	10	TF100	BFIMC	FC_ITEM
NGAAMCT	Subitem category for goodwill writeups	FC_NGAAMCT	CHAR	3	TF110		FC_SITYP
NGAAMCS	Subitem for writeups of negative goodwill	FC_NGAAMCS	CHAR	10	TF115		FC_SITEM
NGASTAT	Item for Neg.Goodwill Val.Allow.: Amortization, Stat.	FC_NGASTAT	CHAR	10	TF100	BFIMC	FC_ITEM
NGASTATCT	Item: Negative Goodwill Amortization, C/T Diff, Statistical	FC_NGASTATCT	CHAR	10	TF100	BFIMC	FC_ITEM
NGASTATOFFS	Offsetting Item: Negative Goodwill Amortization, Statistical	FC_NGASTATOFFS	CHAR	10	TF100	BFIMC	FC_ITEM
NGRAQDI	B/S item for periodic reduction of negative GW	FC_NGRAQDI	CHAR	10	TF100	BFIMC	FC_ITEM
NGRAQDT	Subitem cat. for B/S item for periodic reduction of neg. GW	FC_NGRAQDT	CHAR	3	TF110		FC_SITYP
NGRAQDS	Subitem for periodic reduction of negative GW: acquisitions	FC_NGRAQDS	CHAR	10	TF115		FC_SITEM
NGRAQCS	Subitem for periodic reduction of negative GW: divestiture	FC_NGRAQCS	CHAR	10	TF115		FC_SITEM
NGROFFSDI	Offsetting Item: Neg.Goodwill Periodic Reduction, Acq.Cost	FC_NGROFFSDI	CHAR	10	TF100	BFIMC	FC_ITEM
NGROFFSDT	SI Cat.: Offset.Entry, Neg.Goodwill Periodic Reduct., APC	FC_NGROFFSDT	CHAR	3	TF110		FC_SITYP
NGROFFSDS	Subitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Debit	FC_NGROFFSDS	CHAR	10	TF115		FC_SITEM
NGROFFSCS	Subitem: Offset.Entry, Neg.Goodwill Periodic Reduct., Credit	FC_NGROFFSCS	CHAR	10	TF115		FC_SITEM
NGRAMDI	Item for periodic reduction of negative GW: debits	FC_NGRAMDI	CHAR	10	TF100	BFIMC	FC_ITEM
NGRAMDT	Subitem cat. for periodic reduction of negative GW: debits	FC_NGRAMDT	CHAR	3	TF110		FC_SITYP
NGRAMDS	Subitem for periodic reduction of negative goodwill: debits	FC_NGRAMDS	CHAR	10	TF115		FC_SITEM
NGRAMCI	Item for periodic reduction of negative goodwill: credit	FC_NGRAMCI	CHAR	10	TF100	BFIMC	FC_ITEM
NGRAMCT	Subitem cat. for periodic reduction of negative GW: credits	FC_NGRAMCT	CHAR	3	TF110		FC_SITYP
NGRAMCS	Subitem for periodic reduction of negative goodwill: credits	FC_NGRAMCS	CHAR	10	TF115		FC_SITEM
NGRSTAT	Item for Neg.Goodwill Val.Allow.: Periodic Reduction, Stat.	FC_NGRSTAT	CHAR	10	TF100	BFIMC	FC_ITEM
NGRSTATOFFS	Offset.Item: Neg.Goodwill Periodic Reduction, Statistical	FC_NGRSTATOFFS	CHAR	10	TF100	BFIMC	FC_ITEM
NGDAQCI	Item for direct elimination of negative goodwill	FC_NGDAQCI	CHAR	10	TF100	BFIMC	FC_ITEM
NGDAQCT	Subitem category for direct elimination of negative goodwill	FC_NGDAQCT	CHAR	3	TF110		FC_SITYP
NGDAQCS	Subitem for the direct elimination of negative goodwill	FC_NGDAQCS	CHAR	10	TF115		FC_SITEM
NGDOFFSDI	Offsetting Item: Neg.Goodwill Direct Elimination, Acq.Cost	FC_NGDOFFSDI	CHAR	10	TF100	BFIMC	FC_ITEM
NGDOFFSDT	Subitem Cat.: Offset.Entry, Neg.Goodwill Direct Elim., APC	FC_NGDOFFSDT	CHAR	3	TF110		FC_SITYP
NGDOFFSDS	Subitem: Offsetting Entry, Neg.Goodwill Direct Elim., Debit	FC_NGDOFFSDS	CHAR	10	TF115		FC_SITEM
NGDOFFSCS	Subitem: Offset.Entry, Neg.Goodwill Direct Elim., Credit	FC_NGDOFFSCS	CHAR	10	TF115		FC_SITEM
NGDSTAT	Item for Neg.Goodwill Val.Allow.: Direct Elimination, Stat.	FC_NGDSTAT	CHAR	10	TF100	BFIMC	FC_ITEM
NGDSTATOFFS	Offsetting Item: Neg.Goodwill Direct Elim., Statistical	FC_NGDSTATOFFS	CHAR	10	TF100	BFIMC	FC_ITEM

Key field

Non-key field

How do I retrieve data from SAP table TF692 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TF692 to SELECT all data from the table
DATA: WA_TF692 TYPE TF692.

SELECT SINGLE *
FROM TF692
INTO CORRESPONDING FIELDS OF WA_TF692
WHERE...

How to access SAP table TF692

Within an ECC or HANA version of SAP you can also view further information about TF692 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!