SAP ABAP Table /BCV/S_QRM_QUERY_STATISTICS (Query Statistics)

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-EPT-BCV (Application Component) Business Context Viewer
     ⤷ /BCV/QRM (Package) BCV Query Management Layer

Basic Data

Table Category	INTTAB	Structure
Structure	/BCV/S_QRM_QUERY_STATISTICS	Table Relationship Diagram
Short Description	Query Statistics

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	QUERY_ID	☐	/BCV/QRM_QUERY_ID	/BCV/QRM_QUERY_ID	CHAR	32	0	Query ID
2	EXCTIME_MIN	☐	/BCV/QRM_ST_EXCTIME_MIN	/BCV/QRM_ST_RUNTIME	DEC	15	3	Minimum Processing Time of the Query
3	EXCTIME_MAX	☐	/BCV/QRM_ST_EXCTIME_MAX	/BCV/QRM_ST_RUNTIME	DEC	15	3	Maximum Processing Time of the Query
4	EXCTIME_AVG	☐	/BCV/QRM_ST_EXCTIME_AVG	/BCV/QRM_ST_RUNTIME	DEC	15	3	Average Processing Time of the Query
5	EXCTIME_LAST	☐	/BCV/QRM_ST_EXCTIME_LAST	/BCV/QRM_ST_RUNTIME	DEC	15	3	Last Processing Time of the Query
6	EXCDATE_FIRST	☐	/BCV/QRM_ST_EXCDATE_FIRST	/BCV/QRM_ST_EXCDATE	DATS	8	0	First Processing Date of the Query
7	EXCDATE_LAST	☐	/BCV/QRM_ST_EXCDATE_LAST	/BCV/QRM_ST_EXCDATE	DATS	8	0	Last Processing Date of the Query
8	EXC_COUNT	☐	/BCV/QRM_ST_EXC_COUNT	/BCV/QRM_ST_NUMBER	INT4	10	0	Number of Query Executions
9	ERROR_COUNT	☐	/BCV/QRM_ST_ERROR_COUNT	/BCV/QRM_ST_NUMBER	INT4	10	0	Number of Erroneous Query Executions
10	CACHE_HIT_COUNT	☐	/BCV/QRM_ST_CACHE_HIT_COUNT	/BCV/QRM_ST_NUMBER	INT4	10	0	Number of Successful Reads from Results Cache
11	RECORDS_MIN	☐	/BCV/QRM_ST_RECORDS_MIN	/BCV/QRM_ST_NUMBER	INT4	10	0	Minimum Number of Retrieved Result Records
12	RECORDS_MAX	☐	/BCV/QRM_ST_RECORDS_MAX	/BCV/QRM_ST_NUMBER	INT4	10	0	Maximum Number of Retrieved Result Records
13	RECORDS_AVG	☐	/BCV/QRM_ST_RECORDS_AVG	/BCV/QRM_ST_NUMBER	INT4	10	0	Average Number of Retrieved Result Records
14	RECORDS_LAST	☐	/BCV/QRM_ST_RECORDS_LAST	/BCV/QRM_ST_NUMBER	INT4	10	0	Last Number of Retrieved Result Records
15	TIMEPERREC_MIN	☐	/BCV/QRM_ST_TIMEPERREC_MIN	/BCV/QRM_ST_RUNTIME	DEC	15	3	Minimum Processing Time per Results Record (in Milliseconds)
16	TIMEPERREC_MAX	☐	/BCV/QRM_ST_TIMEPERREC_MAX	/BCV/QRM_ST_RUNTIME	DEC	15	3	Maximum Processing Time per Results Record (in Milliseconds)
17	TIMEPERREC_AVG	☐	/BCV/QRM_ST_TIMEPERREC_AVG	/BCV/QRM_ST_RUNTIME	DEC	15	3	Average Processing Time per Results Record (in Milliseconds)
18	TIMEPERREC_LAST	☐	/BCV/QRM_ST_TIMEPERREC_LAST	/BCV/QRM_ST_RUNTIME	DEC	15	3	Last Processing Time per Results Record (in Milliseconds)

History

Last changed by/on	SAP	20110908
SAP Release Created in	701