TF691 SAP (C/I - Global Settings) Table details

Dictionary Type: Table
Description: C/I - Global Settings




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




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 cust
Display/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
MANDTClient MANDTCLNT3T000MANDT
DIMENDimension FC_DIMENCHAR2TF150FC_DIMENDINFC_DIMEN
COILVCalculation base for the consolidation of investments FC_COILVCHAR1FC_COILV
INVVALLocation of investment holdings values FC_INVVALCHAR1FC_VALDB1
EQUVALLocation of equity data FC_EQUVALCHAR1FC_VALDB1
EQIVALLocation of data for subsequent equity consolidation FC_EQIVALCHAR1FC_VALDB2
ESHFLGNet display of equity aging report FC_ESHFLGCHAR1X
ESHSITSubitem category for investee equity FC_ESHSITCHAR3TF110FC_SITYP
ESHMDSDebits subitem for minority interest FC_ESHMDSCHAR10TF115FC_SITEM
ESHMCSCredits subitem for minority interest FC_ESHMCSCHAR10TF115FC_SITEM
NIPDFLGAffect net income when posting partial divestitures FC_NIPDFLGCHAR1X
NIIDFLGAffect net income when reducing indirect investments FC_NIIDFLGCHAR1X
ASSDTDoc. type assignment FC_ASSDTCHAR1FC_ASSDT
PUACHKValidation of Push-down Goodwill FC_PUACHKNUMC1FC_PUACHK
XRINDGWBSGoodwill in Local Crcy: Exchange Rate Ind., Balance Sheet FC_XRINDGWBSCHAR1TF420FC_EXRIND
XRINDGWISGoodwill in Local Crcy: Exchange Rate Ind., Income Statement FC_XRINDGWISCHAR1TF420FC_EXRIND
CTKEYGWISGoodwill in Local Crcy: Currency Trl. Key, Income Statement FC_CTKEYGWISCHAR1FC_COI_CTKEY
GWTBEGFLGCurrency Translation for Goodwill at Beginning of Period FC_GWTBEGFLGCHAR1X
GWPROCDATreatment of Goodwill in Increases in Direct Investment FC_GWPROCDACHAR1FC_GWPROC
GWPROCIATreatment of Goodwill in Increases in Indirect Investment FC_GWPROCIACHAR1FC_GWPROC
NGPROCDANeg.GW Treatment in Incr.in Direct Invest.(exc. First Cons) FC_NGPROCDACHAR1FC_GWPROC
NGPROCIANeg.GW Treatment in Increase in Indirect Investment FC_NGPROCIACHAR1FC_GWPROC
LDTYRFiscal Year of Legacy Data Transfer FC_LDTYRNUMC4GJAHRGJAHR
LDTPEPeriod of Legacy Data Transfer FC_LDTPENUMC3PERDE
NINVFLGEnable negative investments FC_NINVFLGCHAR1X
NMINFLGNo calculation of minority interest FC_NMINFLGCHAR1X
HRREVProcedure for eliminating hidden reserves/contingencies(FVA) FC_HRREVCHAR1FC_HRREV
HRSHAScope of elimination of hidden reserves/contingencies FC_HRSHACHAR1FC_HRSHA
HRSITYPSubitem category for hidden reserves (fair value adjustment) FC_HRSITYPCHAR3TF110FC_SITYP
HRAQDSISubitem for transferring hidden reserves (fair value adj.) FC_HRAQDSICHAR10TF115FC_SITEM
HRDPCSISubitem for amortization of hidden reserves (fair value adj) FC_HRDPCSICHAR10TF115FC_SITEM
HRDPDSISubitem for writeups of hidden reserves (fair value adj.) FC_HRDPDSICHAR10TF115FC_SITEM
NHSITYPSubitem category for hidden contingencies (fair value adj.) FC_NHSITYPCHAR3TF110FC_SITYP
NHAQCSISubitem for transferring hidden contingencies (fair val.adj) FC_NHAQCSICHAR10TF115FC_SITEM
NHDPDSISubitem for changes to hidden contingencies - debit FC_NHDPDSICHAR10TF115FC_SITEM
NHDPCSISubitem for changes to hidden contingencies - credit FC_NHDPCSICHAR10TF115FC_SITEM
GWAYRLife of goodwill amortization in years FC_GWAYRNUMC2NUMC2
GWAPELife of goodwill amortization in months FC_GWAPENUMC3NUMC3
GWABGStart date for the amortization of new goodwill FC_GWABGCHAR1FC_DGWBG
GWARFLGAmortize new goodwill over remaining life FC_GWARFLGCHAR1X
GWALFLGThreshold value for the amortization of goodwill FC_GWALFLGCHAR1X
GWALVALThreshold value for the amortization of goodwill FC_GWALVALCURR17(2) WERTV9
GWALCURGroup currency for threshold for goodwill amortization FC_GWALCURCUKY5TCURCWAERS
GWAMETHAmortization method FC_DEPMETHNUMC1FC_DEPMETH
GWRYRLife of the periodic reduction of goodwill - years FC_GWRYRNUMC2NUMC2
GWRPELife of periodic reduction of goodwill - months FC_GWRPENUMC3NUMC3
GWRBGBeginning date of the periodic reduction of new goodwill FC_GWRBGCHAR1FC_DGWBG
GWRRFLGReduce the new goodwill over its remaining life FC_GWRRFLGCHAR1X
GWRLFLGThreshold value for the periodic reduction of goodwill FC_GWRLFLGCHAR1X
GWRLVALThreshold value for the periodic reduction of goodwill FC_GWRLVALCURR17(2) WERTV9
GWRLCURGroup currency for threshold for periodic reduction of GW FC_GWRLCURCUKY5TCURCWAERS
GWRMETHAmortization method FC_DEPMETHNUMC1FC_DEPMETH
NGAYRLife of amortization of negative goodwill in years FC_NGAYRNUMC2NUMC2
NGAPELife of amortization of negative goodwill in months FC_NGAPENUMC3NUMC3
NGABGBeginning date of amortization of new negative goodwill FC_NGABGCHAR1FC_DGWBG
NGARFLGAmortization of new negative goodwill over remain. life FC_NGARFLGCHAR1X
NGALFLGThreshold for amortization of negative goodwill FC_NGALFLGCHAR1X
NGALVALThreshold for amortization of negative goodwill FC_NGALVALCURR17(2) WERTV9
NGALCURGroup currency f. threshold of neg. goodwill amortization FC_NGALCURCUKY5TCURCWAERS
NGAMETHAmortization method FC_DEPMETHNUMC1FC_DEPMETH
NGRYRLife of periodic reduction of negative goodwill - years FC_NGRYRNUMC2NUMC2
NGRPELife of periodic reduction of negative goodwill - months FC_NGRPENUMC3NUMC3
NGRBGBeginning date of the reduction of new negative goodwill FC_NGRBGCHAR1FC_DGWBG
NGRRFLGReduce new negative goodwill over its remaining life FC_NGRRFLGCHAR1X
NGRLFLGThreshold for periodic reduction of negative goodwill FC_NGRLFLGCHAR1X
NGRLVALThreshold for periodic reduction of negative goodwill FC_NGRLVALCURR17(2) WERTV9
NGRLCURGroup currency of threshold for periodic reduction of neg.GW FC_NGRLCURCUKY5TCURCWAERS
NGRMETHAmortization method FC_DEPMETHNUMC1FC_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 table
DATA: 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 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!