SAP Reporting Framework Tables

Are you looking for the right table related to SAP Reporting Framework 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 Reporting Framework (CRM-BTX-ANA-RFW) module.

Top 10 tables in Reporting Framework

TableDescription
CRMC_Q1O_CACHE_HHeader table for cache maintenance
CRMD_DHR_ISLSORDSales order item buffer table
CRMC_REPDY_DBDB Access Description for Dynamic Access
CRMC_Q1O_CACHEList maximum entries for cache tables
CRMC_PPM_OPSPD_TOpportunity Velocity in sales cycle (texts)
CRMD_DHR_LEADLeads
CRMC_Q1O_FIELDSField names for One Order Search
CRMC_PPM_PAR_FCTQueries for Partner Functions
CRMD_DH_QRESQuery Result Buffer
CRM_STACOM_ATTRStatus Common Attributes

List of tables in Reporting Framework

TableDescription
CRMC_Q1O_CACHE_HHeader table for cache maintenance
CRMD_DHR_ISLSORDSales order item buffer table
CRMC_REPDY_DBDB Access Description for Dynamic Access
CRMC_Q1O_CACHEList maximum entries for cache tables
CRMC_PPM_OPSPD_TOpportunity Velocity in sales cycle (texts)
CRMD_DHR_LEADLeads
CRMC_Q1O_FIELDSField names for One Order Search
CRMC_PPM_PAR_FCTQueries for Partner Functions
CRMD_DH_QRESQuery Result Buffer
CRM_STACOM_ATTRStatus Common Attributes
CRMC_MAL_OBJOne Order MAL Object
CRMD_DH_DATA_OPPOpportunity Data Buffer
CRMD_PPM_OPPBUFIRealtime Buffer-Supported Fields of All Opportunity Items
CRMD_DHR_SERVICEService Tickets
CRMD_DHR_ISLSQUOSales Quotation item buffer table
CRMD_MC_GUIDMass create report saved GUIDs
CRMD_DHR_HSLSAGRSales agreements
CRMC_PAR_FCT_NAMCorresponding names of partner functions
CRMC_MAP_RF2DSMappin ReportingFrameworksources to Datasourcetargets
CRMC_RF_MAPHDIMMappin for fields that have the same name on header and item
CRMD_DHR_ISLSCONSales contract item buffer table
CRMD_DHR_HSLSORDSales Orders
CRMC_IREE_FLD_RFFields Enhanced by IREE Tool
CRMC_BPCCKPTPB_TTexts Assigned for Push Buttons in Cockpit
CRMD_DHR_PPMOPPIOpportunity item data buffer for PPM
CRMC_BP_CCKPT_PBAssignment of Transactions to Pushbuttons in BP Cockpit
CRMD_DHR_HSLSCONSales Contracts
CRMC_REPDYControl Table for Dyn. Access (CL_CRM_REPORT_ACC_DYNAMIC)
CRMD_DHR_ITEMSRVService item buffer table
CRMD_DH_DATA_MANData Buffer Management
CRMD_DHR_ACTIVActivities
CRMC_Q1O_OBJMaintenance of Object Types for 1O
CRMD_DHR_DAT_OPPOpportunity Data Buffer
CRMD_RF_TRACEDBTest Queries for FS
CRMC_RF_RELSELselection Relation between Reporting and search area fields
CRMC_PPM_OPSPDOpportunity Velocity
CRMD_DHR_HSRVORDService Orders
CRMD_DHR_HSLSQUOSales Quotations
CRMD_DHR_ICOMPLComplaint item buffer table
CRMC_IREE_FLD_BIInteractive Reporting Easy Enhancement BI Fields
CRMD_DHR_HSRVRIPService request/incident and problem
CRMD_DHR_ISRVORDService order item buffer table
CRMD_RF_TRACEDBWWhere clauses
CRMD_DHR_HCOMPLComplaint
CRMC_Q1O_RFWMappingfapplication to Reporting Framework result strucs
CRMD_DHR_ISLSAGRSales agreements item buffer table
CRMD_DH_QTERMQuery Term Buffer
CRMT_LOCA_CSIDLocator Customizing: Search IDs
CRMC_Q1O_RESAssignment of Resultstructure to Buffer Table
CRMC_PPM_VELRULEThresholds for Opportunity Velocity Rules
CRMC_RF_MAPRESMapping between Reporting and Cache fields with length > 16
CRMD_PPM_OPPBUFRealtime Buffer-Supported Fields of All Opportunities
CRMD_DH_STATEStatus Information of Delta Handler
CRMD_DHR_HEADOPPOpportunities
CRM_STACOM_TEXTStatus Common Descriptions
CRMD_DH_QUERYQuery Buffer
CRMD_DHR_DATAOPPPPM Opportunities
CRMD_DHR_PPMOPPPPM Opportunities with Items
CRMD_DHR_ITEMOPPOpportunity item buffer table