TF600 SAP (Consolidation of Investments Methods) Table details
Dictionary Type: Table
Description: Consolidation of Investments Methods
Description: Consolidation of Investments Methods
Table field list including key, data, relationships and ABAP select examples
TF600 is a standard SAP Table which is used to store Consolidation of Investments Methods data and is available within R/3 SAP systems depending on the version and release level.
The TF600 table consists of various fields, each holding specific information or linking keys about Consolidation of Investments Methods data available in SAP. These include DIMEN (Dimension), COIMETH (Method), COITP (Accounting technique for the consolidation of investments), USGAAP (Calculate acquisitions with direct shares/group shares).. 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 custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP TF600 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 | |
| COIMETH | Method | FC_CMETH | CHAR | 5 | TF550 | FC_CMETH | |||
| COITP | Accounting technique for the consolidation of investments | FC_COITP | CHAR | 1 | FC_COITP | ||||
| USGAAP | Calculate acquisitions with direct shares/group shares | FC_USGAAP | CHAR | 1 | FC_USGAAP | ||||
| GWPROC | Treatment of Goodwill | FC_GWPROC | CHAR | 1 | FC_GWPROC | ||||
| NGPROC | Treatment of negative goodwill | FC_NGPROC | CHAR | 1 | FC_GWPROC | ||||
| GWLCFLG | Carry Goodwill in Local Currency | FC_GWLCFLG | CHAR | 1 | X | ||||
| GWIEFLG | Post Goodwill at Investee Unit | FC_GWIEFLG | CHAR | 1 | X | ||||
| HIREXC | Exception for fair value adjustments | FC_HIREXC | CHAR | 1 | X | ||||
| GWNEXC | Exception Goodwill Extraordinary Amortization | FC_GWNEXC | CHAR | 1 | X | ||||
| GWAEXC | Exception Goodwill Ordinary Amortization | FC_GWAEXC | CHAR | 1 | X | ||||
| GWDEXC | Exception for direct elimination of goodwill | FC_GWDEXC | CHAR | 1 | X | ||||
| GWREXC | Exception for periodic reduction of goodwill | FC_GWREXC | CHAR | 1 | X | ||||
| NGNEXC | Exception Negative Goodwill Extraordinary Amortization | FC_NGNEXC | CHAR | 1 | X | ||||
| NGAEXC | Exception Negative Goodwill Ordinary Amortization | FC_NGAEXC | CHAR | 1 | X | ||||
| NGDEXC | Exception for direct elimination of negative goodwill | FC_NGDEXC | CHAR | 1 | X | ||||
| NGREXC | Exception for periodic reduction of negative goodwill | FC_NGREXC | CHAR | 1 | X | ||||
| NEQEXC | Exception for Negative Stockholders' Equity | FC_NEQEXC | CHAR | 1 | X | ||||
| NINVFLG | Enable negative investments | FC_NINVFLG | CHAR | 1 | X | ||||
| NMINFLG | No calculation of minority interest | FC_NMINFLG | CHAR | 1 | X | ||||
| HRREV | Procedure for eliminating hidden reserves/contingencies(FVA) | FC_HRREV | CHAR | 1 | FC_HRREV | ||||
| HRSHA | Scope of elimination of hidden reserves/contingencies | FC_HRSHA | CHAR | 1 | FC_HRSHA | ||||
| HRSITYP | Subitem category for hidden reserves (fair value adjustment) | FC_HRSITYP | CHAR | 3 | TF110 | FC_SITYP | |||
| HRAQDSI | Subitem for transferring hidden reserves (fair value adj.) | FC_HRAQDSI | CHAR | 10 | TF115 | FC_SITEM | |||
| HRDPCSI | Subitem for amortization of hidden reserves (fair value adj) | FC_HRDPCSI | CHAR | 10 | TF115 | FC_SITEM | |||
| HRDPDSI | Subitem for writeups of hidden reserves (fair value adj.) | FC_HRDPDSI | CHAR | 10 | TF115 | FC_SITEM | |||
| NHSITYP | Subitem category for hidden contingencies (fair value adj.) | FC_NHSITYP | CHAR | 3 | TF110 | FC_SITYP | |||
| NHAQCSI | Subitem for transferring hidden contingencies (fair val.adj) | FC_NHAQCSI | CHAR | 10 | TF115 | FC_SITEM | |||
| NHDPDSI | Subitem for changes to hidden contingencies - debit | FC_NHDPDSI | CHAR | 10 | TF115 | FC_SITEM | |||
| NHDPCSI | Subitem for changes to hidden contingencies - credit | FC_NHDPCSI | CHAR | 10 | TF115 | FC_SITEM | |||
| GWAYR | Life of goodwill amortization in years | FC_GWAYR | NUMC | 2 | NUMC2 | ||||
| GWAPE | Life of goodwill amortization in months | FC_GWAPE | NUMC | 3 | NUMC3 | ||||
| GWABG | Start date for the amortization of new goodwill | FC_GWABG | CHAR | 1 | FC_DGWBG | ||||
| GWARFLG | Amortize new goodwill over remaining life | FC_GWARFLG | CHAR | 1 | X | ||||
| GWALFLG | Threshold value for the amortization of goodwill | FC_GWALFLG | CHAR | 1 | X | ||||
| GWALVAL | Threshold value for the amortization of goodwill | FC_GWALVAL | CURR | 17(2) | WERTV9 | ||||
| GWALCUR | Group currency for threshold for goodwill amortization | FC_GWALCUR | CUKY | 5 | TCURC | WAERS | |||
| GWAMETH | Amortization method | FC_DEPMETH | NUMC | 1 | FC_DEPMETH | ||||
| GWRYR | Life of the periodic reduction of goodwill - years | FC_GWRYR | NUMC | 2 | NUMC2 | ||||
| GWRPE | Life of periodic reduction of goodwill - months | FC_GWRPE | NUMC | 3 | NUMC3 | ||||
| GWRBG | Beginning date of the periodic reduction of new goodwill | FC_GWRBG | CHAR | 1 | FC_DGWBG | ||||
| GWRRFLG | Reduce the new goodwill over its remaining life | FC_GWRRFLG | CHAR | 1 | X | ||||
| GWRLFLG | Threshold value for the periodic reduction of goodwill | FC_GWRLFLG | CHAR | 1 | X | ||||
| GWRLVAL | Threshold value for the periodic reduction of goodwill | FC_GWRLVAL | CURR | 17(2) | WERTV9 | ||||
| GWRLCUR | Group currency for threshold for periodic reduction of GW | FC_GWRLCUR | CUKY | 5 | TCURC | WAERS | |||
| GWRMETH | Amortization method | FC_DEPMETH | NUMC | 1 | FC_DEPMETH | ||||
| NGAYR | Life of amortization of negative goodwill in years | FC_NGAYR | NUMC | 2 | NUMC2 | ||||
| NGAPE | Life of amortization of negative goodwill in months | FC_NGAPE | NUMC | 3 | NUMC3 | ||||
| NGABG | Beginning date of amortization of new negative goodwill | FC_NGABG | CHAR | 1 | FC_DGWBG | ||||
| NGARFLG | Amortization of new negative goodwill over remain. life | FC_NGARFLG | CHAR | 1 | X | ||||
| NGALFLG | Threshold for amortization of negative goodwill | FC_NGALFLG | CHAR | 1 | X | ||||
| NGALVAL | Threshold for amortization of negative goodwill | FC_NGALVAL | CURR | 17(2) | WERTV9 | ||||
| NGALCUR | Group currency f. threshold of neg. goodwill amortization | FC_NGALCUR | CUKY | 5 | TCURC | WAERS | |||
| NGAMETH | Amortization method | FC_DEPMETH | NUMC | 1 | FC_DEPMETH | ||||
| NGRYR | Life of periodic reduction of negative goodwill - years | FC_NGRYR | NUMC | 2 | NUMC2 | ||||
| NGRPE | Life of periodic reduction of negative goodwill - months | FC_NGRPE | NUMC | 3 | NUMC3 | ||||
| NGRBG | Beginning date of the reduction of new negative goodwill | FC_NGRBG | CHAR | 1 | FC_DGWBG | ||||
| NGRRFLG | Reduce new negative goodwill over its remaining life | FC_NGRRFLG | CHAR | 1 | X | ||||
| NGRLFLG | Threshold for periodic reduction of negative goodwill | FC_NGRLFLG | CHAR | 1 | X | ||||
| NGRLVAL | Threshold for periodic reduction of negative goodwill | FC_NGRLVAL | CURR | 17(2) | WERTV9 | ||||
| NGRLCUR | Group currency of threshold for periodic reduction of neg.GW | FC_NGRLCUR | CUKY | 5 | TCURC | WAERS | |||
| NGRMETH | Amortization method | FC_DEPMETH | NUMC | 1 | FC_DEPMETH |
| Key field | Non-key field |
How do I retrieve data from SAP table TF600 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TF600 to SELECT all data from the tableDATA: WA_TF600 TYPE TF600.
SELECT SINGLE *
FROM TF600
INTO CORRESPONDING FIELDS OF WA_TF600
WHERE...
How to access SAP table TF600
Within an ECC or HANA version of SAP you can also view further information about TF600 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects