DBAPHAL - Object Status
Object Status information is stored in SAP table DBAPHAL.
It is part of development package SDBA in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "DBA: Database-Independent Code".
It is part of development package SDBA in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "DBA: Database-Independent Code".
Fields for table DBAPHAL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYS_ID | Database system ID | X | SDBA_DBSID | CHAR | 8 | |
| OPER_ID | Unique operation ID | X | SDBA_OP_ID | CHAR | 14 | |
| TASKNAME | Task Name | X | SDBA_TASK | CHAR | 30 | |
| JOB_NR | Unique Job Number in a Task | X | SDBA_JOB | NUMC | 10 | |
| TRIAL | Unique ID Number of the Suboperation | X | SDBA_TRIAL | CHAR | 10 | |
| UTIL_NR | Utility number within job step | X | SDBA_UTNR | NUMC | 10 | |
| FUNC_ID | DBA Function ID | X | SDBA_FID | CHAR | 3 | |
| OBJNAME | Fully-qualified object name | X | SDBA_OBNA | CHAR | 100 | |
| OBJPARTB | First partition of the database object | X | SDBA_OBPA | NUMC | 10 | |
| PHASE_NR | Operation phase number | X | 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 |