TF635A SAP (Goodwill/Neg.Goodwill) Table details
Dictionary Type: Table
Description: Goodwill/Neg.Goodwill
Description: Goodwill/Neg.Goodwill
Table field list including key, data, relationships and ABAP select examples
TF635A is a standard SAP Table which is used to store Goodwill/Neg.Goodwill data and is available within R/3 SAP systems depending on the version and release level.
The TF635A table consists of various fields, each holding specific information or linking keys about Goodwill/Neg.Goodwill data available in SAP. These include DIMEN (Dimension), ITCLG (Consolidation chart of accounts), GWAVS (Consolidation (end-result) version), CONGR (Consolidation group).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP TF635A 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 | |
GWAVS | Consolidation (end-result) version | FC_RVERS | CHAR | 3 | TF200 | ALPHA | FC_RVERS | GVS | FC_RVERS |
CONGR | Consolidation group | FC_CONGR | CHAR | 18 | TF180 | AFIMC | FC_CONGR | CGR | |
COICU | Investee unit | FC_COICU | CHAR | 18 | TF160 | AFIMC | FC_BUNIT | CCU | |
CYEAR | Fiscal year | FC_RYEAR | NUMC | 4 | GJAHR | GJAHR | GFY | ||
CPERI | Period | FC_PERID | NUMC | 3 | PERDE | GFP | |||
BUNIT | Consolidation unit | FC_BUNIT | CHAR | 18 | TF160 | AFIMC | FC_BUNIT | BUN | |
BUPTR | Partner unit | FC_BUPTR | CHAR | 18 | TF160 | AFIMC | FC_BUNIT | ||
COIAC | Activity for consolidation of investments | FC_COIAC | CHAR | 2 | FC_COIAC | COA | |||
COINR | Consolidation of investments activity number | FC_COINR | CHAR | 10 | ALPHA | BELNR | CNR | ||
AYEAR | Year of incurrence of the amount to be amortized/depreciated | FC_AYEAR | NUMC | 4 | GJAHR | GJAHR | |||
APERI | Period of incurrence of the amount to be amortized/depr'd | FC_APERI | NUMC | 3 | PERDE | ||||
PGFLG | Push-down Goodwill | FC_PGFLG | CHAR | 1 | X | ||||
SEQNR | Sequence number | FC_SEQNR3 | NUMC | 3 | NUMC3 | ||||
BYEAR | Beginning year of amortization/depreciation | FC_BYEAR | NUMC | 4 | GJAHR | GJAHR | |||
BPERI | Beginning period of amortization/depreciation | FC_BPERI | NUMC | 3 | PERDE | ||||
DDYRS | Life of depreciation (amortization) in years | FC_DDYRS | NUMC | 4 | FC_DDYRS | ||||
DDPER | Life of depreciation (amortization) in months | FC_DDPER | NUMC | 3 | PERDE | ||||
LCGWFLG | Goodwill Entry Carried in Local Currency | FC_LCGWFLG | CHAR | 1 | X | ||||
LCKEYIE | Local Currency Key of Investee Unit | FC_LCKEYIE | CUKY | 5 | TCURC | WAERS | |||
LCVALAP | Original Book Value (LC) | FC_LCVALAP | CURR | 17(2) | WERTV9 | ||||
VALAP | Original Book Value (GC) | FC_VALAP | CURR | 17(2) | WERTV9 | ||||
LCVALK0 | Original Book Value, Prior Year (LC) | FC_LCVALK0 | CURR | 17(2) | WERTV9 | ||||
GCVALK0 | Original Book Value, Prior Year (GC) | FC_GCVALK0 | CURR | 17(2) | WERTV9 | ||||
LCVALK1 | Divestiture of Original Book Value, Prior Year (LC) | FC_LCVALK1 | CURR | 17(2) | WERTV9 | ||||
GCVALK1 | Divestiture of Original Book Value, Prior Year (GC) | FC_GCVALK1 | CURR | 17(2) | WERTV9 | ||||
GCVALK2 | C/T Difference from Original Cost Prior Year in Prior Year | FC_GCVALK2 | CURR | 17(2) | WERTV9 | ||||
LCVALN1 | Valuation Allowance in Income Statement, Prior Year (LC) | FC_LCVALN1 | CURR | 17(2) | WERTV9 | ||||
GCVALN1 | Valuation Allowance in Income Statement, Prior Year (GC) | FC_GCVALN1 | CURR | 17(2) | WERTV9 | ||||
GCVALN2 | C/T Difference from VA I/S Prior Year in Prior Year | FC_GCVALN2 | CURR | 17(2) | WERTV9 | ||||
LCVALDP | Accumulated Adjustment of OC from Divest.fr.Prior Per. (LC) | FC_LCVALDP | CURR | 17(2) | WERTV9 | ||||
VALDP | Acc.Adjustment of Orig.Cost for Divest. in Pr.Periods (GC) | FC_VALDP | CURR | 17(2) | WERTV9 | ||||
GCVALK3 | C/T Difference from Orig.Cost Prior Year in Prior Periods | FC_GCVALK3 | CURR | 17(2) | WERTV9 | ||||
GCVALL3 | C/T Difference from Orig.Cost Current Year in Prior Periods | FC_GCVALL3 | CURR | 17(2) | WERTV9 | ||||
GCVALM3 | Divestiture of C/T Difference Original Cost in Prior Periods | FC_GCVALM3 | CURR | 17(2) | WERTV9 | ||||
GCVALM1 | C/T Difference from Divestiture Orig.Cost in Prior Periods | FC_GCVALM1 | CURR | 17(2) | WERTV9 | ||||
LCVALV1 | Valuation Allowance in Prior Periods (LC) | FC_LCVALV1 | CURR | 17(2) | WERTV9 | ||||
GCVALV1 | Valuation Allowance in Prior Periods (GC) | FC_GCVALV1 | CURR | 17(2) | WERTV9 | ||||
LCVALD0 | Divest. of Val.Allowance Prior Year in Prior Periods (LC) | FC_LCVALD0 | CURR | 17(2) | WERTV9 | ||||
GCVALD0 | Div. of Valuation Allow., Prior Year in Prior Periods (GC) | FC_GCVALD0 | CURR | 17(2) | WERTV9 | ||||
LCVALD1 | Divest. of Val.Allowance Curr. Year in Prior Periods (LC) | FC_LCVALD1 | CURR | 17(2) | WERTV9 | ||||
GCVALD1 | Div. of Valuation Allow., Current Year in Prior Periods (GC) | FC_GCVALD1 | CURR | 17(2) | WERTV9 | ||||
GCVALN3 | C/T Difference from VA I/S Prior Year in Prior Periods | FC_GCVALN3 | CURR | 17(2) | WERTV9 | ||||
GCVALV3 | C/T Difference B/S-I/S from Val.Allowance in Prior Periods | FC_GCVALV3 | CURR | 17(2) | WERTV9 | ||||
GCVALD3 | C/T Difference from Divestiture Val.Allow. in Prior Periods | FC_GCVALD3 | CURR | 17(2) | WERTV9 | ||||
LCVALBG | Beginning Book Value (Local Currency) | FC_LCVALBG | CURR | 17(2) | WERTV9 | ||||
VALBG | Beginning Book Value (GC) | FC_VALBG | CURR | 17(2) | WERTV9 | ||||
LCVALDA | Accumulated Adjustment of OC from Divest.in Curr. Per. (LC) | FC_LCVALDA | CURR | 17(2) | WERTV9 | ||||
VALDA | Acc. Adjustment of Orig.Cost for Divest. in Curr.Period(GC) | FC_VALDA | CURR | 17(2) | WERTV9 | ||||
GCVALK4 | C/T Difference from Orig.Cost Prior Year in Current Period | FC_GCVALK4 | CURR | 17(2) | WERTV9 | ||||
GCVALL4 | C/T Difference from Orig.Cost Current Year in Current Period | FC_GCVALL4 | CURR | 17(2) | WERTV9 | ||||
GCVALM4 | Divestiture of C/T Difference Original Cost in Curr.Period | FC_GCVALM4 | CURR | 17(2) | WERTV9 | ||||
GCVALM2 | C/T Difference from Divestiture Orig.Cost in Current Period | FC_GCVALM2 | CURR | 17(2) | WERTV9 | ||||
LCVALDN | Amortization Amount, Ordinary (LC) | FC_LCVALDN | CURR | 17(2) | WERTV9 | ||||
VALDN | Amortization Amount, Ordinary (GC) | FC_VALDN | CURR | 17(2) | WERTV9 | ||||
LCVALDE | Amortization Amount, Extraordinary (LC) | FC_LCVALDE | CURR | 17(2) | WERTV9 | ||||
VALDE | Amortization Amount, Extraordinary (GC) | FC_VALDE | CURR | 17(2) | WERTV9 | ||||
LCVALWU | Writeup (LC) | FC_LCVALWU | CURR | 17(2) | WERTV9 | ||||
VALWU | Writeup (GC) | FC_VALWU | CURR | 17(2) | WERTV9 | ||||
GCVALV2 | C/T Difference I/S from Val.Allowance in Current Period | FC_GCVALV2 | CURR | 17(2) | WERTV9 | ||||
LCVALDD | Accumulated Adjustment from Divest. in Current Period (LC) | FC_LCVALDD | CURR | 17(2) | WERTV9 | ||||
VALDD | Accumulated Amortization for Divestiture in Curr.Period(GC) | FC_VALDD | CURR | 17(2) | WERTV9 | ||||
LCVALD2 | Divest. of Val.Allowance Curr. Year in Curr. Period (LC) | FC_LCVALD2 | CURR | 17(2) | WERTV9 | ||||
GCVALD2 | Div. of Valuation Allow., Current Year in Curr. Period (GC) | FC_GCVALD2 | CURR | 17(2) | WERTV9 | ||||
GCVALN4 | C/T Difference from VA I/S Prior Year in Current Period | FC_GCVALN4 | CURR | 17(2) | WERTV9 | ||||
GCVALV4 | C/T Difference B/S-I/S from Val.Allowance in Current Period | FC_GCVALV4 | CURR | 17(2) | WERTV9 | ||||
GCVALD4 | C/T Difference from Divestiture Val.Allow. in Current Period | FC_GCVALD4 | CURR | 17(2) | WERTV9 | ||||
LCVALEN | Ending Book Value (LC) | FC_LCVALEN | CURR | 17(2) | WERTV9 | ||||
VALEN | Ending Book Value (GC) | FC_VALEN | CURR | 17(2) | WERTV9 | ||||
LCVALDJ | Gain of Original Cost from Disposal in Prior Periods, in LC | FC_LCVALDJ | CURR | 17(2) | WERTV9 | ||||
GCVALDJ | Gain of Original Cost from Disposal in Prior Periods, in GC | FC_GCVALDJ | CURR | 17(2) | WERTV9 | ||||
LCVALDI | Gain of Original Cost from Disposal in Current Period, in LC | FC_LCVALDI | CURR | 17(2) | WERTV9 | ||||
GCVALDI | Gain of Original Cost from Disposal in Current Period, in GC | FC_GCVALDI | CURR | 17(2) | WERTV9 | ||||
NGFLG | Negative goodwill | FC_NGFLG | CHAR | 1 | X | ||||
MLFLG | Manual entry | FC_MLFLG | CHAR | 1 | X | ||||
GWPROC | Treatment of Goodwill | FC_GWPROC | CHAR | 1 | FC_GWPROC |
Key field | Non-key field |
How do I retrieve data from SAP table TF635A using ABAP code
The following ABAP code Example will allow you to do a basic selection on TF635A to SELECT all data from the tableDATA: WA_TF635A TYPE TF635A.
SELECT SINGLE *
FROM TF635A
INTO CORRESPONDING FIELDS OF WA_TF635A
WHERE...
How to access SAP table TF635A
Within an ECC or HANA version of SAP you can also view further information about TF635A 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