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





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
SNAPSHOT_IDSWLT_D_RTM_SNAPSHOT_IDRAW16 SWLT: snapshot id
.INCLUDESWLT_S_CODE_LINE_KEY Identifier / Key for Code Line
PROGNAMEREPIDCHAR40 ABAP Program Name
PROGKINDSWLT_D_PROGKINDCHAR1 Program kind
PROCTYPESQLMPROCTYPECHAR4 SQL Monitor: Processing Block Type
PROCNAMESQLMPROCNAMECHAR93 SQL Monitor: Processing Block Name
PROCLINESQLMPROCLINEINT410 SQL Monitor: Line Number in Processing Block
RUNLEVELSQLMRUNLEVELCHAR1 SQL Monitor: Run Mode
ROOTTYPESQLMROOTTYPECHAR1 SQL Monitor: Request Type
ROOTNAMESQLMROOTNAMECHAR60 SQL Monitor: Request Entry Point (Transaction, etc.)
STMTKINDSQLMSTMTKINDCHAR1 SQL Monitor: SQL Operation
TABLE_GROUP_IDSWLT_D_IDRAW16 SWLT ID
TABLE_NAMESSWLT_D_TABLE_NAMESCHAR171 Table names (comma separated)
INCLUDESWLT_D_INCLUDE_NAMECHAR40
*
Include Name
LINESWLT_D_INCLUDE_LINEINT410 Include Line
OBJ_NAMESOBJ_NAMECHAR40 Object Name in Object Directory
OBJ_TYPETROBJTYPECHAR4 Object Type
PACKAGE_NAMEDEVCLASSCHAR30
*
Package
RTMINSQLMRUNTIMEMINDEC31(3) SQL Monitor: Minimum Value of Execution Time
RTMAXSQLMRUNTIMEMAXDEC31(3) SQL Monitor: Maximum Value of Execution Time
RTCNTSQLMEXECNTINT410 SQL Monitor: Total Number of Executions
RTSUMSQLMRUNTIMESUMDEC31(3) SQL Monitor: Total Execution Time
RTSQSSQLMRUNTIMESQSDEC31(6) SQL Monitor: Runtime Sum of Squares
RTAVGSQLMRUNTIMEAVGDEC31(3) SQL Monitor: Mean Value of Execution Time
RTDEVSQLMRUNTIMEDEVDEC31(3) SQL Monitor: Standard Deviation of Execution Time
DBMINSQLMDBCOUNTMININT410 SQL Monitor: Minimum Value of Fetched / Modified Records
DBMAXSQLMDBCOUNTMAXINT410 SQL Monitor: Maximum Value of Fetched / Modified Records
DBCNTSQLMDBCOUNTCNTINT410 SQL Monitor: DB Count Count
DBSUMSQLMDBCOUNTSUMDEC31 SQL Monitor: Total Fetched or Modified Records



DBSQSSQLMDBCOUNTSQSDEC31 SQL Monitor: DB Count Sum of Squares
DBAVGSQLMDBCOUNTAVGDEC31(3) SQL Monitor: Mean Value of Fetched / Modified Records
DBDEVSQLMDBCOUNTDEVDEC31(3) SQL Monitor: Standard Deviation of Fetched / Modif. Records
RCNTSQLMROLLAREACNTINT410 SQL Monitor: Internal Sessions Affected
XCNTRCNTSQLMEXECNTROLLAREACNTDEC31(3) SQL Monitor: Executions per Internal Sessions



Key field
Non-key field