SAP Data Collection Tables

Are you looking for the right table related to SAP Data Collection 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 Data Collection (EC-EIS-DCM) module.

Top 10 tables in Data Collection

TableDescription
TKAFAField catalog: Accounting, table assignment
TKCCOComment tables
TKCKUKKey figure assignment to groups
CF006Balance Sheet
CF050Balance sheet/P&L (FI/FILC)
COIX_DATA40Cluster table infosystem
TKEBZExceptions (threshold values, colors)
T28NNMaster Data Texts: &
T242XSAP-EIS: Data Transfer: Origin Parameters
TKEV6technical report information per variant

List of tables in Data Collection

TableDescription
TKAFAField catalog: Accounting, table assignment
TKCCOComment tables
TKCKUKKey figure assignment to groups
CF006Balance Sheet
CF050Balance sheet/P&L (FI/FILC)
COIX_DATA40Cluster table infosystem
TKEBZExceptions (threshold values, colors)
T28NNMaster Data Texts: &
T242XSAP-EIS: Data Transfer: Origin Parameters
TKEV6technical report information per variant
T242WValue types
T242TTexts
TKCVSTVersion texts (EC-EIS)
TKCDMData mining methods
TKCTULanguage Table: Key Figure Assignment Groups
KCSLVSAP-EIS: data slices - variables - parameters
TKCOHSAP-EIS: Object hierarchy for object collector
TKCKOFormula Operators
TKCMPVTEC-BP: Parameterization Texts for Planning Runs
TKCBOREC-EIS: Assignment DDIC - Objects in BOR
T242AAspects
TKCFTGLanguage table for field groups
CF005Personnel Information
T241BDescription of Characteristic Values
KCVARTSAP-EIS: data slice variable meanings
TKCJJoin (view) tables for CO drill down
TKCTOLanguage Table: Formula Operators
TKCFDSAP-EIS Field Catalog, Dependencies between Characteristics
T241SSender field description
KCSLTSAP-EIS: data slice meaning
TKCKCKC Applications
T242PWindow management
TKEV2Background variants for drill-down reporting (text)
TKAQGeneral accounting attributes
TKEC2Comment management for fields
KCSLUSAP-EIS: assigning data slices to users
TKCHHSAP-EIS: Hierarchy header
CFNNNReference structure for aspect tables SAP-EIS
T242ZHierarchy index
TKCOUSAP-EIS: Key description for object class
TKCHHTSAP-EIS: Texts for hierarchy header
TKCKKey figures
TKTFRSAP-EIS, table field assignment
TKCMPVEC-BP: Parameterization for Automatic Planning Runs
TKCUMEIS: Conversion table of new fixed fields 4.0
TKCSBasic field catalog SAP-EIS (fixed fields)
TKCFSAP-EIS Field Catalog
T242VData area (previously version)
CF003Projects
TKEBWDescription of exceptions
T2421Parameter groups for system control parameters in SAP-EIS
TKCTABFIEEC-EIS: Table-specific field properties
COIX_DATAControlling: Info system cluster tables
TKCFGField groups for structure generation
TKEV1Background variants for drill-down reporting
KCSLASAP-EIS: assigning data slices to tables
TKCKFKey Figure Formula Stages
T241ZUser profile text table
TKCDTData mining method text
TKCKUKey Figure Assignment Groups
T241HText for report portfolio hierarchy
T242HHierarchies in report portfolio
TKCOMSAP-EIS: Method table
TKCHWSAP-EIS: Hierarchy data
TRKB1UTable with "Customizing settings" for drilldown reporting
TKCDBMax. homogenousness
TKCSDBasic field catalog SAP-EIS, linked characteristics
T2411Description of parameter groups
T242NReport composed of individual windows
T242DData transfer control
TKCORSAP-EIS: Transport Attributes of Collected Objects
COIXControlling: Info system cluster tables
TKED3Key figures for object displayed in data mining
T242SSAP-EIS: Collection programs and sender structures
TKEBYExceptions (reference to reporting object)
T27NNMaster Data Table: &
TKCCCEIS: Currency translation with data entry / planning
CF002Human Resources
T241EText to sort reports into report portfolio
TKED1Library of results from data mining processing
TKCKTKey figures, Table assignment (SAP-EIS)
TKEBGGraphic settings for hierarchy graphic
KCSLSAP-EIS: Data slices
T778P2Plan versions
T241WDescription of value type
KCVARSAP-EIS: data slice variables
T241VData Area Text
TKCHNTSAP-EIS: Hierarchy node texts
T2410Language table system control parameters
TKCFASAP-EIS Field Catalog, Aspect Assignment
TKCFGFFields of the field groups for structure generation
TKEBXAdministration of exceptions
TKCQDSAP-EIS: levels of multilevel attributes
TKCOHWSAP-EIS:Criteria for finding dep. objects for obj. collector
KCSLOSAP-EIS: Selection requirements for data slices
CF001Profitability Analysis
T242ESort reports into report portfolio
TKCQSAttributes of basic field catalog SAP-EIS (fixed fields)
TKCHVSAP-EIS: Hierarchy variants
TKCAAspects
TKAFDGeneral CO field catalog, compound characteristics
TKCDOMin. homogeneousness
T242ISender information
TKAFField catalog for Accounting
TKDPSystem settings for drill-down reporting
TKED2Data mining display object
TKCTKLanguage Table for Key Figures
TKCHVTSAP-EIS: Description of hierarchy variants
TKCCFormula Constants
TKCODTSAP-EIS: Texts for object types in object list
TKEV5Texts for variant groups
TKEV3Variant group
TKCVSVersion table (EC-EIS)
TKEC1Comment management for characteristic attributes
TKCHNSAP-EIS Hierarchy nodes
TKCODSAP-EIS: Object types in the object list
TKCKAKey Figures, Aspect Assignment (SAP-EIS)
TKCQAttributes SAP-EIS
TKEV4Variant groups (master data)
T242BCharacteristic values per characteristic