SAP ABAP Table SQLMVDITM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SQLMVDITM	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	TABLENAME0	☑	SQLMTABLENAME	DBOBJ_NAME	CHAR	16	0	SQL Monitor: Table Name
13	INCLUDE	☐	PROGNAME	PROGNAME	CHAR	40	0	ABAP Program Name
14	LINE	☐	INT4	INT4	INT4	10	0	Natural number
15	PGMID	☐	PGMID	PGMID	CHAR	4	0	Program ID in Requests and Tasks
16	OBJECT	☐	TROBJTYPE	OBJECT	CHAR	4	0	Object Type
17	OBJ_NAME	☐	SOBJ_NAME	SOBJ_NAME	CHAR	40	0	Object Name in Object Directory
18	DEVCLASS	☐	DEVCLASS	DEVCLASS	CHAR	30	0	Package
19	XCNT	☐	SQLMEXECNT		INT4	10	0	SQL Monitor: Total Number of Executions
20	RCNT	☐	SQLMROLLAREACNT		INT4	10	0	SQL Monitor: Internal Sessions Affected
21	XCNTRCNT	☐	SQLMEXECNTROLLAREACNT	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Executions per Internal Sessions
22	RTMIN	☐	SQLMRUNTIMEMIN	SQLMRUNTIME	DEC	31	3	SQL Monitor: Minimum Value of SQL Execution Time
23	RTMAX	☐	SQLMRUNTIMEMAX	SQLMRUNTIME	DEC	31	3	SQL Monitor: Maximum Value of Database Execution Time
24	RTCNT	☐	SQLMRUNTIMECNT		INT4	10	0	SQL Monitor: Count
25	RTSUM	☐	SQLMRUNTIMESUM	SQLMRUNTIME	DEC	31	3	SQL Monitor: Summarized Database Execution Time [ms]
26	RTSQS	☐	SQLMRUNTIMESQS	SQLMDECIMAL6	DEC	31	6	SQL Monitor: Runtime Sum of Squares
27	RTAVG	☐	SQLMRUNTIMEAVG	SQLMRUNTIME	DEC	31	3	SQL Monitor: Mean Value of DB Execution Time
28	RTDEV	☐	SQLMRUNTIMEDEV	SQLMRUNTIME	DEC	31	3	SQL Monitor: Standard Deviation of Database Execution Time
29	DBMIN	☐	SQLMDBCOUNTMIN		INT4	10	0	SQL Monitor: Minimum Value of Processed Records
30	DBMAX	☐	SQLMDBCOUNTMAX		INT4	10	0	SQL Monitor: Maximum Value of Processed Records
31	DBCNT	☐	SQLMDBCOUNTCNT		INT4	10	0	SQL Monitor: DB Count Count
32	DBSUM	☐	SQLMDBCOUNTSUM	SQLMINTEGER	DEC	31	0	SQL Monitor: Total Processed Records
33	DBSQS	☐	SQLMDBCOUNTSQS	SQLMINTEGER	DEC	31	0	SQL Monitor: DB Count Sum of Squares
34	DBAVG	☐	SQLMDBCOUNTAVG	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Mean Value of Processed Records
35	DBDEV	☐	SQLMDBCOUNTDEV	SQLMDECIMAL3	DEC	31	3	SQL Monitor: Standard Deviation of Processed Records

History

Last changed by/on	SAP	20141013
SAP Release Created in