SAP ABAP View SQLMSHCVDITM (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	SQLMSHCVDITM
Short Description	SQL Monitor: View on Data Records With Info and Table Names
Root table	SQLMSHCD	SQL Monitor: Data / Request

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SQLMSHCD	SQLMSHCD
2	SQLMSHCI
3	SQLMST
4	SQLMSM

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