| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | TNAME | Table name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TNAME | Allow NULL? |
| 2 | ANDAT | Update Time Stamp | nvarchar | 14 | 0 | CHAR | (N' ') | No | | SDBA_UPD | Allow NULL? |
| 3 | VWTYP | Type of Usage of Table Entry | nvarchar | 2 | 0 | CHAR | (N' ') | No | | AM_VWTYP | Allow NULL? |
| 4 | AMETH | Analysis Method for Collecting Statistics | nvarchar | 4 | 0 | CHAR | (N' ') | No | | AM_AMETH | Allow NULL? |
| 5 | OPTIO | Sample Size for Collection of Statistics | nvarchar | 5 | 0 | CHAR | (N' ') | No | | AM_OPTIO | Allow NULL? |
| 6 | NROWS | Number of rows in a table | decimal | 15 | 0 | DEC | ((0)) | No | | OROWS | |
| 7 | OCCBL | Used blocks of a table in KB | decimal | 11 | 0 | DEC | ((0)) | No | | UBLOCKS_KB | |
| 8 | EMPBL | Empty blocks of a table in kb | decimal | 11 | 0 | DEC | ((0)) | No | | EBLOCKS_KB | |
| 9 | AFREE | Avg. freespace in a used data base block | int | 10 | 0 | INT4 | ((0)) | No | | OAVG_BFREE | Allow NULL? |
| 10 | CHAIN | Number of rows requiring block chaining | decimal | 15 | 0 | DEC | ((0)) | No | | OCHAINED | |
| 11 | AROWL | Average row length (Oracle result) | decimal | 7 | 0 | DEC | ((0)) | No | | OAVG_ROW_L | |
| 12 | HWMBL | Empty blocks (kb) above High Water Mark | decimal | 11 | 0 | DEC | ((0)) | No | | HWBLKS_KB | |
| 13 | INDBS | Used blocks of an index-Btree (kb) | decimal | 15 | 0 | DEC | ((0)) | No | | BBLOCKS_KB | |
