SWLT_SQLM_D - SWLT: Display data from SQL Monitor test
SWLT: Display data from SQL Monitor test information is stored in SAP table SWLT_SQLM_D.
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_SQLM_D
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | SWLT: snapshot id | X | SWLT_D_RTM_SNAPSHOT_ID | RAW | 16 | |
| .INCLUDE | CODE_LINE_KEY | X | SWLT_S_CODE_LINE_KEY | 0 | ||
| PROGNAME | ABAP Program Name | X | REPID | CHAR | 80 | |
| PROGKIND | Program kind | X | SWLT_D_PROGKIND | CHAR | 2 | |
| PROCTYPE | SQL Monitor: Processing Block Type | X | SQLMPROCTYPE | CHAR | 8 | |
| PROCNAME | SQL Monitor: Processing Block Name | X | SQLMPROCNAME | CHAR | 186 | |
| PROCLINE | SQL Monitor: Line Number in Processing Block | X | SQLMPROCLINE | INT4 | 4 | |
| RUNLEVEL | SQL Monitor: Run Mode | X | SQLMRUNLEVEL | CHAR | 2 | |
| ROOTTYPE | SQL Monitor: Request Type | X | SQLMROOTTYPE | CHAR | 2 | |
| ROOTNAME | SQL Monitor: Request Entry Point (Transaction, etc.) | X | SQLMROOTNAME | CHAR | 120 | |
| STMTKIND | SQL Monitor: SQL Operation | X | SQLMSTMTKIND | CHAR | 2 | |
| TABLE_GROUP_ID | SWLT ID | X | SWLT_D_ID | RAW | 16 | |
| TABLE_NAMES | Table names (comma separated) | SWLT_D_TABLE_NAMES | CHAR | 342 | ||
| INCLUDE | Include Name | SWLT_D_INCLUDE_NAME | CHAR | 80 | * | |
| LINE | Include Line | SWLT_D_INCLUDE_LINE | INT4 | 4 | ||
| OBJ_NAME | Object Name in Object Directory | SOBJ_NAME | CHAR | 80 | ||
| OBJ_TYPE | Object Type | TROBJTYPE | CHAR | 8 | ||
| PACKAGE_NAME | Package | DEVCLASS | CHAR | 60 | * | |
| RTMIN | SQL Monitor: Minimum Value of SQL Execution Time | SQLMRUNTIMEMIN | DEC | 16 | ||
| RTMAX | SQL Monitor: Maximum Value of Database Execution Time | SQLMRUNTIMEMAX | DEC | 16 | ||
| RTCNT | SQL Monitor: Total Number of Executions | SQLMEXECNT | INT4 | 4 | ||
| RTSUM | SQL Monitor: Summarized Database Execution Time [ms] | SQLMRUNTIMESUM | DEC | 16 | ||
| RTSQS | SQL Monitor: Runtime Sum of Squares | SQLMRUNTIMESQS | DEC | 16 | ||
| RTAVG | SQL Monitor: Mean Value of DB Execution Time | SQLMRUNTIMEAVG | DEC | 16 | ||
| RTDEV | SQL Monitor: Standard Deviation of Database Execution Time | SQLMRUNTIMEDEV | DEC | 16 | ||
| DBMIN | SQL Monitor: Minimum Value of Processed Records | SQLMDBCOUNTMIN | INT4 | 4 | ||
| DBMAX | SQL Monitor: Maximum Value of Processed Records | SQLMDBCOUNTMAX | INT4 | 4 | ||
| DBCNT | SQL Monitor: DB Count Count | SQLMDBCOUNTCNT | INT4 | 4 | ||
| DBSUM | SQL Monitor: Total Processed Records | SQLMDBCOUNTSUM | DEC | 16 | ||
| DBSQS | SQL Monitor: DB Count Sum of Squares | SQLMDBCOUNTSQS | DEC | 16 | ||
| DBAVG | SQL Monitor: Mean Value of Processed Records | SQLMDBCOUNTAVG | DEC | 16 | ||
| DBDEV | SQL Monitor: Standard Deviation of Processed Records | SQLMDBCOUNTDEV | DEC | 16 | ||
| RCNT | SQL Monitor: Internal Sessions Affected | SQLMROLLAREACNT | INT4 | 4 | ||
| XCNTRCNT | SQL Monitor: Executions per Internal Sessions | SQLMEXECNTROLLAREACNT | DEC | 16 | ||
| FRAGMENT | SQL Monitor: Source Code Fragment | SQLMFRAGMENT | CHAR | 510 | ||
| OUTDATED | SQL Monitor: Outdated | SQLMOUTDATED | CHAR | 2 |