SAP ABAP Table SQLMSHCD (SQL Monitor: Data / Request)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-TOO-RTA (Application Component) Runtime Analysis
     ⤷ SQLM_CORE (Package) SQL Monitor Core

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SQLMSHCD	Table Relationship Diagram
Short Description	SQL Monitor: Data / Request

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SNAPSHOTID	☑	SQLMSNAPSHOTID	SYSUUID	RAW	16	0	SQL Monitor: Snapshot ID
2	.INCLUDE	☑				0	0	SQL Monitor: Key (Source)
3	PROGNAME	☑	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
4	PROGKIND	☑	SQLMPROGKIND	SQLMPROGKIND	CHAR	1	0	SQL Monitor: Program Kind
5	PROCTYPE	☑	SQLMPROCTYPE		CHAR	4	0	SQL Monitor: Processing Block Type
6	PROCNAME	☑	SQLMPROCNAME		CHAR	93	0	SQL Monitor: Processing Block Name
7	PROCLINE	☑	SQLMPROCLINE		INT4	10	0	SQL Monitor: Line Number in Processing Block
8	HASHCODE	☑	SQLMHASHCODE	SQLMCRC64	RAW	8	0	SQL Monitor: Source Hash Code
9	.INCLUDE	☑				0	0	SQL Monitor: Subkey (Internal)
10	RUNLEVEL	☑	SQLMRUNLEVEL	SQLMRUNLEVEL	CHAR	1	0	SQL Monitor: Run Mode
11	ROOTTYPE	☑	SQLMROOTTYPE	SQLMROOTTYPE	CHAR	1	0	SQL Monitor: Request Type
12	ROOTNAME	☑	SQLMROOTNAME		CHAR	60	0	SQL Monitor: Request Entry Point (Transaction, etc.)
13	STMTKIND	☑	SQLMSTMTKIND	SQLMSTMTKIND	CHAR	1	0	SQL Monitor: SQL Operation
14	TABLENAME	☑	SQLMTABLENAME	DBOBJ_NAME	CHAR	16	0	SQL Monitor: Table Name
15	.INCLUDE	☐				0	0	SQL Monitor: Payload
16	XCNT	☐	SQLMEXECNT		INT4	10	0	SQL Monitor: Total Number of Executions
17	.INCLUDE	☐				0	0	SQL Monitor: Rollarea
18	RCNT	☐	SQLMROLLAREACNT		INT4	10	0	SQL Monitor: Internal Sessions Affected
19	XCNTRCNT	☐	SQLMEXECNTROLLAREACNT	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Executions per Internal Sessions
20	.INCLUDE	☐				0	0	SQL Monitor: Runtime
21	RTMIN	☐	SQLMRUNTIMEMIN	SQLMRUNTIME	DEC	31	3	SQL Monitor: Minimum Value of SQL Execution Time
22	RTMAX	☐	SQLMRUNTIMEMAX	SQLMRUNTIME	DEC	31	3	SQL Monitor: Maximum Value of Database Execution Time
23	RTCNT	☐	SQLMRUNTIMECNT		INT4	10	0	SQL Monitor: Count
24	RTSUM	☐	SQLMRUNTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Summarized Database Execution Time [ms]
25	RTSQS	☐	SQLMRUNTIMESQS	SQLMDECIMAL6	DEC	31	6	SQL Monitor: Runtime Sum of Squares
26	RTAVG	☐	SQLMRUNTIMEAVG	SQLMRUNTIME	DEC	31	3	SQL Monitor: Mean Value of DB Execution Time
27	RTDEV	☐	SQLMRUNTIMEDEV	SQLMRUNTIME	DEC	31	3	SQL Monitor: Standard Deviation of Database Execution Time
28	.INCLUDE	☐				0	0	SQL Monitor: DB Count
29	DBMIN	☐	SQLMDBCOUNTMIN		INT4	10	0	SQL Monitor: Minimum Value of Processed Records
30	DBMAX	☐	SQLMDBCOUNTMAX		INT4	10	0	SQL Monitor: Maximum Value of Processed Records
31	DBCNT	☐	SQLMDBCOUNTCNT		INT4	10	0	SQL Monitor: DB Count Count
32	DBSUM	☐	SQLMDBCOUNTSUM	SQLMINTEGER	DEC	31	0	SQL Monitor: Total Processed Records
33	DBSQS	☐	SQLMDBCOUNTSQS	SQLMINTEGER	DEC	31	0	SQL Monitor: DB Count Sum of Squares
34	DBAVG	☐	SQLMDBCOUNTAVG	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Mean Value of Processed Records
35	DBDEV	☐	SQLMDBCOUNTDEV	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Standard Deviation of Processed Records
36	DDATE	☐	RTMDDATE	SYDATS	DATS	8	0	Date for Runtime Monitor DATA entry
37	DTIME	☐	D_TIME	SYTIME	TIMS	6	0	Time for Runtime Monitor data entry
38	RTMCNT	☐	SQLMRTMCNT		INT4	10	0	SQL Monitor: RTM Count

History

Last changed by/on	SAP	20141013
SAP Release Created in	740