SAP ABAP View SQLMHCVDI (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	SQLMHCVDI
Short Description	SQL Monitor: View on Data and Info Records
Root table	SQLMHCD	SQL Monitor: Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SQLMHCD	SQLMHCD
2	SQLMHCI

Join Conditions

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

View Fields

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