SAP ABAP Table SQLMVDIT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SQLMVDIT	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

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

History

Last changed by/on	SAP	20141013
SAP Release Created in