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
| Table | Description |
|---|---|
| DBAN | Buffer for dban_state |
| ADATABSIZE | SAP DB: Table Sizes Including Indexes in KB |
| SDBTREETXT | SAP DB: CCMS Navigation Trees - Node Texts |
| SDBDBMRFC2 | SAP DB: Current DBMRFC Sessions |
| SDBCTRL | SAP DB: CCMS Control Table |
| SDBPAHI | SAP DB: Parameter History |
| ADACACHE | Information About SAP DB Cache Access |
| ADAA | SAP DB: Directory of Valid DBA Actions |
| SDBTREEDEF | SAP DB: CCMS Navigation Trees - Node Definition |
| SDBADSDB | DBA calendar: planning- vs. R/3 exec.vs. DB exec. times |
List of tables in MaxDB
| Table | Description |
|---|---|
| DBAN | Buffer for dban_state |
| ADATABSIZE | SAP DB: Table Sizes Including Indexes in KB |
| SDBTREETXT | SAP DB: CCMS Navigation Trees - Node Texts |
| SDBDBMRFC2 | SAP DB: Current DBMRFC Sessions |
| SDBCTRL | SAP DB: CCMS Control Table |
| SDBPAHI | SAP DB: Parameter History |
| ADACACHE | Information About SAP DB Cache Access |
| ADAA | SAP DB: Directory of Valid DBA Actions |
| SDBTREEDEF | SAP DB: CCMS Navigation Trees - Node Definition |
| SDBADSDB | DBA calendar: planning- vs. R/3 exec.vs. DB exec. times |
| SDBCCMS | MaxDB/liveCache CCMS: Monitoring Data Repository |
| SDBUPDEXCL | MaxDB: Exception Table for UPDATE STAT... ESTIMATE |
| DBH_CONFIG | DBH Settings |
| SDBDBMRFC | SAP DB: DBMRFC Control Table |
| SADA_FEATURES | HANA festures |
| SDBSYSTEMS | Overview of Integrated SAP DB and liveCache Systems |
| SDBUSRSET | User Settings for Transactions LC10 and DB50 |
| SDBAHSDB | SAP DB: DBA History |
| SDB_DS_TABL_DIFF | Exception Tables for the MaxDB Federator |
| SDBAADAUPD | SAP DB: Log Table for Update Statistics and Checks |