Data Element list used by SAP ABAP Table MSS_STMTHISTDET (History details for an expensive SQL statement)
SAP ABAP Table 
MSS_STMTHISTDET (History details for an expensive SQL statement) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
ABP_CONT | Offset of a Processing Control Block | |
| 2 | Data Element |
MSSABNAME | Name of the ABAP report | |
| 3 | Data Element |
MSSAVGELAPSEDTIME | Average elapsed time in microseconds | |
| 4 | Data Element |
MSSAVGLOGICALREADS | Average logical reads for this plan since compiled | |
| 5 | Data Element |
MSSAVGLOGWRITES | Average logical writes for this plan since compiled | |
| 6 | Data Element |
MSSAVGPHYSREADS | Average physical reads for this plan | |
| 7 | Data Element |
MSSAVGROWS | Average rows returned per execution | |
| 8 | Data Element |
MSSAVGWORKERTIME | Average amount of CPU time consumed by executions | |
| 9 | Data Element |
MSSCALLSFLAG | Flag set if statement was included because of # of calls | |
| 10 | Data Element |
MSSCPUFLAG | High CPU time | |
| 11 | Data Element |
MSSELAPFLAG | High elapsed time | |
| 12 | Data Element |
MSSENDOFFSET | Statement end offset | |
| 13 | Data Element |
MSSETPERROW | Elapsed time in microseconds per row | |
| 14 | Data Element |
MSSEXECCOUNT | Number of plan executions since last compile | |
| 15 | Data Element |
MSSEXECSPH | Executions per hour | |
| 16 | Data Element |
MSSLASTELAPSEDTIME | Last elapsed time in microseconds | |
| 17 | Data Element |
MSSLASTLOGICALREADS | Last logical reads for this plan since compiled | |
| 18 | Data Element |
MSSLASTLOGWRITES | Total logical writes for this plan since compiled | |
| 19 | Data Element |
MSSLASTPHYSREADS | Physical reads last time this plan executed | |
| 20 | Data Element |
MSSLASTROWS | Total number of rows returned for a query plan | |
| 21 | Data Element |
MSSLASTWORKERTIME | CPU time consumed by last execution of this plan | |
| 22 | Data Element |
MSSLOGRDFLAG | High logical reads for this statement | |
| 23 | Data Element |
MSSLOGWRFLAG | Statement has high logical writes | |
| 24 | Data Element |
MSSMAXELAPSEDTIME | Maximum elapsed time in microseconds | |
| 25 | Data Element |
MSSMAXLOGICALREADS | Maximum number of logical reads this plan has ever performed | |
| 26 | Data Element |
MSSMAXLOGWRITES | Maximum logical writes for this plan for a single execution | |
| 27 | Data Element |
MSSMAXPHYSREADS | Maximum number of physical reads for this plan | |
| 28 | Data Element |
MSSMAXQROWS | Maximun number of rows returned for a query plan | |
| 29 | Data Element |
MSSMAXWORKERTIME | Maximum CPU time consumed by this plan | |
| 30 | Data Element |
MSSMINELAPSEDTIME | Minimum elapsed time in microseconds | |
| 31 | Data Element |
MSSMINLOGICALREADS | Minimum number of logical reads this plan has ever performed | |
| 32 | Data Element |
MSSMINLOGWRITES | Minimum logical writes for this plan for a single execution | |
| 33 | Data Element |
MSSMINPHYSREADS | Minimum number of physical reads for this plan | |
| 34 | Data Element |
MSSMINQROWS | Minimum number of rows returned for a query plan | |
| 35 | Data Element |
MSSMINWORKERTIME | Minimum CPU time consumed by this plan | |
| 36 | Data Element |
MSSOBJNAME | MS SQL Server object name | |
| 37 | Data Element |
MSSPARTIALSQL | First 50 characters of a SQL Server statement | |
| 38 | Data Element |
MSSPCTELAPSEDTIME | Percentage of all server elapsed times | |
| 39 | Data Element |
MSSPCTEXECCNT | Percentage of server total execution counts | |
| 40 | Data Element |
MSSPCTLOGICALREADS | Percent of server wide logical reads | |
| 41 | Data Element |
MSSPCTLOGWRITES | Percentage of all logical writes | |
| 42 | Data Element |
MSSPCTPHYSREADS | Percent of all physical reads | |
| 43 | Data Element |
MSSPCTWORKERTIME | Percent of total worker time | |
| 44 | Data Element |
MSSPHYRDFLAG | Statement included because of high physical reads | |
| 45 | Data Element |
MSSPLANCRETIME | MS SQL Server time at which the plan was compiled. | |
| 46 | Data Element |
MSSPLANEXECTIME | MS SQL Server: Last time at which the plan was executed. | |
| 47 | Data Element |
MSSPLANGENNUM | Number of times this plan has been recompiled | |
| 48 | Data Element |
MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | |
| 49 | Data Element |
MSSSQLHANDLE | handle pointing to sql statment or procedure | |
| 50 | Data Element |
MSSSTARTOFFSET | Start statement offset | |
| 51 | Data Element |
MSSSTMTHCOLLID | Unique ID of a set of collected expensive SQL Statements | |
| 52 | Data Element |
MSSSTMTHCOLLID | Unique ID of a set of collected expensive SQL Statements | |
| 53 | Data Element |
MSSSTMTHDT | Date when SQL Statement statistics were saved | |
| 54 | Data Element |
MSSSTMTHTM | Time when SQL Statement statistics were saved | |
| 55 | Data Element |
MSSTTLELAPSEDTIME | Total elapsed time in microseconds | |
| 56 | Data Element |
MSSTTLLOGICALREADS | Total logical reads for this plan since compiled | |
| 57 | Data Element |
MSSTTLLOGWRITES | Total logical writes for this plan since compiled | |
| 58 | Data Element |
MSSTTLPHYSREADS | Total physical reads for this plan | |
| 59 | Data Element |
MSSTTLROWS | Total number of rows returned for a query plan | |
| 60 | Data Element |
MSSWAITFACTOR | Elapsed time/CPU time |
