SAP ABAP View SQLMZVDISZ (SQL Monitor)

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	SQLMZVDISZ
Short Description	SQL Monitor
Root table	SQLMZD	SQL Monitor: Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SQLMZD	SQLMZD
2	SQLMZI
3	SQLMZS
4	SQLMZZ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SQLMZD	MEASID	JL	EQ				0	0
2	SQLMZI	MEASID	JR	EQ			AND	0	0
3	SQLMZD	INFOID	JL	EQ				0	0
4	SQLMZI	INFOID	JR	EQ			AND	0	0
5	SQLMZD	MEASID	JL	EQ				0	0
6	SQLMZS	MEASID	JR	EQ			AND	0	0
7	SQLMZD	SUBID	JL	EQ				0	0
8	SQLMZS	SUBID	JR	EQ			AND	0	0
9	SQLMZD	MEASID	JL	EQ				0	0
10	SQLMZZ	MEASID	JR	EQ			AND	0	0
11	SQLMZD	TIMEID	JL	EQ				0	0
12	SQLMZZ	TIMEID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MEASID	SQLMZD	MEASID		☐	INT4	☐	Natural number
2	INFOID	SQLMZD	INFOID		☐	INT4	☐	Natural number
3	SUBID	SQLMZD	SUBID		☐	INT4	☐	Natural number
4	TIMEID	SQLMZD	TIMEID		☐	INT4	☐	Natural number
5	PROGNAME	SQLMZI	PROGNAME		☐	PROGNAME	☐	ABAP Program Name
6	PROGKIND	SQLMZI	PROGKIND		☐	SQLMPROGKIND	☐	SQL Monitor: Program Kind
7	PROCTYPE	SQLMZI	PROCTYPE		☐	SQLMPROCTYPE	☐	SQL Monitor: Processing Block Type
8	PROCNAME	SQLMZI	PROCNAME		☐	SQLMPROCNAME	☐	SQL Monitor: Processing Block Name
9	PROCLINE	SQLMZI	PROCLINE		☐	SQLMPROCLINE	☐	SQL Monitor: Line Number in Processing Block
10	HASHCODE	SQLMZI	HASHCODE		☐	SQLMHASHCODE	☐	SQL Monitor: Source Hash Code
11	INCLUDE	SQLMZI	INCLUDE		☐	PROGNAME	☐	ABAP Program Name
12	LINE	SQLMZI	LINE		☐	INT4	☐	Natural number
13	FRAGMENT	SQLMZI	FRAGMENT		☐	SQLMFRAGMENT	☐	SQL Monitor: Source Code Fragment
14	PGMID	SQLMZI	PGMID		☐	PGMID	☐	Program ID in Requests and Tasks
15	OBJECT	SQLMZI	OBJECT		☐	TROBJTYPE	☐	Object Type
16	OBJ_NAME	SQLMZI	OBJ_NAME		☐	SOBJ_NAME	☐	Object Name in Object Directory
17	DEVCLASS	SQLMZI	DEVCLASS		☐	DEVCLASS	☐	Package
18	PROGDATE	SQLMZI	PROGDATE		☐	SQLMPROGDATE	☐	SQL Monitor: Program Date
19	PROGTIME	SQLMZI	PROGTIME		☐	SQLMPROGTIME	☐	SQL Monitor: Program Time
20	OUTDATED	SQLMZI	OUTDATED		☐	SQLMOUTDATED	☐	SQL Monitor: Outdated
21	RUNLEVEL	SQLMZS	RUNLEVEL		☐	SQLMRUNLEVEL	☐	SQL Monitor: Run Mode
22	ROOTTYPE	SQLMZS	ROOTTYPE		☐	SQLMROOTTYPE	☐	SQL Monitor: Request Type
23	ROOTNAME	SQLMZS	ROOTNAME		☐	SQLMROOTNAME	☐	SQL Monitor: Request Entry Point (Transaction, etc.)
24	STMTKIND	SQLMZS	STMTKIND		☐	SQLMSTMTKIND	☐	SQL Monitor: SQL Operation
25	TABLENAMES	SQLMZS	TABLENAMES		☐	SQLMTABLENAMES	☐	SQL Monitor: Table Names
26	XCNT	SQLMZD	XCNT		☐		☐
27	RCNT	SQLMZD	RCNT		☐		☐
28	RTMIN	SQLMZD	RTMIN		☐		☐
29	RTMAX	SQLMZD	RTMAX		☐		☐
30	RTSUM	SQLMZD	RTSUM		☐		☐
31	RTSQS	SQLMZD	RTSQS		☐		☐
32	DBMIN	SQLMZD	DBMIN		☐		☐
33	DBMAX	SQLMZD	DBMAX		☐		☐
34	DBSUM	SQLMZD	DBSUM		☐		☐
35	DBSQS	SQLMZD	DBSQS		☐		☐
36	TABLENAME01	SQLMZS	TABLENAME01		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
37	TABLENAME02	SQLMZS	TABLENAME02		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
38	TABLENAME03	SQLMZS	TABLENAME03		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
39	TABLENAME04	SQLMZS	TABLENAME04		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
40	TABLENAME05	SQLMZS	TABLENAME05		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
41	TABLENAME06	SQLMZS	TABLENAME06		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
42	TABLENAME07	SQLMZS	TABLENAME07		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
43	TABLENAME08	SQLMZS	TABLENAME08		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
44	TABLENAME09	SQLMZS	TABLENAME09		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
45	TABLENAME10	SQLMZS	TABLENAME10		☐	SQLMTABLENAME	☐	SQL Monitor: Table Name
46	UNIXTIMEFROM	SQLMZZ	UNIXTIMEFROM		☐	INT4	☐	Natural number
47	UNIXTIMETO	SQLMZZ	UNIXTIMETO		☐	INT4	☐	Natural number

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