SAP MaxDB Tables

Are you looking for the right table related to SAP MaxDB 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 MaxDB (BC-DB-SDB) module.

Top 10 tables in MaxDB

TableDescription
DBANBuffer for dban_state
ADATABSIZESAP DB: Table Sizes Including Indexes in KB
SDBTREETXTSAP DB: CCMS Navigation Trees - Node Texts
SDBDBMRFC2SAP DB: Current DBMRFC Sessions
SDBCTRLSAP DB: CCMS Control Table
SDBPAHISAP DB: Parameter History
ADACACHEInformation About SAP DB Cache Access
ADAASAP DB: Directory of Valid DBA Actions
SDBTREEDEFSAP DB: CCMS Navigation Trees - Node Definition
SDBADSDBDBA calendar: planning- vs. R/3 exec.vs. DB exec. times

List of tables in MaxDB

TableDescription
DBANBuffer for dban_state
ADATABSIZESAP DB: Table Sizes Including Indexes in KB
SDBTREETXTSAP DB: CCMS Navigation Trees - Node Texts
SDBDBMRFC2SAP DB: Current DBMRFC Sessions
SDBCTRLSAP DB: CCMS Control Table
SDBPAHISAP DB: Parameter History
ADACACHEInformation About SAP DB Cache Access
ADAASAP DB: Directory of Valid DBA Actions
SDBTREEDEFSAP DB: CCMS Navigation Trees - Node Definition
SDBADSDBDBA calendar: planning- vs. R/3 exec.vs. DB exec. times
SDBCCMSMaxDB/liveCache CCMS: Monitoring Data Repository
SDBUPDEXCLMaxDB: Exception Table for UPDATE STAT... ESTIMATE
DBH_CONFIGDBH Settings
SDBDBMRFCSAP DB: DBMRFC Control Table
SADA_FEATURESHANA festures
SDBSYSTEMSOverview of Integrated SAP DB and liveCache Systems
SDBUSRSETUser Settings for Transactions LC10 and DB50
SDBAHSDBSAP DB: DBA History
SDB_DS_TABL_DIFFException Tables for the MaxDB Federator
SDBAADAUPDSAP DB: Log Table for Update Statistics and Checks