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

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SQLMD	SQLMD
2	SQLMI
3	SQLMT

Join Conditions

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

View Fields

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

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