Data Element list used by SAP ABAP Table MSSQUERYSTATSOUT (Query statistics on ALV in SQL Statements (sql >=9.0))
SAP ABAP Table
MSSQUERYSTATSOUT (Query statistics on ALV in SQL Statements (sql >=9.0)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ABP_CONT | Offset of a Processing Control Block | ||
| 2 | MSSABNAME | Name of the ABAP report | ||
| 3 | MSSAVGCLRTIME | Average amount of CLR time consumed by this plan | ||
| 4 | MSSAVGELAPSEDTIME | Average elapsed time in microseconds | ||
| 5 | MSSAVGLOGICALREADS | Average logical reads for this plan since compiled | ||
| 6 | MSSAVGLOGWRITES | Average logical writes for this plan since compiled | ||
| 7 | MSSAVGPHYSREADS | Average physical reads for this plan | ||
| 8 | MSSAVGROWS | Average rows returned per execution | ||
| 9 | MSSAVGWORKERTIME | Average amount of CPU time consumed by executions | ||
| 10 | MSSCSTABLIST | Comma separated table list | ||
| 11 | MSSENDOFFSET | Statement end offset | ||
| 12 | MSSETPERROW | Elapsed time in microseconds per row | ||
| 13 | MSSEXECCOUNT | Number of plan executions since last compile | ||
| 14 | MSSEXECSPH | Executions per hour | ||
| 15 | MSSGRPBY | Sum of values with which to perform grouping | ||
| 16 | MSSLASTCLRTIME | CLR time consumed by last execution of this plan | ||
| 17 | MSSLASTELAPSEDTIME | Last elapsed time in microseconds | ||
| 18 | MSSLASTLOGICALREADS | Last logical reads for this plan since compiled | ||
| 19 | MSSLASTLOGWRITES | Total logical writes for this plan since compiled | ||
| 20 | MSSLASTPHYSREADS | Physical reads last time this plan executed | ||
| 21 | MSSLASTROWS | Total number of rows returned for a query plan | ||
| 22 | MSSLASTWORKERTIME | CPU time consumed by last execution of this plan | ||
| 23 | MSSMAXCLRTIME | Maximum CLR time consumed by this plan | ||
| 24 | MSSMAXELAPSEDTIME | Maximum elapsed time in microseconds | ||
| 25 | MSSMAXLOGICALREADS | Maximum number of logical reads this plan has ever performed | ||
| 26 | MSSMAXLOGWRITES | Maximum logical writes for this plan for a single execution | ||
| 27 | MSSMAXPHYSREADS | Maximum number of physical reads for this plan | ||
| 28 | MSSMAXQROWS | Maximun number of rows returned for a query plan | ||
| 29 | MSSMAXWORKERTIME | Maximum CPU time consumed by this plan | ||
| 30 | MSSMINCLRTIME | Minimum CLR time consumed by this plan | ||
| 31 | MSSMINELAPSEDTIME | Minimum elapsed time in microseconds | ||
| 32 | MSSMINLOGICALREADS | Minimum number of logical reads this plan has ever performed | ||
| 33 | MSSMINLOGWRITES | Minimum logical writes for this plan for a single execution | ||
| 34 | MSSMINPHYSREADS | Minimum number of physical reads for this plan | ||
| 35 | MSSMINQROWS | Minimum number of rows returned for a query plan | ||
| 36 | MSSMINWORKERTIME | Minimum CPU time consumed by this plan | ||
| 37 | MSSOBJNAME | MS SQL Server object name | ||
| 38 | MSSPARTIALSQL | First 50 characters of a SQL Server statement | ||
| 39 | MSSPCTCLRTIME | Percentage of overall CLR time | ||
| 40 | MSSPCTELAPSEDTIME | Percentage of all server elapsed times | ||
| 41 | MSSPCTEXECCNT | Percentage of server total execution counts | ||
| 42 | MSSPCTLOGICALREADS | Percent of server wide logical reads | ||
| 43 | MSSPCTLOGWRITES | Percentage of all logical writes | ||
| 44 | MSSPCTPHYSREADS | Percent of all physical reads | ||
| 45 | MSSPCTWORKERTIME | Percent of total worker time | ||
| 46 | MSSPLANCRETIME | MS SQL Server time at which the plan was compiled. | ||
| 47 | MSSPLANEXECTIME | MS SQL Server: Last time at which the plan was executed. | ||
| 48 | MSSPLANGENNUM | Number of times this plan has been recompiled | ||
| 49 | MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | ||
| 50 | MSSSQLHANDLE | handle pointing to sql statment or procedure | ||
| 51 | MSSSTARTOFFSET | Start statement offset | ||
| 52 | MSSTTLCLRTIME | Total amount of CLR time consumed by executions of this plan | ||
| 53 | MSSTTLELAPSEDTIME | Total elapsed time in microseconds | ||
| 54 | MSSTTLLOGICALREADS | Total logical reads for this plan since compiled | ||
| 55 | MSSTTLLOGWRITES | Total logical writes for this plan since compiled | ||
| 56 | MSSTTLPHYSREADS | Total physical reads for this plan | ||
| 57 | MSSTTLROWS | Total number of rows returned for a query plan | ||
| 58 | MSSTTLWORKERTIME | Total amount of CPU time consumed by executions of this plan | ||
| 59 | MSSWAITFACTOR | Elapsed time/CPU time |