| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | SYS_ID | Database system ID | nvarchar | 8 | 0 | CHAR | (N' ') | No | | SDBA_DBSID | Allow NULL? |
| 2 | OPER_ID | Unique operation ID | nvarchar | 14 | 0 | CHAR | (N' ') | No | | SDBA_OP_ID | Allow NULL? |
| 3 | TASKNAME | Task Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | | SDBA_TASK | Allow NULL? |
| 4 | JOB_NR | Unique Job Number in a Task | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | SDBA_JOB | Allow NULL? |
| 5 | TRIAL | Unique ID Number of the Suboperation | nvarchar | 10 | 0 | CHAR | (N' ') | No | | SDBA_TRIAL | Allow NULL? |
| 6 | UTIL_NR | Utility number within job step | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | SDBA_UTNR | Allow NULL? |
| 7 | FUNC_ID | DBA Function ID | nvarchar | 3 | 0 | CHAR | (N' ') | No | | SDBA_FID | Allow NULL? |
| 8 | REC_NR | Unique record number for file | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SDBA_RECNR | Allow NULL? |
| 9 | UPD_OP | Update Time Stamp | nvarchar | 14 | 0 | CHAR | (N' ') | No | | SDBA_UPD | Allow NULL? |
| 10 | DBF_ID | File ID (Oracle) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SDBA_FI_ID | Allow NULL? |
| 11 | TSP_NAME | Tablespace name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SDBA_TSP | Allow NULL? |
| 12 | TSP_STATUS | Tablespace status | char | 1 | 0 | CHAR | (N' ') | Yes | | SDBA_TSSTA | Allow NULL? |
| 13 | DBF_STATUS | Data file status | char | 1 | 0 | CHAR | (N' ') | Yes | | SDBA_FISTA | Allow NULL? |
| 14 | TIME_BEG | Data file backup start time | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | SDBA_BEGBU | Allow NULL? |
| 15 | TIME_END | End of data file backup | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | SDBA_ENDBU | Allow NULL? |
| 16 | REDO_BEG | Redo log number at start of data file backup | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SDBA_RDBEG | Allow NULL? |
| 17 | REDO_END | Redo log number at end of data file backup | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SDBA_RDEND | Allow NULL? |
| 18 | VOLUME | Name of backup volume | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SDBA_VOL | Allow NULL? |
| 19 | FILE_POS | Position of file on storage device | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SDBA_FPOS | Allow NULL? |
| 20 | COMP_RATE | Compression rate | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SDBA_COMPR | Allow NULL? |
| 21 | UTIL_BID | SID of a backup file (using external backup program) | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SDBA_BID | Allow NULL? |
| 22 | FILE_NAME | Complete path including file name | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SDBA_PATH | Allow NULL? |
| 23 | FILE_SIZE | File size | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SDBA_FI_SI | Allow NULL? |
| 24 | INTERNAL | For internal purposes | nvarchar | 255 | 0 | CHAR | (N' ') | No | | SDBA_INT | Allow NULL? |