SAP ABAP View SQLMHCVDITM (SQL Monitor: View on Data Records With Info and Table Names)

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	SQLMHCVDITM
Short Description	SQL Monitor: View on Data Records With Info and Table Names
Root table	SQLMHCD	SQL Monitor: Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SQLMHCD	SQLMHCD
2	SQLMHCI
3	SQLMT
4	SQLMM

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			AND	0	0
13	SQLMHCD	TABLENAME	JL	EQ				0	0
14	SQLMT	TABLENAME	JR	EQ			AND	0	0
15	SQLMHCD	TABLENAME	JL	EQ				0	0
16	SQLMM	TABLENAME	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	SQLMT	TABLENAMES		☐	SQLMTABLENAMES	☐	SQL Monitor: Table Names
12	TABLENAME	SQLMT	TABLENAME		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
13	TABLENAME0	SQLMM	TABLENAME0		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
14	PROGNAME	SQLMHCI	PROGNAME0		☐	PROGNAME	☐	ABAP Program Name
15	PROGKIND	SQLMHCI	PROGKIND0		☐	SQLMPROGKIND	☐	SQL Monitor: Program Kind
16	INCLUDE	SQLMHCI	INCLUDE		☐	PROGNAME	☐	ABAP Program Name
17	LINE	SQLMHCI	LINE		☐	INT4	☐	Natural number
18	FRAGMENT	SQLMHCI	FRAGMENT		☐	SQLMFRAGMENT	☐	SQL Monitor: Source Code Fragment
19	PGMID	SQLMHCI	PGMID		☐	PGMID	☐	Program ID in Requests and Tasks
20	OBJECT	SQLMHCI	OBJECT		☐	TROBJTYPE	☐	Object Type
21	OBJ_NAME	SQLMHCI	OBJ_NAME		☐	SOBJ_NAME	☐	Object Name in Object Directory
22	DEVCLASS	SQLMHCI	DEVCLASS		☐	DEVCLASS	☐	Package
23	PROGDATE	SQLMHCI	PROGDATE		☐	SQLMPROGDATE	☐	SQL Monitor: Program Date
24	PROGTIME	SQLMHCI	PROGTIME		☐	SQLMPROGTIME	☐	SQL Monitor: Program Time
25	OUTDATED	SQLMHCI	OUTDATED		☐	SQLMOUTDATED	☐	SQL Monitor: Outdated
26	XCNT	SQLMHCD	XCNT		☐	SQLMEXECNT	☐	SQL Monitor: Total Number of Executions
27	RCNT	SQLMHCD	RCNT		☐	SQLMROLLAREACNT	☐	SQL Monitor: Internal Sessions Affected
28	XCNTRCNT	SQLMHCD	XCNTRCNT		☐	SQLMEXECNTROLLAREACNT	☐	SQL Monitor: Executions per Internal Sessions
29	RTMIN	SQLMHCD	RTMIN		☐	SQLMRUNTIMEMIN	☐	SQL Monitor: Minimum Value of SQL Execution Time
30	RTMAX	SQLMHCD	RTMAX		☐	SQLMRUNTIMEMAX	☐	SQL Monitor: Maximum Value of Database Execution Time
31	RTCNT	SQLMHCD	RTCNT		☐	SQLMRUNTIMECNT	☐	SQL Monitor: Count
32	RTSUM	SQLMHCD	RTSUM		☐	SQLMRUNTIMESUM	☐	SQL Monitor: Summarized Database Execution Time [ms]
33	RTSQS	SQLMHCD	RTSQS		☐	SQLMRUNTIMESQS	☐	SQL Monitor: Runtime Sum of Squares
34	RTAVG	SQLMHCD	RTAVG		☐	SQLMRUNTIMEAVG	☐	SQL Monitor: Mean Value of DB Execution Time
35	RTDEV	SQLMHCD	RTDEV		☐	SQLMRUNTIMEDEV	☐	SQL Monitor: Standard Deviation of Database Execution Time
36	DBMIN	SQLMHCD	DBMIN		☐	SQLMDBCOUNTMIN	☐	SQL Monitor: Minimum Value of Processed Records
37	DBMAX	SQLMHCD	DBMAX		☐	SQLMDBCOUNTMAX	☐	SQL Monitor: Maximum Value of Processed Records
38	DBCNT	SQLMHCD	DBCNT		☐	SQLMDBCOUNTCNT	☐	SQL Monitor: DB Count Count
39	DBSUM	SQLMHCD	DBSUM		☐	SQLMDBCOUNTSUM	☐	SQL Monitor: Total Processed Records
40	DBSQS	SQLMHCD	DBSQS		☐	SQLMDBCOUNTSQS	☐	SQL Monitor: DB Count Sum of Squares
41	DBAVG	SQLMHCD	DBAVG		☐	SQLMDBCOUNTAVG	☐	SQL Monitor: Mean Value of Processed Records
42	DBDEV	SQLMHCD	DBDEV		☐	SQLMDBCOUNTDEV	☐	SQL Monitor: Standard Deviation of Processed Records
43	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