SAP table TF200 (Consolidation Versions)

SAP table TF200 has 2 primary key fields being MANDT,RVERS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T009 MANDT
RVERS Consolidation Version CHAR 3 0 FC_RVERS
STRVS Version: Structures CHAR 3 0 TF202 FC_STRVS
INPVS Version for data entry CHAR 3 0 TF204 FC_INPVS
CTRVS Version: Currency translation method CHAR 3 0 TF206 FC_CTRVS
CURVS Version: Exchange rates CHAR 3 0 TF208 FC_CURVS
LDRVS Version: Ledger CHAR 3 0 TF210 FC_LDRVS
FIXVS Version: Selected FS items CHAR 3 0 TF212 FC_FIXVS
TAXVS Version: Tax rate CHAR 3 0 TF214 FC_TAXVS
COIVS Version: Consolidation of investments method CHAR 3 0 TF216 FC_COIVS
INVVS Version: Changes in investments CHAR 3 0 TF218 FC_INVVS
EQUVS Version: Changes in investee equity CHAR 3 0 TF220 FC_EQUVS
GWAVS Version: Goodwill CHAR 3 0 TF228 FC_GWAVS
HIRVS Version: Hidden reserves (fair value adjustments) CHAR 3 0 TF222 FC_HIRVS
RHRVS Version: Eliminated hidden reserves (fair value adjustments) CHAR 3 0 TF224 FC_RHRVS
ASSVS Version: Equity holdings adjustments CHAR 3 0 TF226 FC_ASSVS
RCLVS Version: Reclassifications CHAR 3 0 TF232 FC_RCLVS
IPIVS Version: Elimination of IU profit/loss in inventory CHAR 3 0 TF234 FC_IPIVS
ATRVS Version: Attributes of Master Data CHAR 3 0 TF236 FC_ATRVS
RRLVS Report Rule Version CHAR 3 0 TF238 FC_RRLVS
IMPVS Item Mapping Version CHAR 3 0 TF23A FC_IMPVS
IATVS FS Item Attributes Version CHAR 3 0 TF23C FC_IATVS
DBSVS Base version CHAR 3 0 TF200 FC_DBSVS
BCFIND Carry forward version CHAR 1 0 FC_BCFIND
CPYRD Enable copying of reported financial data CHAR 1 0 FC_CPYRD
CPYCE Enable copying of standardizing/consolidation entries CHAR 1 0 FC_CPYCE
OVRRD Enable overwriting of reported financial data CHAR 1 0 FC_OVRRD
OVRCE Overwriting of standardizing/consolidation entries enabled CHAR 1 0 FC_OVRCE
PLANVERS Version for Plan Data CHAR 1 0 FC_PLANVERS
CATEGORY_SRC Source Category for Plan Consolidation CHAR 10 0 FCOMC_CATEGORY FC_CATEGORY_SRC
RLDNR_SRC Source Ledger for Plan Consolidation CHAR 2 0 FINSC_LEDGER FC_RLDNR_SRC
PERIV Fiscal year variant CHAR 2 0 T009 FC_PERIV
REF_VERSION Reference version CHAR 3 0 TF200 FC_REF_VERS
EXT_VERSION_TYPE Reference version type CHAR 1 0 FC_EXT_VERSION_TYPE
G Group Currency Extension
S Standard
X Extension
EXEC_MODE Run mode CHAR 1 0 FC_EXEC_MODE
1 TODO Standard run
2 TODO Successive run
GROUP_CURR Group Currency of Consolidation Version CUKY 5 0 TCURC FC_GROUP_CURR
RLDNR_SOURCE Source ledger CHAR 2 0 FINSC_LEDGER FC_RLDNR_SOURCE
RLDNR_CONS Consolidation version ledger CHAR 2 0 FC_RLDNR_CONS
CUAVS Consolidation Unit Attribute Special Version CHAR 3 0 TF23E FC_CU_ATTR_VS
RLDNR_SOURCE_ACC_INT Group Reporting Preparation Ledger CHAR 2 0 FC_RLDNR_SOURCE_ACC_INT
SOURCE_KF_GC Source for Group Currency Key Figure CHAR 1 0 FC_CURR_GROUP_SEND

TF200 foreign key relationships

Table Field Check Table Check Field
0 TF200 ASSVS TF226 Retained Earnings Versions MANDT
1 TF200 ATRVS TF236 Versions: Attributes MANDT
0 TF200 CATEGORY_SRC FCOMC_CATEGORY Category CATEGORY
1 TF200 COIVS TF216 Consolidation of Investment Method Versions MANDT
0 TF200 CTRVS TF206 Translation Method Versions MANDT
1 TF200 CURVS TF208 Exchange Rate Versions MANDT
0 TF200 DBSVS TF200 Consolidation Versions MANDT
0 TF200 DBSVS TF200 Consolidation Versions RVERS
1 TF200 EQUVS TF220 Equity Versions MANDT
0 TF200 FIXVS TF212 Versions for Selected FS Items MANDT
1 TF200 GROUP_CURR TCURC Currency Codes MANDT
1 TF200 GROUP_CURR TCURC Currency Codes WAERS
0 TF200 GWAVS TF228 Versions of Goodwill MANDT
1 TF200 HIRVS TF222 Hidden Reserve (Fair Value Adjustment) Versions MANDT
0 TF200 INPVS TF204 Data Entry Versions MANDT
1 TF200 INVVS TF218 Investment Versions MANDT
0 TF200 IPIVS TF234 Versions for Elimination of IU Profit/Loss in Inventory MANDT
1 TF200 LDRVS TF210 Ledger Versions MANDT
0 TF200 MANDT T009 Fiscal Year Variants MANDT
0 TF200 MANDT T009 Fiscal Year Variants PERIV
1 TF200 PERIV T009 Fiscal Year Variants MANDT
1 TF200 PERIV T009 Fiscal Year Variants PERIV
0 TF200 RCLVS TF232 Reclassifications Version MANDT
1 TF200 REF_VERSION TF200 Consolidation Versions MANDT
1 TF200 REF_VERSION TF200 Consolidation Versions RVERS
0 TF200 RHRVS TF224 Versions of Eliminated Hidden Reserves (FVA) MANDT
1 TF200 STRVS TF202 Structure Versions MANDT
0 TF200 TAXVS TF214 Tax Rate Versions MANDT