1. Home
  2. Resources
  3. SAP Tables
  4. TF600 - Consolidation of Investments Methods

SAP Table TF600

Consolidation of Investments Methods

TF600 (Consolidation of Investments Methods) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TF600 to other SAP tables.

TF600 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DIMEN Dimension FC_DIMEN TF150 CHAR 2 0
COIMETH Method FC_CMETH TF550 CHAR 5 0
COITP Accounting technique for the consolidation of investments FC_COITP CHAR 1 0
USGAAP Calculate acquisitions with direct shares/group shares FC_USGAAP CHAR 1 0
NULL Group shares
X Direct shares
GWPROC Treatment of Goodwill FC_GWPROC CHAR 1 0
4 Extraordinary amortization
1 Ordinary amortization
2 Direct elimination
3 Periodic reduction
NGPROC Treatment of negative goodwill FC_NGPROC CHAR 1 0
4 Extraordinary amortization
1 Ordinary amortization
2 Direct elimination
3 Periodic reduction
GWLCFLG Carry Goodwill in Local Currency FC_GWLCFLG CHAR 1 0
X Yes
NULL No
GWIEFLG Post Goodwill at Investee Unit FC_GWIEFLG CHAR 1 0
X Yes
NULL No
HIREXC Exception for fair value adjustments FC_HIREXC CHAR 1 0
X Yes
NULL No
GWNEXC Exception Goodwill Extraordinary Amortization FC_GWNEXC CHAR 1 0
X Yes
NULL No
GWAEXC Exception Goodwill Ordinary Amortization FC_GWAEXC CHAR 1 0
X Yes
NULL No
GWDEXC Exception for direct elimination of goodwill FC_GWDEXC CHAR 1 0
X Yes
NULL No
GWREXC Exception for periodic reduction of goodwill FC_GWREXC CHAR 1 0
X Yes
NULL No
NGNEXC Exception Negative Goodwill Extraordinary Amortization FC_NGNEXC CHAR 1 0
X Yes
NULL No
NGAEXC Exception Negative Goodwill Ordinary Amortization FC_NGAEXC CHAR 1 0
X Yes
NULL No
NGDEXC Exception for direct elimination of negative goodwill FC_NGDEXC CHAR 1 0
X Yes
NULL No
NGREXC Exception for periodic reduction of negative goodwill FC_NGREXC CHAR 1 0
X Yes
NULL No
NEQEXC Exception for Negative Stockholders' Equity FC_NEQEXC CHAR 1 0
X Yes
NULL No
NINVFLG Enable negative investments FC_NINVFLG CHAR 1 0
X Yes
NULL No
NMINFLG No calculation of minority interest FC_NMINFLG CHAR 1 0
X Yes
NULL No
HRREV Procedure for eliminating hidden reserves/contingencies(FVA) FC_HRREV CHAR 1 0
0 No elimination
1 Proportional elimination
2 Up to differential by priority
3 Complete
HRSHA Scope of elimination of hidden reserves/contingencies FC_HRSHA CHAR 1 0
1 Group share
2 Group and minority share
HRSITYP Subitem category for hidden reserves (fair value adjustment) FC_HRSITYP TF110 CHAR 3 0
HRAQDSI Subitem for transferring hidden reserves (fair value adj.) FC_HRAQDSI TF115 CHAR 10 0
HRDPCSI Subitem for amortization of hidden reserves (fair value adj) FC_HRDPCSI TF115 CHAR 10 0
HRDPDSI Subitem for writeups of hidden reserves (fair value adj.) FC_HRDPDSI TF115 CHAR 10 0
NHSITYP Subitem category for hidden contingencies (fair value adj.) FC_NHSITYP TF110 CHAR 3 0
NHAQCSI Subitem for transferring hidden contingencies (fair val.adj) FC_NHAQCSI TF115 CHAR 10 0
NHDPDSI Subitem for changes to hidden contingencies - debit FC_NHDPDSI TF115 CHAR 10 0
NHDPCSI Subitem for changes to hidden contingencies - credit FC_NHDPCSI TF115 CHAR 10 0
GWAYR Life of goodwill amortization in years FC_GWAYR NUMC 2 0
GWAPE Life of goodwill amortization in months FC_GWAPE NUMC 3 0
GWABG Start date for the amortization of new goodwill FC_GWABG CHAR 1 0
1 Start of current year
2 Start of current range of periods
3 Start of current period
4 Start of following period
5 Beginning of following range of periods
6 Start of following year
GWARFLG Amortize new goodwill over remaining life FC_GWARFLG CHAR 1 0
X Yes
NULL No
GWALFLG Threshold value for the amortization of goodwill FC_GWALFLG CHAR 1 0
X Yes
NULL No
GWALVAL Threshold value for the amortization of goodwill FC_GWALVAL CURR 17 2
GWALCUR Group currency for threshold for goodwill amortization FC_GWALCUR TCURC CUKY 5 0
GWAMETH Amortization method FC_DEPMETH NUMC 1 0
0 No depreciation/amortization
1 Straight-line over entire life
2 Straight-line over remaining life
3 Declining-balance, geometric
GWRYR Life of the periodic reduction of goodwill - years FC_GWRYR NUMC 2 0
GWRPE Life of periodic reduction of goodwill - months FC_GWRPE NUMC 3 0
GWRBG Beginning date of the periodic reduction of new goodwill FC_GWRBG CHAR 1 0
1 Start of current year
2 Start of current range of periods
3 Start of current period
4 Start of following period
5 Beginning of following range of periods
6 Start of following year
GWRRFLG Reduce the new goodwill over its remaining life FC_GWRRFLG CHAR 1 0
X Yes
NULL No
GWRLFLG Threshold value for the periodic reduction of goodwill FC_GWRLFLG CHAR 1 0
X Yes
NULL No
GWRLVAL Threshold value for the periodic reduction of goodwill FC_GWRLVAL CURR 17 2
GWRLCUR Group currency for threshold for periodic reduction of GW FC_GWRLCUR TCURC CUKY 5 0
GWRMETH Amortization method FC_DEPMETH NUMC 1 0
0 No depreciation/amortization
1 Straight-line over entire life
2 Straight-line over remaining life
3 Declining-balance, geometric
NGAYR Life of amortization of negative goodwill in years FC_NGAYR NUMC 2 0
NGAPE Life of amortization of negative goodwill in months FC_NGAPE NUMC 3 0
NGABG Beginning date of amortization of new negative goodwill FC_NGABG CHAR 1 0
1 Start of current year
2 Start of current range of periods
3 Start of current period
4 Start of following period
5 Beginning of following range of periods
6 Start of following year
NGARFLG Amortization of new negative goodwill over remain. life FC_NGARFLG CHAR 1 0
X Yes
NULL No
NGALFLG Threshold for amortization of negative goodwill FC_NGALFLG CHAR 1 0
X Yes
NULL No
NGALVAL Threshold for amortization of negative goodwill FC_NGALVAL CURR 17 2
NGALCUR Group currency f. threshold of neg. goodwill amortization FC_NGALCUR TCURC CUKY 5 0
NGAMETH Amortization method FC_DEPMETH NUMC 1 0
0 No depreciation/amortization
1 Straight-line over entire life
2 Straight-line over remaining life
3 Declining-balance, geometric
NGRYR Life of periodic reduction of negative goodwill - years FC_NGRYR NUMC 2 0
NGRPE Life of periodic reduction of negative goodwill - months FC_NGRPE NUMC 3 0
NGRBG Beginning date of the reduction of new negative goodwill FC_NGRBG CHAR 1 0
1 Start of current year
2 Start of current range of periods
3 Start of current period
4 Start of following period
5 Beginning of following range of periods
6 Start of following year
NGRRFLG Reduce new negative goodwill over its remaining life FC_NGRRFLG CHAR 1 0
X Yes
NULL No
NGRLFLG Threshold for periodic reduction of negative goodwill FC_NGRLFLG CHAR 1 0
X Yes
NULL No
NGRLVAL Threshold for periodic reduction of negative goodwill FC_NGRLVAL CURR 17 2
NGRLCUR Group currency of threshold for periodic reduction of neg.GW FC_NGRLCUR TCURC CUKY 5 0
NGRMETH Amortization method FC_DEPMETH NUMC 1 0
0 No depreciation/amortization
1 Straight-line over entire life
2 Straight-line over remaining life
3 Declining-balance, geometric

