TF200 SAP (Consolidation Versions) Table details
Dictionary Type: Table
Description: Consolidation Versions
Description: Consolidation Versions
Table field list including key, data, relationships and ABAP select examples
TF200 is a standard SAP Table which is used to store Consolidation Versions data and is available within R/3 SAP systems depending on the version and release level.
The TF200 table consists of various fields, each holding specific information or linking keys about Consolidation Versions data available in SAP. These include RVERS (Consolidation (end-result) version), STRVS (Version: Structures), INPVS (Version for data entry), CTRVS (Version: Currency translation method).. 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
Text table = TF201
SAP TF200 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 | |||
RVERS | Consolidation (end-result) version | FC_RVERS | CHAR | 3 | ALPHA | FC_RVERS | GVS | FC_RVERS | |
STRVS | Version: Structures | FC_STRVS | CHAR | 3 | TF202 | ALPHA | FC_STRVS | FC_STRVS | |
INPVS | Version for data entry | FC_INPVS | CHAR | 3 | TF204 | ALPHA | FC_INPVS | FC_INPVS | |
CTRVS | Version: Currency translation method | FC_CTRVS | CHAR | 3 | TF206 | ALPHA | FC_CTRVS | FC_CTRVS | |
CURVS | Version: Exchange rates | FC_CURVS | CHAR | 3 | TF208 | ALPHA | FC_CURVS | FC_CURVS | |
LDRVS | Version: Ledger | FC_LDRVS | CHAR | 3 | TF210 | ALPHA | FC_LDRVS | FC_LDRVS | |
FIXVS | Version: Selected FS items | FC_FIXVS | CHAR | 3 | TF212 | ALPHA | FC_FIXVS | FC_FIXVS | |
TAXVS | Version: Tax rate | FC_TAXVS | CHAR | 3 | TF214 | ALPHA | FC_TAXVS | FC_TAXVS | |
COIVS | Version: Consolidation of investments method | FC_COIVS | CHAR | 3 | TF216 | ALPHA | FC_COIVS | FC_COIVS | |
INVVS | Version: Changes in investments | FC_INVVS | CHAR | 3 | TF218 | ALPHA | FC_INVVS | FC_INVVS | |
EQUVS | Version: Changes in investee equity | FC_EQUVS | CHAR | 3 | TF220 | ALPHA | FC_EQUVS | FC_EQUVS | |
GWAVS | Version: Goodwill | FC_GWAVS | CHAR | 3 | TF228 | ALPHA | FC_GWAVS | FC_GWAVS | |
HIRVS | Version: Hidden reserves (fair value adjustments) | FC_HIRVS | CHAR | 3 | TF222 | ALPHA | FC_HIRVS | FC_HIRVS | |
RHRVS | Version: Eliminated hidden reserves (fair value adjustments) | FC_RHRVS | CHAR | 3 | TF224 | ALPHA | FC_RHRVS | FC_RHRVS | |
ASSVS | Version: Equity holdings adjustments | FC_ASSVS | CHAR | 3 | TF226 | ALPHA | FC_ASSVS | FC_ASSVS | |
RCLVS | Version: Reclassifications | FC_RCLVS | CHAR | 3 | TF232 | ALPHA | FC_RCLVS | FC_RCLVS | |
IPIVS | Version: Elimination of IU profit/loss in inventory | FC_IPIVS | CHAR | 3 | TF234 | ALPHA | FC_IPIVS | ||
ATRVS | Version: Attributes of Master Data | FC_ATRVS | CHAR | 3 | TF236 | ALPHA | FC_ATRVS | ||
DBSVS | Base version | FC_DBSVS | CHAR | 3 | TF200 | ALPHA | FC_RVERS | ||
BCFIND | Carry forward version | FC_BCFIND | CHAR | 1 | X | ||||
CPYRD | Enable copying of reported financial data | FC_CPYRD | CHAR | 1 | X | ||||
CPYCE | Enable copying of standardizing/consolidation entries | FC_CPYCE | CHAR | 1 | X | ||||
OVRRD | Enable overwriting of reported financial data | FC_OVRRD | CHAR | 1 | X | ||||
OVRCE | Overwriting of standardizing/consolidation entries enabled | FC_OVRCE | CHAR | 1 | X |
Key field | Non-key field |
How do I retrieve data from SAP table TF200 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TF200 to SELECT all data from the tableDATA: WA_TF200 TYPE TF200.
SELECT SINGLE *
FROM TF200
INTO CORRESPONDING FIELDS OF WA_TF200
WHERE...
How to access SAP table TF200
Within an ECC or HANA version of SAP you can also view further information about TF200 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