SAP Consolidation Tables

Are you looking for the right table related to SAP Consolidation Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Consolidation (EC-CS) module.

Top 10 tables in Consolidation

TableDescription
TF225Versions of Eliminated Hidden Reserves: Name
EWUCS11SAP Cons.-EURO: Ledger for Conversion
TF142Special Items for Each Document Type in SAP S/4HANA
TF153Dimensions, Screen List, Consolidation Groups
TF195Hierarchy Levels
TF132Item Hierarchies: Identifiers
TF108AFS Item Attributes: Assignment to FS Items
TF007SAP Consolidation: System Status in S/4HANA
TF173Reasons for Inclusion
TF060Persistence of Totals Records with Report Logic: Log

List of tables in Consolidation

TableDescription
TF225Versions of Eliminated Hidden Reserves: Name
EWUCS11SAP Cons.-EURO: Ledger for Conversion
TF142Special Items for Each Document Type in SAP S/4HANA
TF153Dimensions, Screen List, Consolidation Groups
TF195Hierarchy Levels
TF132Item Hierarchies: Identifiers
TF108AFS Item Attributes: Assignment to FS Items
TF007SAP Consolidation: System Status in S/4HANA
TF173Reasons for Inclusion
TF060Persistence of Totals Records with Report Logic: Log
TF00CTime Stamp for Field Properties for Each Client
TF217Consolidation of Investment Method Versions: Name
TF174Reasons for Inclusion: Short and Medium Texts
TF196Hierarchy Levels: Texts
TF207Translation Method Versions: Name
TF9N2Master Data Texts: &
TF117Subitems: Long Texts
TF625Group Shares
TF691AGlobal Settings for C/I, version-dependent
TF175Reasons for Inclusion: Long Texts
TF695AItems for Statistical Equity in SAP S/4HANA
TF656Activities - Default Sequence
EWUCS10SAP Cons.-EURO: Consolidation Units for Euro Conversion
TF630Changes in Investee Equity
TF645Reporting Fair Value Adjustment Data
FC00_TEST_LOGContains the log of a test run in Consolidation
TF198Hierarchy Level Relationships
TF030Dimension and Version-Dependent Settings
TF187Consolidation Group Set Assignments
TF199AOrganizational Elements
ACDOCUGroup Journal Entries
TF699Items for Statistical Net Income in SAP S/4HANA
TF194Hierarchies, Version- and Period Category-Dependent
TF115Subitems
TFIN001ID Combination Rules for Cons Type and Cons Org. Unit
TF100Financial Statement Items
TF180Consolidation Groups
TF661Equity Holdings Adjustments by Upper Unit
TF193Hierarchies, Version-Dependent
TF202Structure Versions
TF107ATFS Item Attribute Texts
TF170Position of Contact Person
TF111Subitem Categories: Description
TF163Consolidation Units, Version/Period-Based Attributes
TF220Equity Versions
TF510Validation of Consolidation Documents
TF506Document Types: Field-Dependent Properties
TF90QDConsolidation: Levels of Multilevel Attributes
TF330Data Entry Groups: Layout Assignments
TFIN000Independent Characteristic Values for Consolidation Type
TF321Financial Data Types: Description
TF199BOrganizational Elements: Texts
TFMIG04Allocation: FS Item -> FS Item
TF900Assignment of Field Names EC-CS -> SAP S/4HANA
TFIN004Consolidation Types: Description
TF188Consolidation Group Assignment of Task Group
TFMIG02Allocation: Company -> Consolidation Unit
TF293Assignment of Source Tasks to Copy Task
TF181Consolidation Groups: Texts
TFMIG06Assignment: Version -> Legacy Data Version
TF503Chart-Based Document Type Attributes
TF222Hidden Reserve (Fair Value Adjustment) Versions
TF227Retained Earnings Versions: Name
TF373Nested Validation Rules
TF415FS Items for Posting Trans. Diffs with Effect on Earnings
TF374Fields Used in Validation Rules
TF201Versions: Name
TF000_GEN_TRIGConsolidation: Trigger for Generation
TF501Document Types: Name
TF152Dimensions, Screen List, Consolidation Units
ECMCOSAP Cons.: Object Table Assignment Fields (Object/Partner)
TF641Fair Value Adjustments: Subnumber
TF000_GEN_ERRConsolidation: Logging of Generation Errors
TF204Data Entry Versions
TF326Period Categories: Name
TF810Top Groups, Organizational Changes
TF821Organizational Changes: Texts
TF390Selected Items for Carryforwards
TF375Validation Steps: Node Structure
TF070Replication of Consolidation Hierarchies
TF090Interactive Excel Attributes
TF236Versions: Attributes
TF660Equity Holdings Adjustments
TF020Textinformation for Domains
TF189AInactive Consolidation Units per Consolidation Group
TF191Hierarchies: texts
TF652Activity Numbers - Sequence - Sort Status
TF168Consolidation Units Ledger-Dependent
TF004SAP Consolidation: Global Parameter (User-Dependent)
TF311Data Entry Groups: Name
TFMIG03Allocation: Subgroup -> Consolidation Group
TF540Consolidation Tasks
TF822Organizational Changes: Version/Time-Dependent
TF212Versions for Selected FS Items
TFBW1Data streams into BW
TF0FDData Model Consolidation: Field Dependencies
TF592Elimination of IU Profit/Loss in Inventory: FS Items
TFMIG01Allocation: Ledger -> Ledger
TF615C/I Tasks: Assignment of Document Types
TF583Dimension-Dep.Assignmt of CoA, Prod. Group to in(NOT USED)
TF103ABreakdown Categories: Breakdown Info per Subassignment
TF108RFS Item Accounting Roles: Assignment to FS Items
TF556AIU Elimination Methods: Allocation of Addtl Acct Assignments
TFMIG13Migration: Control Sets
TF241Consolidation Frequencies: Name
TF575Tasks for CG Changes: Document Type Assignments
TF90QActive Attributes in Consolidation
TF592AElimination of IU Profit/Loss in Inventory: FS Items
TF692Global Chart of Accounts-Based Settings for C/I
TF218Investment Versions
TF184Consolidation Groups, Version- and Year-Dependent
TF238Report Rule Versions
TF182Consolidation Groups, Version-Dependent
TFBW0Destination and Target InfoCube for Data Transfer into BW
TF101FS Items: Short and Medium Texts
TF0FAData Model Consolidation: Field Attributes
TF107AVFS Item Attribute Values
TF235Versions for Elim. IU Profit/Loss in Inventory: Descriptions
TF693Subitems for Equity Aging Report
MCDX2Compressed Consolidation transaction data
TF599Global Settings for Elim. of IU P/L in Inventory
TF581Product Groups: Description
TF658Activities: Reported Items - Equity
TF280User-Defined Tasks
TF9N1Master Data Table: &
TF107RTFS Item, Accounting Roles, Texts
TF531Task Groups: Name
TF213Selected Item Versions: Description
TF562Assignment of Method/Doc. Type to Task in Reclassification
TF071Replication of Consolidation Hierarchies: Timestamp
TF183Consolidation Groups, Version- and Period Categ.-Dependent
TF395Balance Carryforward - Account Numbers to Be Carried Forward
TF107AVTFS Item Attribute Values, Texts
TF635Goodwill/Neg.Goodwill
TF642Fair Value Adjustments: Name
TF644Fair Value Adjustments: Cons Chart of Accounts-Sensitive
TF310Data Entry Groups
TF011Generate Request Screen: Formating Instructions
TF643Fair Value Adjustments: Version/Date-Sensitive
TF605C/I Methods: Assignments
TF380SAP Cons.: Upload Methods
TF646Recorded Fair Value Adjustments
TF820Organizational Change Numbers
TF161Consolidation Units: Texts
TF23EConsolidation Unit Attribute Special Version
TFIN201Mapping of Secondary Cost Elements to FS Items: Details
TF162Consolidation Unit Correspondence
TF133Items: Identifiers
TF655C/I Entry of Activities: Default Values
TF214Tax Rate Versions
TF231Task Versions: Names
TF659Activities: Reported Items for Push-down Goodwill
TF151Dimensions: Texts and User-Specific Names
TF320Financial Data Types
TFIN200Mapping of G/L Charts of Accounts and Target Cons C/As
TF219Investment Versions: Name
TF141Selected FS Items
TF657Activities: Goodwill Treatment
TF010Generate Request Screen: Control Information
TF381Upload Methods: Texts
TFIN005Ledger Selection
TF691C/I - Global Settings
TF232Reclassifications Version
TF107TTTarget Item Categories, Texts
TFMIG15Migration: Status
TF90SBasis Field Catalog Consolidation (Fixed Fields)
TF134AItem Hierarchies: Nodes
TF557Methods: Threshold Value for Posting Differences
TF0FPData Model Consolidation: Field Properties
TF229Versions of goodwill: Description
TF401Translation Methods: Name
TF261CG/CU: Detail Status of Tasks - Data Monitor
TFIN010Consolidation Unit Integration
TF080List Directory of MCDX
TF500Document Types
TF325Period Categories
TF107RFS Item, Accounting Roles
TF211Ledger Versions: Name
TFIN003Consolidation Types
TF541Consolidation Tasks: Name
TF532Task Groups: Task Assignments
TF666Scope of Reported Data for Equity Method - Descriptions
TF350Download: Assign CG PC Path
TF23FConsolidation Unit Attribute Special Version: Description
TF692AItems for Statistical Goodwill in SAP S/4HANA
TF009SAP Consolidation: Logging Execution Reports
TF584Assignment of Inventory Item to Product Group
TF199DChar. Values of Organizational Elements: Texts
TF183AConsolidation Groups - Restricted Task Groups
TF116Subitems: Short and Medium Texts
TF106FS Item Categories: Description
TF586Supplier Data
TF340Data Entry Profiles
TF130FS Item Hierarchies
TF008SAP Consolidation: Authorization for S/4HANA Consolidation
TF23CVersions FS Item Attributes
TF335Scaling Factor for Online Entry
ECMCTSAP Cons.: Totals Table
TF616C/I Activities/Acctg Techniques: Document Type Assignments
TF131Item Hierarchies: Name
TF223Hidden Reserve Versions: Name
TF192Hierarchies, Period-Dependent
TF215Tax Rate Versions: Name
TF550Methods
TF234Versions for Elimination of IU Profit/Loss in Inventory
TF425Exchange Rate Indicators: ER Type Assignments
TF140Selected FS Items
TF640Fair Value Adjustments
TF120Consolidation Charts of Accounts
TFMIG11Migration: Control for Cons Charts of Accounts
TF667Reported Items for Equity Holdings Adjustments
TF543Consolidation Tasks: Assignments of Methods and Doc.Types
TF271CG/CU: Detail Status of Tasks - Consolidation Monitor
TF000Timestamp for Generating Consolidation
TF502Postable Item Categories
TFIN300Derivation of Customer No. from Country/CO-PA: G/L Accounts
TF90FDActive Field Catalog - Consolidation, Char. Dependencies
TF245Consolidation Cycle
TFBW2Mapping InfoObjects -> Field Names
TF370Equivalency Table in MC Validations
TF556Methods for IU Elimination: Item Set Assignments
EWUCS01SAP Cons.-EURO: Selected FS Items for Euro Conversion
TF165Consolidation Units Version-Dependent
TF001SAP Cons.: Global Specifications
TFBW3Data streams from BW
TF610Tasks for the Consolidation of Investments
TF382Upload Methods: Field Catalogs
TF216Consolidation of Investment Method Versions
TF247Assignment of Consolidation Cycles to Versions
TF90FActive Field Catalog, Consolidation
TF248Assignment of Consolidation Cycles to Versions
TF362Download: Selection Parameters for Downloading Fin. Data
TF121Consolidation Charts of Accounts: Description
TF635AGoodwill/Neg.Goodwill
TFIN020Assignment of Business Areas to Company Codes
TF221Equity Versions: Name
TF90SDBasis Field Catalog - Consolidation, Char. Dependencies
TF560Methods for Reclassification
TF208Exchange Rate Versions
TF90QSAttributes Basis Field Catalog Consolidation (Fixed Fields)
TF533Task Groups: Preceding Tasks
TF105FS Item Categories
ECMCASAP Consolidation: Journal Entry Table (Actual)
TF505Version-Based Document Type Attributes
TF110Subitem Categories
TF002SAP Cons.: Assignment of Sets -> Items
TF530Task Groups
TF690C/I - System Utilization
TF410Currency Translation Methods: Entries
TF107AFS Item Attributes
TF650C/I Activity Numbers
TF516Journal Entry Layout: Description
TF005SAP Consolidation: Analysis Help
TF003SAP Cons.: Assignments of Items --> Sets
TF154Dimensions year- and period-dependent
TF172Contact Person Assignments
TF240Consolidation Frequencies
TF542Consolidation Tasks, Version-Dependent
TF90MMigration EC-CS - SEM-BCS: Mapping of Field Names
TF564Assignment Method/Doc Type to Task Ext. Docs ConsMonitor
TF104Breakdown Categories: Name
TF593Subassignments of Inventory Items
TF228Versions of Goodwill
TF695Selected Items for Consolidation of Investments
TF696AItems for Statistical Equity Holdings Adjustments in S/4HANA
TF190Hierarchies
TF169Version/Period-Dependent Cons. Units: Tax Rates
TF411Translation Methods: Entries for Subassignments
TF551Methods: Name
TF696Posting Items for the Equity Method
TF006SAP Consolidation: Extended Scope of Function
TF560AReclassification Methods: Fields
TF400Currency Translation Methods
TFMIG05Allocation: Transaction Type -> Subitem
TF620Changes in Investments
TF91QAttributes in Consolidation
TF239Report Rule Versions: Description
TF270CG/CU Overall Status of Consolidation Monitor
TF570Tasks for Manual Posting - Document Type Assignments
TF200Consolidation Versions
TF590Elim. of IU P/L in Inventory: Selected Items (NOT IN USE!)
TF420Exchange Rate Indicators
TFMIG10Migration: Processing Options
TF292Cons Units to be Copied
TFBW4Additional selections
TF102FS Items: Long Texts
TF150Dimensions
TFIN011Mapping of Profit Centers to Profit Center Groups
TF580Product Groups
TF23BFS Group Items Versions: Description
TF199CCharacteristic Values of Organizational Elements
TF421Exchange Rate Indicators: Description
TF197Hierarchy Levels Used
TF600Consolidation of Investments Methods
TF591Elim of IU Profit/Loss in Inventory: FS Items (NOT USED)
TF371Time Stamps for Parsing of Validations
TF504Year- and Version-Dependent Document Type Properties
TFIN002LLock Mode During Rollup per Int. Cons Type and Dimension
TF164Consolidation Unit Year-Dependent
TF91FField Catalog, Consolidation
TF285Log Archiving
TF260Overall Status of CG/CU - Data Monitor
TF203Structure Versions: Name
TF584AAssignment of Inventory Item to Product Group (NOT USED)
TF697Posting Items for Push-down Accounting
TF595Elimination of IU Profit/Loss in Inventory: Tasks
TF515Journal Entry Layout: Field Names
TF233Reclassification Versions: Description
TFMIG12Migration: Control for Subitem Categories
TF224Versions of Eliminated Hidden Reserves (FVA)
TF91FDField Catalog - Consolidation, Characteristic Dependencies
TF545Consolidation Tasks: Exceptions for Cons Units
TF372Time Stamps for Parsing of Rules
TF040Default Values for Subassignments
TFIN002Assignment of Consolidation Types and Dimensions
TF226Retained Earnings Versions
TF103Breakdown Categories
TF205Data Entry Versions: Name
TF250Periods, Opened/Closed
TF360Download: Selection Parameters for Special Download
TF361Download: Selection Parameters for General Download
TF602C/I Methods: Cons Chart of Accounts-Based Settings
TF210Ledger Versions
TF665Scope of Reported Data for the Equity Method
TF544Tasks: Task Group Exceptions
TF166Consolidation Units Version- and Period Category-Dependent
TF206Translation Method Versions
TF651Activity Numbers - Sequence
TF572Data Transfer Tasks: Document Type Assignment
ECMCCSAP Cons.: Object Table Movement Attributes
TF585Inventory Data
TF209Exchange Rate Versions: Name
TF558IU Elimination Methods: Reclassi. for Proportional Cons.
TF517Journal Entry Layout: Field Names
TF823Organizational Changes: Group Assignment
TF290Copy Tasks
TF171Position of Contact Person: Description
TF134Item Hierarchies: Nodes
TF237Attribute Versions: Description
TF107TTarget Item Categories
TF230Task Versions
TF155Dimensions: Assign Task Groups
TF242Consolidation Periods
TF160Consolidation Units
TF23AFS Group Items Versions
TF246Consolidation Cycles - Texts
TF291Cons Groups to be Copied
TF108TTarget Items: Assignment to FS Items
TF23DVersions FS Item Attributes: Description
TF189Assignment of CG/CU, Version- and Period-Dependent
TF199EOrganizational Element Relationships
TF262History of Data Entry Layouts
TF167Consolidation Units Version- and Period-Dependent
TF555Methods for Interunit Elimination