Average RFC Work Effort and Duration

Query Query: 0SPR_WTQ_RFC_T_AVG_PROC_TIME

This query contains the average total processing time and working time, in days, by priority. The default values are the transaction types of the change requsts, and system status "Completed". A Top 5 condition is also save inactively.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Transaction Type	`0SPRTTYPE`	0SPR_V_PROCTY_RC
Characteristic	System status	`0SPRMGUST`	Released, Completed, Finished
Characteristic	Category level 1	`0SPRCATLV1`
Characteristic	Category level 2	`0SPRCATLV2`
Characteristic	Category level 3	`0SPRCATLV3`
Characteristic	Category level 4	`0SPRCATLV4`
Characteristic	Project/Task List	`0SPRPRJCT`
Characteristic	Created on	`0SPRCREATED`
Characteristic	IBase	`0SPRIBASE`
Characteristic	Message Component	`0SPRMGCOM`
Characteristic	Message Priority	`0SPRMGPRI`
Characteristic	Business Partner	`0SPRBPNO`
Characteristic	Business partner role	`0SPRBPROLE`
Characteristic	Source Process	`0SPRSRCPR`
Characteristic	Source-Specific ID	`0SPRSRCRI`
Characteristic	Message number	`0SPRMGNO`

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Category level 1	`0SPRCATLV1`
Characteristic	Category level 2	`0SPRCATLV2`
Characteristic	Category level 3	`0SPRCATLV3`
Characteristic	Category level 4	`0SPRCATLV4`
Characteristic	Project/Task List	`0SPRPRJCT`
Characteristic	Transaction Type	`0SPRTTYPE`
Characteristic	Source Process	`0SPRSRCPR`
Characteristic	Source-Specific ID	`0SPRSRCRI`
Characteristic	IBase	`0SPRIBASE`
Characteristic	Message Component	`0SPRMGCOM`
Characteristic	Business Partner	`0SPRBPNO`
Characteristic	Business partner role	`0SPRBPROLE`
Characteristic	Created on	`0SPRCREATED`
Characteristic	System status	`0SPRMGUST`
Characteristic	Message number	`0SPRMGNO`

Variables
Object Type	Name	Technical Name
Variable	Process types of change requests	`0SPR_V_PROCTY_RC`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Average Total Time (D)	`0SPR_CKF_AVG_TOT_DUR2`	Exception aggregation: Average of the detailed values which are not null or 0, or contain errors
Key Figure	Average Work Time (D)	`0SPR_CKF_AVG_WORK_DUR2`	Exception aggregation: Average of the detailed values which are not null or 0, or contain errors

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Message Priority	`0SPRMGPRI`	—