SAP ABAP Table /SDF/SQLHIST_DISP_TEXT (Display structure for SQLM History)
Hierarchy
☛
ST-PI (Software Component) SAP Solution Tools Plug-In
⤷ SV-SMG-DIA (Application Component) Solution Manager Diagnostics
⤷ /SDF/ZQLM (Package) Package for SQL Monitor
⤷ SV-SMG-DIA (Application Component) Solution Manager Diagnostics
⤷ /SDF/ZQLM (Package) Package for SQL Monitor
Basic Data
Table Category | INTTAB | Structure |
Structure | /SDF/SQLHIST_DISP_TEXT | Table Relationship Diagram |
Short Description | Display structure for SQLM History |
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 | .INCLUDE | 0 | 0 | Display structure for SQLM History | |||||
2 | .INCLUDE | 0 | 0 | Generated Table for View | |||||
3 | TIMESTAMP | /SDF/SQLTIMESTAMP | /SDF/SQLTIMESTAMP | DEC | 15 | 0 | Timestamp for SQLM Data Collection | ||
4 | PROGNAME | PROGNAME | PROGNAME | CHAR | 40 | 0 | ABAP Program Name | ||
5 | PROGKIND | /SDF/ZQLMPROGKIND | /SDF/ZQLMPROGKIND | CHAR | 1 | 0 | SQL Monitor: Program Kind | ||
6 | PROCTYPE | /SDF/ZQLMPROCTYPE | CHAR | 4 | 0 | SQL Monitor: Processing Block Type | |||
7 | PROCNAME | /SDF/ZQLMPROCNAME | CHAR | 93 | 0 | SQL Monitor: Processing Block Name | |||
8 | PROCLINE | /SDF/ZQLMPROCLINE | INT4 | 10 | 0 | SQL Monitor: Line Number in Processing Block | |||
9 | RUNLEVEL | /SDF/ZQLMRUNLEVEL | /SDF/ZQLMRUNLEVEL | CHAR | 1 | 0 | SQL Monitor: Run Mode | ||
10 | ROOTTYPE | /SDF/ZQLMROOTTYPE | /SDF/ZQLMROOTTYPE | CHAR | 1 | 0 | SQL Monitor: Request Type | ||
11 | ROOTNAME | /SDF/ZQLMROOTNAME | CHAR | 60 | 0 | SQL Monitor: Request Entry Point (Transaction, etc.) | |||
12 | STMTKIND | /SDF/ZQLMSTMTKIND | /SDF/ZQLMSTMTKIND | CHAR | 1 | 0 | SQL Monitor: SQL Operation | ||
13 | TABLENAME | /SDF/ZQLMTABLENAME | DBOBJ_NAME | CHAR | 16 | 0 | SQL Monitor: Table Name | ||
14 | HASH | HASH160X | RAW | 20 | 0 | Hash Value (160 Bits) | |||
15 | INCLUDE | PROGNAME | PROGNAME | CHAR | 40 | 0 | ABAP Program Name | ||
16 | LINE | INT4 | INT4 | INT4 | 10 | 0 | Natural number | ||
17 | PGMID | PGMID | PGMID | CHAR | 4 | 0 | Program ID in Requests and Tasks | ||
18 | OBJECT | TROBJTYPE | OBJECT | CHAR | 4 | 0 | Object Type | ||
19 | OBJ_NAME | SOBJ_NAME | SOBJ_NAME | CHAR | 40 | 0 | Object Name in Object Directory | ||
20 | DEVCLASS | DEVCLASS | DEVCLASS | CHAR | 30 | 0 | Package | * | |
21 | TABLENAMES | /SDF/ZQLMTABLENAMES | CHAR | 160 | 0 | SQL Monitor: Table Names | |||
22 | XCNT | /SDF/SQLMEXECNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Total Number of Executions | ||
23 | RCNT | /SDF/SQLMROLLAREACNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Internal Sessions Affected | ||
24 | XCNTRCNT | /SDF/ZQLMEXECNTROLLAREACNT | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Executions per Internal Sessions | ||
25 | RTMIN | /SDF/ZQLMRUNTIMEMIN | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Minimum Value of Execution Time | ||
26 | RTMAX | /SDF/ZQLMRUNTIMEMAX | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Maximum Value of Execution Time | ||
27 | RTCNT | /SDF/SQLMRUNTIMECNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Count | ||
28 | RTSUM | /SDF/ZQLMRUNTIMESUM | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Total Execution Time | ||
29 | RTSQS | /SDF/ZQLMRUNTIMESQS | /SDF/ZQLMDECIMAL6 | DEC | 31 | 6 | SQL Monitor: Runtime Sum of Squares | ||
30 | RTAVG | /SDF/ZQLMRUNTIMEAVG | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Mean Value of Execution Time | ||
31 | RTDEV | /SDF/ZQLMRUNTIMEDEV | /SDF/ZQLMRUNTIME | DEC | 31 | 3 | SQL Monitor: Standard Deviation of Execution Time | ||
32 | DBMIN | /SDF/ZQLMDBCOUNTMIN | INT4 | 10 | 0 | SQL Monitor: Minimum Value of Fetched / Modified Records | |||
33 | DBMAX | /SDF/ZQLMDBCOUNTMAX | INT4 | 10 | 0 | SQL Monitor: Maximum Value of Fetched / Modified Records | |||
34 | DBCNT | /SDF/SQLMDBCOUNTCNT | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: DB Count Count | ||
35 | DBSUM | /SDF/ZQLMDBCOUNTSUM | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: Total Fetched or Modified Records | ||
36 | DBSQS | /SDF/ZQLMDBCOUNTSQS | /SDF/ZQLMINTEGER | DEC | 31 | 0 | SQL Monitor: DB Count Sum of Squares | ||
37 | DBAVG | /SDF/ZQLMDBCOUNTAVG | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Mean Value of Fetched / Modified Records | ||
38 | DBDEV | /SDF/ZQLMDBCOUNTDEV | /SDF/ZQLMDECIMAL3 | DEC | 31 | 3 | SQL Monitor: Standard Deviation of Fetched / Modif. Records | ||
39 | DATEFROM | /SDF/SQLDATEFROM | DATS | 8 | 0 | Begin of Data Collection | |||
40 | TIMEFROM | /SDF/SQLTIMEFROM | /SDF/SQLTIMEFROM | TIMS | 6 | 0 | Start time of data collection | ||
41 | DATETO | /SDF/SQLDATETO | DATS | 8 | 0 | Begin of Data Collection | |||
42 | TIMETO | /SDF/SQLTIMETO | TIMS | 6 | 0 | Start time of data collection | |||
43 | DURATION | /SDF/SQLDURATION | INT4 | 10 | 0 | Duration of time slot in seconds | |||
44 | STMTKIND_TXT | /SDF/ZQLMSTMTKIND_TXT | TEXT30 | CHAR | 30 | 0 | SQL Monitor: SQL Operation | ||
45 | RUNLEVEL_TXT | /SDF/ZQLMRUNLEVEL_TXT | TEXT30 | CHAR | 30 | 0 | SQL Monitor: Run Mode | ||
46 | ROOTTYPE_TXT | /SDF/ZQLMROOTTYPE_TXT | TEXT30 | CHAR | 30 | 0 | SQL Monitor: Request Type | ||
47 | TEXT | STRG | 0 | 0 |
History
Last changed by/on | SAP | 20140922 |
SAP Release Created in | 2008_1_700 |