SAP CCMS / Database Monitors for Oracle Tables
Are you looking for the right table related to SAP CCMS / Database Monitors for Oracle 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 CCMS / Database Monitors for Oracle (BC-DB-ORA-CCM) module.
Top 10 tables in CCMS / Database Monitors for Oracle
| Table | Description |
|---|---|
| DBSMSGORA | Structure for DB System Check Messages (Acc. to DBMSGORA) |
| DBCHECKORA | Configuration of Database Check |
| DBAFIZ | General information (n:1) |
| SDBAR | DBA Resource Table |
| DBAERR | Look-Up Table for Database Operation Errors |
| DBATRIAL | Look-Up Tables for Database Sub-Operations |
| DBATL | Central Task / Job Information |
| SDBMONDDDB | DB Monitor: permanent storage of SAP consistency check |
| DBSTATS | Control for Application Monitor and CBO: Setup |
| DBTMPORA | DB Optimizer Control (Statistics Creation) |
List of tables in CCMS / Database Monitors for Oracle
| Table | Description |
|---|---|
| DBSMSGORA | Structure for DB System Check Messages (Acc. to DBMSGORA) |
| DBCHECKORA | Configuration of Database Check |
| DBAFIZ | General information (n:1) |
| SDBAR | DBA Resource Table |
| DBAERR | Look-Up Table for Database Operation Errors |
| DBATRIAL | Look-Up Tables for Database Sub-Operations |
| DBATL | Central Task / Job Information |
| SDBMONDDDB | DB Monitor: permanent storage of SAP consistency check |
| DBSTATS | Control for Application Monitor and CBO: Setup |
| DBTMPORA | DB Optimizer Control (Statistics Creation) |
| DBAREOL | Reorganization |
| ORAPARTGENDDL | Generated DDL Statements for partitioning |
| DBAOPTL | DB Optimization - Table Statistics |
| SDBAD | Detail Table for DBA Logs |
| DBATID | Lookup Table for Database Tasks |
| DBAML | Job / Job Step Utility View |
| SDBMON | Permanent Storage for the Database Monitor |
| SDBAH | Header Table for DBA Logs |
| DBADFL | Details About Reorganization and Memory Modifications |
| DBAPHAL | Object Status |
| DBAEXTL | Memory Space Changes |
| SDBAP | DBA Planning Table |
| DBAOBJL | Object Status |
| DBACUST | Tool-Specific Settings for DB24 |
| DBABL | Information About Archive Log Files (Oracle) |
| DBAGRP | Lookup Table Operation Group Tables |
| DBMSGORA | Database Check: Messages |
| ORAPARTAL | Analysed Data for Oracle Partition Engine |
| ORAPARTADMIN | Control Data for Oracle Partition Engine |
| DBABD | Information About the Data Files (Oracle) |
| SDBAC | DBA Action Table |
| DBABARL | Data Backup - Data Recovery |
| DBSTATC | Configuration of Statistics Creation |
| DBASPAL | Memory Allocation |
| DBARCL | Sub-operations |
| ORAPARTADMDAT | Control Data for Oracle Partition |
| SORAMON | Oracle: Permanent Storage for the Oracle Database Monitor |
| DBAFID | Look-Up Table for Database Operations |