SAP Table TF200
Consolidation Versions
TF200 (Consolidation Versions) 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 TF200 to other SAP tables.
TF200 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| RVERS | Consolidation (end-result) version | FC_RVERS | CHAR | 3 | 0 | |||||||
| STRVS | Version: Structures | FC_STRVS | TF202 | CHAR | 3 | 0 | ||||||
| INPVS | Version for data entry | FC_INPVS | TF204 | CHAR | 3 | 0 | ||||||
| CTRVS | Version: Currency translation method | FC_CTRVS | TF206 | CHAR | 3 | 0 | ||||||
| CURVS | Version: Exchange rates | FC_CURVS | TF208 | CHAR | 3 | 0 | ||||||
| LDRVS | Version: Ledger | FC_LDRVS | TF210 | CHAR | 3 | 0 | ||||||
| FIXVS | Version: Selected FS items | FC_FIXVS | TF212 | CHAR | 3 | 0 | ||||||
| TAXVS | Version: Tax rate | FC_TAXVS | TF214 | CHAR | 3 | 0 | ||||||
| COIVS | Version: Consolidation of investments method | FC_COIVS | TF216 | CHAR | 3 | 0 | ||||||
| INVVS | Version: Changes in investments | FC_INVVS | TF218 | CHAR | 3 | 0 | ||||||
| EQUVS | Version: Changes in investee equity | FC_EQUVS | TF220 | CHAR | 3 | 0 | ||||||
| GWAVS | Version: Goodwill | FC_GWAVS | TF228 | CHAR | 3 | 0 | ||||||
| HIRVS | Version: Hidden reserves (fair value adjustments) | FC_HIRVS | TF222 | CHAR | 3 | 0 | ||||||
| RHRVS | Version: Eliminated hidden reserves (fair value adjustments) | FC_RHRVS | TF224 | CHAR | 3 | 0 | ||||||
| ASSVS | Version: Equity holdings adjustments | FC_ASSVS | TF226 | CHAR | 3 | 0 | ||||||
| RCLVS | Version: Reclassifications | FC_RCLVS | TF232 | CHAR | 3 | 0 | ||||||
| IPIVS | Version: Elimination of IU profit/loss in inventory | FC_IPIVS | TF234 | CHAR | 3 | 0 | ||||||
| ATRVS | Version: Attributes of Master Data | FC_ATRVS | TF236 | CHAR | 3 | 0 | ||||||
| DBSVS | Base version | FC_DBSVS | TF200 | CHAR | 3 | 0 | ||||||
| BCFIND | Carry forward version | FC_BCFIND | CHAR | 1 | 0 |
Possible values
|
||||||
| CPYRD | Enable copying of reported financial data | FC_CPYRD | CHAR | 1 | 0 |
Possible values
|
||||||
| CPYCE | Enable copying of standardizing/consolidation entries | FC_CPYCE | CHAR | 1 | 0 |
Possible values
|
||||||
| OVRRD | Enable overwriting of reported financial data | FC_OVRRD | CHAR | 1 | 0 |
Possible values
|
||||||
| OVRCE | Overwriting of standardizing/consolidation entries enabled | FC_OVRCE | CHAR | 1 | 0 |
Possible values
|
||||||
TF200 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TF200 | ASSVS | TF200 | MANDT | TF226 | Retained Earnings Versions | MANDT |
| TF200 | ASSVS | TF200 | ASSVS | TF226 | Retained Earnings Versions | ASSVS |
| TF200 | ATRVS | TF200 | MANDT | TF236 | Versions: Attributes | MANDT |
| TF200 | ATRVS | TF200 | ATRVS | TF236 | Versions: Attributes | ATRVS |
| TF200 | COIVS | TF200 | MANDT | TF216 | Consolidation of Investment Method Versions | MANDT |
| TF200 | COIVS | TF200 | COIVS | TF216 | Consolidation of Investment Method Versions | COIVS |
| TF200 | CTRVS | TF200 | CTRVS | TF206 | Translation Method Versions | CTRVS |
| TF200 | CTRVS | TF200 | MANDT | TF206 | Translation Method Versions | MANDT |
| TF200 | CURVS | TF200 | MANDT | TF208 | Exchange Rate Versions | MANDT |
| TF200 | CURVS | TF200 | CURVS | TF208 | Exchange Rate Versions | CURVS |
| TF200 | DBSVS | TF200 | MANDT | TF200 | Consolidation Versions | MANDT |
| TF200 | DBSVS | TF200 | DBSVS | TF200 | Consolidation Versions | RVERS |
| TF200 | EQUVS | TF200 | MANDT | TF220 | Equity Versions | MANDT |
| TF200 | EQUVS | TF200 | EQUVS | TF220 | Equity Versions | EQUVS |
| TF200 | FIXVS | TF200 | FIXVS | TF212 | Versions for Selected FS Items | FIXVS |
| TF200 | FIXVS | TF200 | MANDT | TF212 | Versions for Selected FS Items | MANDT |
| TF200 | GWAVS | TF200 | GWAVS | TF228 | Versions of Goodwill | GWAVS |
| TF200 | GWAVS | TF200 | MANDT | TF228 | Versions of Goodwill | MANDT |
| TF200 | HIRVS | TF200 | HIRVS | TF222 | Hidden Reserve (Fair Value Adjustment) Versions | HIRVS |
| TF200 | HIRVS | TF200 | MANDT | TF222 | Hidden Reserve (Fair Value Adjustment) Versions | MANDT |
| TF200 | INPVS | TF200 | MANDT | TF204 | Data Entry Versions | MANDT |
| TF200 | INPVS | TF200 | INPVS | TF204 | Data Entry Versions | INPVS |
| TF200 | INVVS | TF200 | MANDT | TF218 | Investment Versions | MANDT |
| TF200 | INVVS | TF200 | INVVS | TF218 | Investment Versions | INVVS |
| TF200 | IPIVS | TF200 | MANDT | TF234 | Versions for Elimination of IU Profit/Loss in Inventory | MANDT |
| TF200 | IPIVS | TF200 | IPIVS | TF234 | Versions for Elimination of IU Profit/Loss in Inventory | IPIVS |
| TF200 | LDRVS | TF200 | MANDT | TF210 | Ledger Versions | MANDT |
| TF200 | LDRVS | TF200 | LDRVS | TF210 | Ledger Versions | LDRVS |
| TF200 | MANDT | TF200 | MANDT | T000 | Clients | MANDT |
| TF200 | RCLVS | TF200 | MANDT | TF232 | Reclassifications Version | MANDT |
| TF200 | RCLVS | TF200 | RCLVS | TF232 | Reclassifications Version | RCLVS |
| TF200 | RHRVS | TF200 | MANDT | TF224 | Versions of Eliminated Hidden Reserves (FVA) | MANDT |
| TF200 | RHRVS | TF200 | RHRVS | TF224 | Versions of Eliminated Hidden Reserves (FVA) | RHRVS |
| TF200 | STRVS | TF200 | MANDT | TF202 | Structure Versions | MANDT |
| TF200 | STRVS | TF200 | STRVS | TF202 | Structure Versions | STRVS |
| TF200 | TAXVS | TF200 | MANDT | TF214 | Tax Rate Versions | MANDT |
| TF200 | TAXVS | TF200 | TAXVS | TF214 | Tax Rate Versions | TAXVS |
