| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | REFRDATE | Date of last refresh of transaction DB02 | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DB2DB02DAT | Allow NULL? |
| 2 | REFRTIME | Time of the last refresh of transaction DB02 | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | DB2DB02TIM | Allow NULL? |
| 3 | DBSYS | Central Database System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SYDBSYS | Allow NULL? |
| 4 | SYSID | Concatenation of SAP system IDs in an DB2 subsystem | nvarchar | 103 | 0 | CHAR | (N' ') | Yes | | DB2SYSIDS | Allow NULL? |
| 5 | R3SIZE | Total size allocated by the R/3 System (KB) | decimal | 14 | 0 | DEC | ((0)) | Yes | | DB2R3SIZT | |
| 6 | R3FREE | Total free space in the R/3 System (KB) | decimal | 14 | 0 | DEC | ((0)) | Yes | | DB2R3FREET | |
| 7 | R3PCTUSED | Percentage of used size to allocated size of the R/3 System | decimal | 5 | 0 | DEC | ((0)) | Yes | | DB2R3PCTU | |
| 8 | TSNUM | Number of tablespaces in the R/3 system | decimal | 8 | 0 | DEC | ((0)) | Yes | | DB2TSNUM | |
| 9 | TSSIZE | Total size of all R/3 tablespaces (allocated storage in kB) | decimal | 13 | 0 | DEC | ((0)) | Yes | | DB2TSSIZT | |
| 10 | TSFREE | Total free size of all R/3 tablespaces in KB | decimal | 13 | 0 | DEC | ((0)) | Yes | | DB2TSFREET | |
| 11 | TSPCTUSED | Percentage of used size to allocated size of all tablespaces | decimal | 3 | 0 | DEC | ((0)) | Yes | | DB2TSPCTUT | |
| 12 | IXNUM | Number of indexes in the R/3 system | decimal | 8 | 0 | DEC | ((0)) | Yes | | DB2IXNUM | |
| 13 | IXSIZE | Total size of all R/3 indexes (allocated storage in kB) | decimal | 13 | 0 | DEC | ((0)) | Yes | | DB2IXSIZT | |
| 14 | IXFREE | Total free size of all R/3 indexes in KB | decimal | 13 | 0 | DEC | ((0)) | Yes | | DB2IXFREET | |
| 15 | IXPCTUSED | Percentage of used size to allocated size of all indexes | decimal | 3 | 0 | DEC | ((0)) | Yes | | DB2IXPCTUT | |
| 16 | TBNUM | Number of tables in the R/3 system | decimal | 8 | 0 | DEC | ((0)) | Yes | | DB2TBNUM | |
| 17 | TBSIZE | Total size of all R/3 tables (used storage in KB) | decimal | 13 | 0 | DEC | ((0)) | Yes | | DB2TBSIZT | |
| 18 | TBMISSDB | Number of tables missing in the database | decimal | 8 | 0 | DEC | ((0)) | Yes | | DB2TBMISDB | |
| 19 | IXMISSDB | Number of indexes missing in the database | decimal | 8 | 0 | DEC | ((0)) | Yes | | DB2IXMISDB | |
| 20 | TBMISSDDIC | Number of tables missing in the ABAP/4 dictionary | decimal | 8 | 0 | DEC | ((0)) | Yes | | DB2TBMISDD | |
| 21 | IXMISSDDIC | Number of indexes missing in the ABAP dictionary | decimal | 8 | 0 | DEC | ((0)) | Yes | | DB2IXMISDD | |
