The DBAPHAL table in SAP ERP or S/4HANA stores Object Status data. There are total 16 fields in DBAPHAL table. The Object Status 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 DBAPHAL 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 DBAPHAL Table Fields
Following is the list of fields that are available in SAP DBAPHAL table. The primary key fields of Object Status 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), OBJNAME (Fully-qualified object name), OBJPARTB (First partition of the database object), PHASE_NR (Operation phase number).
| 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) | |
| OBJNAME | Fully-qualified object name | SDBA_OBNA | CHAR (100) | |
| OBJPARTB | First partition of the database object | SDBA_OBPA | NUMC (10) | |
| PHASE_NR | Operation phase number | SDBA_PHASE | NUMC (10) | |
| UPD_OP | Update Time Stamp | SDBA_UPD | CHAR (14) | |
| PHASE_NAME | Name of utility phase | SDBA_PHNA | CHAR (30) | |
| STATUS | Status: STARTED, RUNNING, COMPLETED | SDBA_STAT | CHAR (30) | |
| BEGIN_OP | Suboperation Start Time | SDBA_BEGT | CHAR (14) | |
| END_OP | End of Suboperation | SDBA_ENDT | CHAR (14) | |
| RC | Return code for DBA action | SDBA_RC | NUMC (4) |
