SAP ABAP Table DBABD (Information About the Data 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
⤷ 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 | DBABD | Table Relationship Diagram |
Short Description | Information About the Data 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 | SYS_ID | SDBA_DBSID | CHAR8 | CHAR | 8 | 0 | Database system ID | ||
2 | OPER_ID | SDBA_OP_ID | CHAR14 | CHAR | 14 | 0 | Unique operation ID | ||
3 | TASKNAME | SDBA_TASK | SDBA_TASK | CHAR | 30 | 0 | Task Name | ||
4 | JOB_NR | SDBA_JOB | SDBA_JOB | NUMC | 10 | 0 | Unique Job Number in a Task | ||
5 | TRIAL | SDBA_TRIAL | CHAR10 | CHAR | 10 | 0 | Unique ID Number of the Suboperation | ||
6 | UTIL_NR | SDBA_UTNR | SDBA_UTNR | NUMC | 10 | 0 | Utility number within job step | ||
7 | FUNC_ID | SDBA_FID | SDBA_FUNCT | CHAR | 3 | 0 | DBA Function ID | ||
8 | REC_NR | SDBA_RECNR | CHAR4 | CHAR | 4 | 0 | Unique record number for file | ||
9 | UPD_OP | SDBA_UPD | SDBA_UPD | CHAR | 14 | 0 | Update Time Stamp | ||
10 | DBF_ID | SDBA_FI_ID | CHAR4 | CHAR | 4 | 0 | File ID (Oracle) | ||
11 | TSP_NAME | SDBA_TSP | SDBA_TSP | CHAR | 30 | 0 | Tablespace Name | ||
12 | TSP_STATUS | SDBA_TSSTA | SDBA_TSSTA | CHAR | 1 | 0 | Tablespace status | ||
13 | DBF_STATUS | SDBA_FISTA | SDBA_FISTA | CHAR | 1 | 0 | Data file status | ||
14 | TIME_BEG | SDBA_BEGBU | SDBA_TSTMP | CHAR | 14 | 0 | Data file backup start time | ||
15 | TIME_END | SDBA_ENDBU | SDBA_TSTMP | CHAR | 14 | 0 | End of data file backup | ||
16 | REDO_BEG | SDBA_RDBEG | CHAR8 | CHAR | 8 | 0 | Redo log number at start of data file backup | ||
17 | REDO_END | SDBA_RDEND | CHAR8 | CHAR | 8 | 0 | Redo log number at end of data file backup | ||
18 | VOLUME | SDBA_VOL | CHAR10 | CHAR | 10 | 0 | Name of backup volume | ||
19 | FILE_POS | SDBA_FPOS | NUMC4 | NUMC | 4 | 0 | Position of file on storage device | ||
20 | COMP_RATE | SDBA_COMPR | CHAR10 | CHAR | 10 | 0 | Compression rate | ||
21 | UTIL_BID | SDBA_BID | CHAR16 | CHAR | 16 | 0 | SID of a backup file (using external backup program) | ||
22 | FILE_NAME | SDBA_PATH | CHAR255 | CHAR | 255 | 0 | Complete path including file name | ||
23 | FILE_SIZE | SDBA_FI_SI | CHAR12 | CHAR | 12 | 0 | File size | ||
24 | INTERNAL | SDBA_INT | CHAR255 | CHAR | 255 | 0 | For internal purposes |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |