The DBABARL table in SAP ERP or S/4HANA stores Data Backup – Data Recovery data. There are total 11 fields in DBABARL table. The Data Backup – Data Recovery 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 DBABARL 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 DBABARL Table Fields
Following is the list of fields that are available in SAP DBABARL table. The primary key fields of Data Backup – Data Recovery 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_TYPE | Object type | SDBA_OTYPE | CHAR (64) | |
| BU_TYPE | Backup type | SDBA_BUTYP | CHAR (15) | |
| BU_METHOD | Backup method | SDBA_BUMET | CHAR (15) |
