SAP ABAP View SQLMSHCVDI (SQL Monitor: View on Data and Info Records)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	SQLMSHCVDI
Short Description	SQL Monitor: View on Data and Info Records
Root table	SQLMSHCD	SQL Monitor: Data / Request

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SQLMSHCD	SQLMSHCD
2	SQLMSHCI

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SQLMSHCD	SNAPSHOTID	JL	EQ				0	0
2	SQLMSHCI	SNAPSHOTID	JR	EQ			AND	0	0
3	SQLMSHCD	PROGNAME	JL	EQ				0	0
4	SQLMSHCI	PROGNAME	JR	EQ			AND	0	0
5	SQLMSHCD	PROGKIND	JL	EQ				0	0
6	SQLMSHCI	PROGKIND	JR	EQ			AND	0	0
7	SQLMSHCD	PROCTYPE	JL	EQ				0	0
8	SQLMSHCI	PROCTYPE	JR	EQ			AND	0	0
9	SQLMSHCD	PROCNAME	JL	EQ				0	0
10	SQLMSHCI	PROCNAME	JR	EQ			AND	0	0
11	SQLMSHCD	PROCLINE	JL	EQ				0	0
12	SQLMSHCI	PROCLINE	JR	EQ			AND	0	0
13	SQLMSHCD	HASHCODE	JL	EQ				0	0
14	SQLMSHCI	HASHCODE	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	SNAPSHOTID	SQLMSHCD	SNAPSHOTID		☐	SQLMSNAPSHOTID	☐	SQL Monitor: Snapshot ID
2	PROGNAME0	SQLMSHCD	PROGNAME		☐	PROGNAME	☐	ABAP Program Name
3	PROGKIND0	SQLMSHCD	PROGKIND		☐	SQLMPROGKIND	☐	SQL Monitor: Program Kind
4	PROCTYPE	SQLMSHCD	PROCTYPE		☐	SQLMPROCTYPE	☐	SQL Monitor: Processing Block Type
5	PROCNAME	SQLMSHCD	PROCNAME		☐	SQLMPROCNAME	☐	SQL Monitor: Processing Block Name
6	PROCLINE	SQLMSHCD	PROCLINE		☐	SQLMPROCLINE	☐	SQL Monitor: Line Number in Processing Block
7	HASHCODE	SQLMSHCD	HASHCODE		☐	SQLMHASHCODE	☐	SQL Monitor: Source Hash Code
8	RUNLEVEL	SQLMSHCD	RUNLEVEL		☐	SQLMRUNLEVEL	☐	SQL Monitor: Run Mode
9	ROOTTYPE	SQLMSHCD	ROOTTYPE		☐	SQLMROOTTYPE	☐	SQL Monitor: Request Type
10	ROOTNAME	SQLMSHCD	ROOTNAME		☐	SQLMROOTNAME	☐	SQL Monitor: Request Entry Point (Transaction, etc.)
11	STMTKIND	SQLMSHCD	STMTKIND		☐	SQLMSTMTKIND	☐	SQL Monitor: SQL Operation
12	TABLENAMES	SQLMSHCD	TABLENAME		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
13	PROGNAME	SQLMSHCI	PROGNAME0		☐	PROGNAME	☐	ABAP Program Name
14	PROGKIND	SQLMSHCI	PROGKIND0		☐	SQLMPROGKIND	☐	SQL Monitor: Program Kind
15	INCLUDE	SQLMSHCI	INCLUDE		☐	PROGNAME	☐	ABAP Program Name
16	LINE	SQLMSHCI	LINE		☐	INT4	☐	Natural number
17	FRAGMENT	SQLMSHCI	FRAGMENT		☐	SQLMFRAGMENT	☐	SQL Monitor: Source Code Fragment
18	PGMID	SQLMSHCI	PGMID		☐	PGMID	☐	Program ID in Requests and Tasks
19	OBJECT	SQLMSHCI	OBJECT		☐	TROBJTYPE	☐	Object Type
20	OBJ_NAME	SQLMSHCI	OBJ_NAME		☐	SOBJ_NAME	☐	Object Name in Object Directory
21	DEVCLASS	SQLMSHCI	DEVCLASS		☐	DEVCLASS	☐	Package
22	PROGDATE	SQLMSHCI	PROGDATE		☐	SQLMPROGDATE	☐	SQL Monitor: Program Date
23	PROGTIME	SQLMSHCI	PROGTIME		☐	SQLMPROGTIME	☐	SQL Monitor: Program Time
24	OUTDATED	SQLMSHCI	OUTDATED		☐	SQLMOUTDATED	☐	SQL Monitor: Outdated
25	XCNT	SQLMSHCD	XCNT		☐	SQLMEXECNT	☐	SQL Monitor: Total Number of Executions
26	RCNT	SQLMSHCD	RCNT		☐	SQLMROLLAREACNT	☐	SQL Monitor: Internal Sessions Affected
27	XCNTRCNT	SQLMSHCD	XCNTRCNT		☐	SQLMEXECNTROLLAREACNT	☐	SQL Monitor: Executions per Internal Sessions
28	RTMIN	SQLMSHCD	RTMIN		☐	SQLMRUNTIMEMIN	☐	SQL Monitor: Minimum Value of SQL Execution Time
29	RTMAX	SQLMSHCD	RTMAX		☐	SQLMRUNTIMEMAX	☐	SQL Monitor: Maximum Value of Database Execution Time
30	RTCNT	SQLMSHCD	RTCNT		☐	SQLMRUNTIMECNT	☐	SQL Monitor: Count
31	RTSUM	SQLMSHCD	RTSUM		☐	SQLMRUNTIMESUM	☐	SQL Monitor: Summarized Database Execution Time [ms]
32	RTSQS	SQLMSHCD	RTSQS		☐	SQLMRUNTIMESQS	☐	SQL Monitor: Runtime Sum of Squares
33	RTAVG	SQLMSHCD	RTAVG		☐	SQLMRUNTIMEAVG	☐	SQL Monitor: Mean Value of DB Execution Time
34	RTDEV	SQLMSHCD	RTDEV		☐	SQLMRUNTIMEDEV	☐	SQL Monitor: Standard Deviation of Database Execution Time
35	DBMIN	SQLMSHCD	DBMIN		☐	SQLMDBCOUNTMIN	☐	SQL Monitor: Minimum Value of Processed Records
36	DBMAX	SQLMSHCD	DBMAX		☐	SQLMDBCOUNTMAX	☐	SQL Monitor: Maximum Value of Processed Records
37	DBCNT	SQLMSHCD	DBCNT		☐	SQLMDBCOUNTCNT	☐	SQL Monitor: DB Count Count
38	DBSUM	SQLMSHCD	DBSUM		☐	SQLMDBCOUNTSUM	☐	SQL Monitor: Total Processed Records
39	DBSQS	SQLMSHCD	DBSQS		☐	SQLMDBCOUNTSQS	☐	SQL Monitor: DB Count Sum of Squares
40	DBAVG	SQLMSHCD	DBAVG		☐	SQLMDBCOUNTAVG	☐	SQL Monitor: Mean Value of Processed Records
41	DBDEV	SQLMSHCD	DBDEV		☐	SQLMDBCOUNTDEV	☐	SQL Monitor: Standard Deviation of Processed Records
42	RTMCNT	SQLMSHCD	RTMCNT		☐	SQLMRTMCNT	☐	SQL Monitor: RTM Count

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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