TF600 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TF600 COIMETH TF600 MANDT TF550 Methods MANDT
TF600 COIMETH TF600 DIMEN TF550 Methods DIMEN
TF600 COIMETH TF600 COIMETH TF550 Methods CMETH
TF600 DIMEN TF600 DIMEN TF150 Dimensions DIMEN
TF600 DIMEN SYST MANDT TF150 Dimensions MANDT
TF600 GWALCUR TF600 MANDT TCURC Currency Codes MANDT
TF600 GWALCUR TF600 GWALCUR TCURC Currency Codes WAERS
TF600 GWRLCUR TF600 MANDT TCURC Currency Codes MANDT
TF600 GWRLCUR TF600 GWRLCUR TCURC Currency Codes WAERS
TF600 HRAQDSI TF600 MANDT TF115 Subitems MANDT
TF600 HRAQDSI TF600 HRSITYP TF115 Subitems SITYP
TF600 HRAQDSI TF600 HRAQDSI TF115 Subitems SITEM
TF600 HRDPCSI TF600 MANDT TF115 Subitems MANDT
TF600 HRDPCSI TF600 HRSITYP TF115 Subitems SITYP
TF600 HRDPCSI TF600 HRDPCSI TF115 Subitems SITEM
TF600 HRDPDSI TF600 MANDT TF115 Subitems MANDT
TF600 HRDPDSI TF600 HRSITYP TF115 Subitems SITYP
TF600 HRDPDSI TF600 HRDPDSI TF115 Subitems SITEM
TF600 HRSITYP TF600 MANDT TF110 Subitem Categories MANDT
TF600 HRSITYP TF600 HRSITYP TF110 Subitem Categories SITYP
TF600 MANDT TF600 MANDT T000 Clients MANDT
TF600 NGALCUR TF600 NGALCUR TCURC Currency Codes WAERS
TF600 NGALCUR TF600 MANDT TCURC Currency Codes MANDT
TF600 NGRLCUR TF600 MANDT TCURC Currency Codes MANDT
TF600 NGRLCUR TF600 NGRLCUR TCURC Currency Codes WAERS
TF600 NHAQCSI TF600 MANDT TF115 Subitems MANDT
TF600 NHAQCSI TF600 NHSITYP TF115 Subitems SITYP
TF600 NHAQCSI TF600 NHAQCSI TF115 Subitems SITEM
TF600 NHDPCSI TF600 NHDPCSI TF115 Subitems SITEM
TF600 NHDPCSI TF600 MANDT TF115 Subitems MANDT
TF600 NHDPCSI TF600 NHSITYP TF115 Subitems SITYP
TF600 NHDPDSI TF600 MANDT TF115 Subitems MANDT
TF600 NHDPDSI TF600 NHSITYP TF115 Subitems SITYP
TF600 NHDPDSI TF600 NHDPDSI TF115 Subitems SITEM
TF600 NHSITYP TF600 MANDT TF110 Subitem Categories MANDT
TF600 NHSITYP TF600 NHSITYP TF110 Subitem Categories SITYP