| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | TABLE_NAME | Table name | nvarchar | 30 | 0 | CHAR | (N' ') | No | | /SDF/TABLENAME | Allow NULL? |
| 2 | COLUMN_NAME | Column name | nvarchar | 60 | 0 | CHAR | (N' ') | No | | /SDF/COLUMNNAME | Allow NULL? |
| 3 | PART_ID | Partition ID | int | 10 | 0 | INT4 | ((0)) | No | | /SDF/PARTID | Allow NULL? |
| 4 | KEYFLAG | Identifies a primary key field | char | 1 | 0 | CHAR | (N' ') | Yes | | /SDF/PKFIELD | Allow NULL? |
| 5 | HAS_INDEX | Identifies a secondary key field | char | 1 | 0 | CHAR | (N' ') | Yes | | /SDF/SKFIELD | Allow NULL? |
| 6 | NOPK_TYPE | Identify a table with no primary key | char | 1 | 0 | CHAR | (N' ') | Yes | | /SDF/NKFIELD | Allow NULL? |
| 7 | MS_TOTAL | Total memory size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/MS | |
| 8 | MS_MAIN | Main memory size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/MAINS | |
| 9 | EST_MS_MAIN | Estimated memory size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/ESTMS | |
| 10 | RECORD_COUNT | Number of records in the table | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/RECCOUNT | |
| 11 | DISTINCT_COUNT | Disctinct count | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/DISTCOUNT | |
| 12 | LOADED | Load status | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | /SDF/LOADED | Allow NULL? |
| 13 | INDEX_LOADED | Index load status | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | /SDF/KEYLOADED | Allow NULL? |
| 14 | COMPRESSION_TYPE | Compression type | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | /SDF/COPMTYPE | Allow NULL? |
| 15 | MS_DICT | Dictionnary size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/DICTMS | |
| 16 | EST_MS_DICT | Estimated dictionnary size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/ESTDICTMS | |
| 17 | MS_INDEX | Index memory size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/INDEXMS | |
| 18 | EST_MS_INDEX | Estimated index memory size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/ESTINDEXMS | |
| 19 | MS_DATA | Data size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/DATAMS | |
| 20 | EST_MS_DATA | Estimated data memory size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/ESTDATAMS | |
| 21 | MS_MISC | Miscelaneous size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/MISCMS | |
| 22 | EST_MS_MISC | Estimated miscelaneous size in bytes | decimal | 20 | 0 | DEC | ((0)) | Yes | | /SDF/ESTMISCMS | |
| 23 | TYPEKIND | Category of dictionnary type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SDF/DATATYPE | Allow NULL? |
| 24 | SIZE_IN_BYTE | Average field size in bytes | decimal | 16 | 2 | DEC | ((0)) | Yes | | /SDF/FIELDSIZE | |
| 25 | LOB_SIZE_IN_BYTE | Average LOB field size in bytes | decimal | 16 | 2 | DEC | ((0)) | Yes | | /SDF/LOBFIELDSIZE | |
