/PLMPCV/D_QSTAT - Query statistics

Query statistics information is stored in SAP table /PLMPCV/D_QSTAT.
 It is part of development package /PLMPCV/QRM in software component PLM-WUI-PCV-QRM. This development package consists of objects that can be grouped under "PCV Query Management Layer".

Fields for table /PLMPCV/D_QSTAT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6*
QUERY_IDQuery IDX/PLMPCV/QRM_QUERY_IDCHAR64/PLMPCV/D_QHEAD
EXCTIME_MINMinimum Processing Time/PLMPCV/QRM_ST_EXCTIME_MINDEC8
EXCTIME_MAXMaximum Processing Time/PLMPCV/QRM_ST_EXCTIME_MAXDEC8
EXCTIME_AVGAverage Processing Time/PLMPCV/QRM_ST_EXCTIME_AVGDEC8
EXCTIME_LASTLast Processing Time/PLMPCV/QRM_ST_EXCTIME_LASTDEC8
EXCDATE_FIRSTDate When Query Was Executed for the First Time/PLMPCV/QRM_ST_EXCDATE_FIRSTDATS16
EXCDATE_LASTDate When Query Was Executed for the Last Time/PLMPCV/QRM_ST_EXCDATE_LASTDATS16
EXC_COUNTNumber of Query Executions/PLMPCV/QRM_ST_EXC_COUNTINT44
RECORDS_MINMinimum Number of Retrieved Result Records/PLMPCV/QRM_ST_RECORDS_MININT44
RECORDS_MAXMaximum Number of Retrieved Result Records/PLMPCV/QRM_ST_RECORDS_MAXINT44
RECORDS_AVGAverage Number of Retrieved Result Records/PLMPCV/QRM_ST_RECORDS_AVGINT44
RECORDS_LASTNumber of Retrieved Result Records from Last Execution/PLMPCV/QRM_ST_RECORDS_LASTINT44
TIMEPERREC_MINMinimum Time per Record (in Milliseconds)/PLMPCV/QRM_ST_TIMEPERREC_MINDEC8
TIMEPERREC_MAXMaximum Time per Record (in Milliseconds)/PLMPCV/QRM_ST_TIMEPERREC_MAXDEC8
TIMEPERREC_AVGAverage Time per Record (in Milliseconds)/PLMPCV/QRM_ST_TIMEPERREC_AVGDEC8
TIMEPERREC_LASTLast Time per Record (in Milliseconds)/PLMPCV/QRM_ST_TIMEPERREC_LASTDEC8
Privacy Policy