TF691 SAP (C/I - Global Settings) Table details
Dictionary Type: Table
Description: C/I - Global Settings
Description: C/I - Global Settings
Table field list including key, data, relationships and ABAP select examples
TF691 is a standard SAP Table which is used to store C/I - Global Settings data and is available within R/3 SAP systems depending on the version and release level.
The TF691 table consists of various fields, each holding specific information or linking keys about C/I - Global Settings data available in SAP. These include DIMEN (Dimension), COILV (Calculation base for the consolidation of investments), INVVAL (Location of investment holdings values), EQUVAL (Location of equity data).. 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 TF691 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 | |
COILV | Calculation base for the consolidation of investments | FC_COILV | CHAR | 1 | FC_COILV | ||||
INVVAL | Location of investment holdings values | FC_INVVAL | CHAR | 1 | FC_VALDB1 | ||||
EQUVAL | Location of equity data | FC_EQUVAL | CHAR | 1 | FC_VALDB1 | ||||
EQIVAL | Location of data for subsequent equity consolidation | FC_EQIVAL | CHAR | 1 | FC_VALDB2 | ||||
ESHFLG | Net display of equity aging report | FC_ESHFLG | CHAR | 1 | X | ||||
ESHSIT | Subitem category for investee equity | FC_ESHSIT | CHAR | 3 | TF110 | FC_SITYP | |||
ESHMDS | Debits subitem for minority interest | FC_ESHMDS | CHAR | 10 | TF115 | FC_SITEM | |||
ESHMCS | Credits subitem for minority interest | FC_ESHMCS | CHAR | 10 | TF115 | FC_SITEM | |||
NIPDFLG | Affect net income when posting partial divestitures | FC_NIPDFLG | CHAR | 1 | X | ||||
NIIDFLG | Affect net income when reducing indirect investments | FC_NIIDFLG | CHAR | 1 | X | ||||
ASSDT | Doc. type assignment | FC_ASSDT | CHAR | 1 | FC_ASSDT | ||||
PUACHK | Validation of Push-down Goodwill | FC_PUACHK | NUMC | 1 | FC_PUACHK | ||||
XRINDGWBS | Goodwill in Local Crcy: Exchange Rate Ind., Balance Sheet | FC_XRINDGWBS | CHAR | 1 | TF420 | FC_EXRIND | |||
XRINDGWIS | Goodwill in Local Crcy: Exchange Rate Ind., Income Statement | FC_XRINDGWIS | CHAR | 1 | TF420 | FC_EXRIND | |||
CTKEYGWIS | Goodwill in Local Crcy: Currency Trl. Key, Income Statement | FC_CTKEYGWIS | CHAR | 1 | FC_COI_CTKEY | ||||
GWTBEGFLG | Currency Translation for Goodwill at Beginning of Period | FC_GWTBEGFLG | CHAR | 1 | X | ||||
GWPROCDA | Treatment of Goodwill in Increases in Direct Investment | FC_GWPROCDA | CHAR | 1 | FC_GWPROC | ||||
GWPROCIA | Treatment of Goodwill in Increases in Indirect Investment | FC_GWPROCIA | CHAR | 1 | FC_GWPROC | ||||
NGPROCDA | Neg.GW Treatment in Incr.in Direct Invest.(exc. First Cons) | FC_NGPROCDA | CHAR | 1 | FC_GWPROC | ||||
NGPROCIA | Neg.GW Treatment in Increase in Indirect Investment | FC_NGPROCIA | CHAR | 1 | FC_GWPROC | ||||
LDTYR | Fiscal Year of Legacy Data Transfer | FC_LDTYR | NUMC | 4 | GJAHR | GJAHR | |||
LDTPE | Period of Legacy Data Transfer | FC_LDTPE | NUMC | 3 | PERDE | ||||
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 TF691 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TF691 to SELECT all data from the tableDATA: WA_TF691 TYPE TF691.
SELECT SINGLE *
FROM TF691
INTO CORRESPONDING FIELDS OF WA_TF691
WHERE...
How to access SAP table TF691
Within an ECC or HANA version of SAP you can also view further information about TF691 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