| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | TABID | MS SQL Server table object id | int | 10 | 0 | INT4 | ((0)) | No | | MSSTABID | Allow NULL? |
| 2 | TABNAME | MS SQL Server object name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MSSOBJNAME | Allow NULL? |
| 3 | LUPDSTAT | Analysis date (yyyymmddhhmm) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AM_DATE | Allow NULL? |
| 4 | UPDDURATE | Execution duration of an operation in seconds. | int | 10 | 0 | INT4 | ((0)) | Yes | | MSSDURATE | Allow NULL? |
| 5 | LCHCKTABLE | Analysis date (yyyymmddhhmm) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AM_DATE | Allow NULL? |
| 6 | CHCKDURATE | Execution duration of an operation in seconds. | int | 10 | 0 | INT4 | ((0)) | Yes | | MSSDURATE | Allow NULL? |
| 7 | CHECKTYPE | MS SQL Server type of check action | char | 1 | 0 | CHAR | (N' ') | Yes | | MSSCHKTYPE | Allow NULL? |
| 8 | NROWS | Number of rows in a table | decimal | 15 | 0 | DEC | ((0)) | Yes | | OROWS | |
| 9 | DPAGES | MS SQL Server number of data pages in table | int | 10 | 0 | INT4 | ((0)) | Yes | | MSSDPAGES | Allow NULL? |
| 10 | RESERVED | MS SQL Server reserved pages for table | int | 10 | 0 | INT4 | ((0)) | Yes | | MSSTBRESVD | Allow NULL? |
| 11 | USED | MS SQL Server number of used pages of a table | int | 10 | 0 | INT4 | ((0)) | Yes | | MSSTBUSED | Allow NULL? |
| 12 | TOTIDXPG | MS SQL Server number of index pages for all idx of one table | int | 10 | 0 | INT4 | ((0)) | Yes | | MSSTOTIDXP | Allow NULL? |
| 13 | RESIMTXTPG | MS SQL Server number of reserved image + text pages of table | int | 10 | 0 | INT4 | ((0)) | Yes | | MSSRESIMTX | Allow NULL? |
| 14 | USDIMTXTPG | MS SQL Server number of used image or text pages for table | int | 10 | 0 | INT4 | ((0)) | Yes | | MSSUSDIMTX | Allow NULL? |
