SAP ABAP Table DBABL (Information About Archive Log Files (Oracle))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
⤷
SDBO (Package) Database Administration: Oracle-Specific Components
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | DBABL |
|
| Short Description | Information About Archive Log Files (Oracle) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | S | System table, maint. only by SAP, change = modification |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
SDBA_DBSID | CHAR8 | CHAR | 8 | 0 | Database system ID | ||
| 2 | |
SDBA_OP_ID | CHAR14 | CHAR | 14 | 0 | Unique operation ID | ||
| 3 | |
SDBA_TASK | SDBA_TASK | CHAR | 30 | 0 | Task Name | ||
| 4 | |
SDBA_JOB | SDBA_JOB | NUMC | 10 | 0 | Unique Job Number in a Task | ||
| 5 | |
SDBA_TRIAL | CHAR10 | CHAR | 10 | 0 | Unique ID Number of the Suboperation | ||
| 6 | |
SDBA_UTNR | SDBA_UTNR | NUMC | 10 | 0 | Utility number within job step | ||
| 7 | |
SDBA_FID | SDBA_FUNCT | CHAR | 3 | 0 | DBA Function ID | ||
| 8 | |
SDBA_RECNR | CHAR4 | CHAR | 4 | 0 | Unique record number for file | ||
| 9 | |
SDBA_UPD | SDBA_UPD | CHAR | 14 | 0 | Update Time Stamp | ||
| 10 | |
SDBA_AFU | SDBA_AFU | CHAR | 1 | 0 | Backup function | ||
| 11 | |
SDBA_ANR | CHAR8 | CHAR | 8 | 0 | Archive log sequence number | ||
| 12 | |
SDBA_ATI | CHAR14 | CHAR | 14 | 0 | Offline redo log file creation time | ||
| 13 | |
SDBA_ASC | CHAR16 | CHAR | 16 | 0 | First System Change Number (SCN) of Offline Redo Log File | ||
| 14 | |
SDBA_RTHRD | CHAR4 | CHAR | 4 | 0 | Oracle thread number of the offline redo log file | ||
| 15 | |
SDBA_BEGAR | SDBA_TSTMP | CHAR | 14 | 0 | Offline redo log file backup start time | ||
| 16 | |
SDBA_ENDAR | SDBA_TSTMP | CHAR | 14 | 0 | End of offline redo log file backup | ||
| 17 | |
SDBA_VOL | CHAR10 | CHAR | 10 | 0 | Name of backup volume | ||
| 18 | |
SDBA_FPOS | NUMC4 | NUMC | 4 | 0 | Position of file on storage device | ||
| 19 | |
SDBA_COMPR | CHAR10 | CHAR | 10 | 0 | Compression rate | ||
| 20 | |
SDBA_BID | CHAR16 | CHAR | 16 | 0 | SID of a backup file (using external backup program) | ||
| 21 | |
SDBA_ANA | CHAR255 | CHAR | 255 | 0 | Name of Saved Offline Redo Log File | ||
| 22 | |
SDBA_ASI | CHAR12 | CHAR | 12 | 0 | Size (Bytes) of Saved Offline Redo Log File | ||
| 23 | |
SDBA_INT | CHAR255 | CHAR | 255 | 0 | For internal purposes |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |