SAP TABLES | Basis Components | ABAP Workbench, Java IDE and Infrastructure | Workbench Tools: Editors, Painters, Modelers(BC-DWB-TOO) SAP BC
SWLT_SQLM_D SAP SWLT: Display data from SQL Monitor test Table and data
SWLT_SQLM_D is a standard SAP Table which is used to store SWLT: Display data from SQL Monitor test data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP SWLT_SQLM_D Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: L - Table for storing temporary data, delivered empty
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories
SAP SWLT_SQLM_D Table fields within data Dictionary
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| SNAPSHOT_ID | SWLT_D_RTM_SNAPSHOT_ID | RAW | 16 | SWLT: snapshot id | ||
| .INCLUDE | SWLT_S_CODE_LINE_KEY | Identifier / Key for Code Line | ||||
| PROGNAME | REPID | CHAR | 40 | ABAP Program Name | ||
| PROGKIND | SWLT_D_PROGKIND | CHAR | 1 | Program kind | ||
| PROCTYPE | SQLMPROCTYPE | CHAR | 4 | SQL Monitor: Processing Block Type | ||
| PROCNAME | SQLMPROCNAME | CHAR | 93 | SQL Monitor: Processing Block Name | ||
| PROCLINE | SQLMPROCLINE | INT4 | 10 | SQL Monitor: Line Number in Processing Block | ||
| RUNLEVEL | SQLMRUNLEVEL | CHAR | 1 | SQL Monitor: Run Mode | ||
| ROOTTYPE | SQLMROOTTYPE | CHAR | 1 | SQL Monitor: Request Type | ||
| ROOTNAME | SQLMROOTNAME | CHAR | 60 | SQL Monitor: Request Entry Point (Transaction, etc.) | ||
| STMTKIND | SQLMSTMTKIND | CHAR | 1 | SQL Monitor: SQL Operation | ||
| TABLE_GROUP_ID | SWLT_D_ID | RAW | 16 | SWLT ID | ||
| TABLE_NAMES | SWLT_D_TABLE_NAMES | CHAR | 171 | Table names (comma separated) | ||
| INCLUDE | SWLT_D_INCLUDE_NAME | CHAR | 40 |
* | Include Name | |
| LINE | SWLT_D_INCLUDE_LINE | INT4 | 10 | Include Line | ||
| OBJ_NAME | SOBJ_NAME | CHAR | 40 | Object Name in Object Directory | ||
| OBJ_TYPE | TROBJTYPE | CHAR | 4 | Object Type | ||
| PACKAGE_NAME | DEVCLASS | CHAR | 30 |
* | Package | |
| RTMIN | SQLMRUNTIMEMIN | DEC | 31(3) | SQL Monitor: Minimum Value of Execution Time | ||
| RTMAX | SQLMRUNTIMEMAX | DEC | 31(3) | SQL Monitor: Maximum Value of Execution Time | ||
| RTCNT | SQLMEXECNT | INT4 | 10 | SQL Monitor: Total Number of Executions | ||
| RTSUM | SQLMRUNTIMESUM | DEC | 31(3) | SQL Monitor: Total Execution Time | ||
| RTSQS | SQLMRUNTIMESQS | DEC | 31(6) | SQL Monitor: Runtime Sum of Squares | ||
| RTAVG | SQLMRUNTIMEAVG | DEC | 31(3) | SQL Monitor: Mean Value of Execution Time | ||
| RTDEV | SQLMRUNTIMEDEV | DEC | 31(3) | SQL Monitor: Standard Deviation of Execution Time | ||
| DBMIN | SQLMDBCOUNTMIN | INT4 | 10 | SQL Monitor: Minimum Value of Fetched / Modified Records | ||
| DBMAX | SQLMDBCOUNTMAX | INT4 | 10 | SQL Monitor: Maximum Value of Fetched / Modified Records | ||
| DBCNT | SQLMDBCOUNTCNT | INT4 | 10 | SQL Monitor: DB Count Count | ||
| DBSUM | SQLMDBCOUNTSUM | DEC | 31 | SQL Monitor: Total Fetched or Modified Records | ||
| DBSQS | SQLMDBCOUNTSQS | DEC | 31 | SQL Monitor: DB Count Sum of Squares | ||
| DBAVG | SQLMDBCOUNTAVG | DEC | 31(3) | SQL Monitor: Mean Value of Fetched / Modified Records | ||
| DBDEV | SQLMDBCOUNTDEV | DEC | 31(3) | SQL Monitor: Standard Deviation of Fetched / Modif. Records | ||
| RCNT | SQLMROLLAREACNT | INT4 | 10 | SQL Monitor: Internal Sessions Affected | ||
| XCNTRCNT | SQLMEXECNTROLLAREACNT | DEC | 31(3) | SQL Monitor: Executions per Internal Sessions | ||
| Key field | |
| Non-key field |