The DBAOPTL table in SAP ERP or S/4HANA stores DB Optimization – Table Statistics data. There are total 15 fields in DBAOPTL table. The DB Optimization – Table Statistics table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DBAOPTL table. It is in DBA: Database-Independent Code (SDBA) ABAP package and is part of the CCMS / Database Monitors for Oracle (BC-DB-ORA-CCM) module.
SAP DBAOPTL Table Fields
Following is the list of fields that are available in SAP DBAOPTL table. The primary key fields of DB Optimization – Table Statistics table in SAP are SYS_ID (Database system ID), OPER_ID (Unique operation ID), TASKNAME (Task Name), JOB_NR (Unique Job Number in a Task), TRIAL (Unique ID Number of the Suboperation), UTIL_NR (Utility number within job step), FUNC_ID (DBA Function ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| SYS_ID | Database system ID | SDBA_DBSID | CHAR (8) | |
| OPER_ID | Unique operation ID | SDBA_OP_ID | CHAR (14) | |
| TASKNAME | Task Name | SDBA_TASK | CHAR (30) | |
| JOB_NR | Unique Job Number in a Task | SDBA_JOB | NUMC (10) | |
| TRIAL | Unique ID Number of the Suboperation | SDBA_TRIAL | CHAR (10) | |
| UTIL_NR | Utility number within job step | SDBA_UTNR | NUMC (10) | |
| FUNC_ID | DBA Function ID | SDBA_FID | CHAR (3) | |
| UPD_OP | Update Time Stamp | SDBA_UPD | CHAR (14) | |
| OBJ | Object of DB operation | SDBA_OBJ30 | CHAR (30) | |
| ANALY_METH | Analysis Method | SDBA_ANME | CHAR (30) | |
| ANALY_OPTI | Analysis method | SDBA_OPT | CHAR (30) | |
| TABLES | Number of statistics to be checked | SDBA_TAB | CHAR (12) | |
| TAB_CHECK | Number of checked statistics | SDBA_CHK | CHAR (12) | |
| TAB_OLD | Number of tables with statistics that need to be updated | SDBA_OLD | CHAR (12) | |
| TAB_REFR | Number of tables with updated statistics | SDBA_REF | CHAR (12) |
