Current Average CH Work Effort and Duration

Query Query: 0SPR_WTQ_CH_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 documents, 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_CH
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`
Characteristic	Configuration Item	`0SPRPRODID`
Characteristic	Configuration Text	`0SPRTXTONJ`
Characteristic	Customer Character 1	`0SPRCUCH0`
Characteristic	Customer Character 2	`0SPRCUCH1`
Characteristic	Customer Character 3	`0SPRCUCH2`
Characteristic	Customer Character 4	`0SPRCUCH3`
Characteristic	Customer Character 5	`0SPRCUCH4`
Characteristic	Customer Character 6	`0SPRCUCH5`
Characteristic	Customer Character 7	`0SPRCUCH6`
Characteristic	Customer Character 8	`0SPRCUCH7`
Characteristic	Customer Character 9	`0SPRCUCH8`
Characteristic	Customer Character 10	`0SPRCUCH9`
Characteristic	Customer Date 1	`0SPRCUDT0`
Characteristic	Customer Date 2	`0SPRCUDT1`
Characteristic	Customer Date 3	`0SPRCUDT2`
Characteristic	Customer Date 4	`0SPRCUDT3`
Characteristic	Customer Date 5	`0SPRCUDT4`
Characteristic	Customer Date 6	`0SPRCUDT5`
Characteristic	Customer Date 7	`0SPRCUDT6`
Characteristic	Customer Date 8	`0SPRCUDT7`
Characteristic	Customer Date 9	`0SPRCUDT8`
Characteristic	Customer Date 10	`0SPRCUDT9`
Characteristic	Customer Number 1	`0SPRCUNO0`
Characteristic	Customer Number 2	`0SPRCUNO1`
Characteristic	Customer Number 3	`0SPRCUNO2`
Characteristic	Customer Number 4	`0SPRCUNO3`
Characteristic	Customer Number 5	`0SPRCUNO4`
Characteristic	Customer Number 6	`0SPRCUNO5`
Characteristic	Customer Number 7	`0SPRCUNO6`
Characteristic	Customer Number 8	`0SPRCUNO7`
Characteristic	Customer Number 9	`0SPRCUNO8`
Characteristic	Customer Number 10	`0SPRCUNO9`

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`
Characteristic	Configuration Item	`0SPRPRODID`
Characteristic	Configuration Text	`0SPRTXTONJ`
Characteristic	Customer Character 1	`0SPRCUCH0`
Characteristic	Customer Character 2	`0SPRCUCH1`
Characteristic	Customer Character 3	`0SPRCUCH2`
Characteristic	Customer Character 4	`0SPRCUCH3`
Characteristic	Customer Character 5	`0SPRCUCH4`
Characteristic	Customer Character 6	`0SPRCUCH5`
Characteristic	Customer Character 7	`0SPRCUCH6`
Characteristic	Customer Character 8	`0SPRCUCH7`
Characteristic	Customer Character 9	`0SPRCUCH8`
Characteristic	Customer Character 10	`0SPRCUCH9`
Characteristic	Customer Date 1	`0SPRCUDT0`
Characteristic	Customer Date 2	`0SPRCUDT1`
Characteristic	Customer Date 3	`0SPRCUDT2`
Characteristic	Customer Date 4	`0SPRCUDT3`
Characteristic	Customer Date 5	`0SPRCUDT4`
Characteristic	Customer Date 6	`0SPRCUDT5`
Characteristic	Customer Date 7	`0SPRCUDT6`
Characteristic	Customer Date 8	`0SPRCUDT7`
Characteristic	Customer Date 9	`0SPRCUDT8`
Characteristic	Customer Date 10	`0SPRCUDT9`
Characteristic	Customer Number 1	`0SPRCUNO0`
Characteristic	Customer Number 2	`0SPRCUNO1`
Characteristic	Customer Number 3	`0SPRCUNO2`
Characteristic	Customer Number 4	`0SPRCUNO3`
Characteristic	Customer Number 5	`0SPRCUNO4`
Characteristic	Customer Number 6	`0SPRCUNO5`
Characteristic	Customer Number 7	`0SPRCUNO6`
Characteristic	Customer Number 8	`0SPRCUNO7`
Characteristic	Customer Number 9	`0SPRCUNO8`
Characteristic	Customer Number 10	`0SPRCUNO9`

Variables
Object Type	Name	Technical Name
Variable	Change Process Types	`0SPR_V_PROCTY_CH`

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`	—