SWLT_TABLE_MD - SWLT: Metadata for tables
SWLT: Metadata for tables information is stored in SAP table SWLT_TABLE_MD.
It is part of development package SWLT in software component BC-DWB-TOO. This development package consists of objects that can be grouped under "SQL Performance Tuning Worklist".
It is part of development package SWLT in software component BC-DWB-TOO. This development package consists of objects that can be grouped under "SQL Performance Tuning Worklist".
Fields for table SWLT_TABLE_MD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSTEM_ID | Name of SAP System | X | SYSYSID | CHAR | 16 | |
| TABLE_NAME | Table Name | X | SWLT_D_TABLE_NAME | CHAR | 32 | |
| TABLE_CLASS | Table Category | TABCLASS | CHAR | 16 | ||
| SIZE_CATEGORY | Size category | TABKAT | CHAR | 4 | ||
| IS_BUFFERED | Buffering flag | BUFFERED | CHAR | 2 | ||
| BUFFERING_KIND | Buffering type indicator | PUFFERUNG | CHAR | 2 | ||
| ROW_OR_COL_STORE | Distinguish between row memory and column memory | DDROWORCOLST | CHAR | 2 | ||
| COLUMN_NUM | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
| KEY_COLUMN_NUM | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
| WIDTH_IN_BYTES | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
| MD_UPDATED_ON | Updated on ... timestamp | SWLT_D_UPDATED_ON | DEC | 8 | ||
| NUMBER_OF_ROWS | Number of rows | SWLT_D_MD_NUMBER_OF_ROWS | DEC | 16 |