Overall Average ITSM CROSS Processing Time

Query Query: 0SPR_WTQ_T_PROC_TIME_CROSS

This query contains the average total processing time and working time, in days, by transaction type. The default values are the cross-ITSM transaction types, and system status "Completed". A Top 5 condition is also saved inactively.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Transaction Type	`0SPRTTYPE`	0SPR_V_PROCTY_PR
Characteristic	System status	`0SPRC1L___F104`	Finished, Completed, Released
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	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	Message Priority	`0SPRMGPRI`

Variables
Object Type	Name	Technical Name
Variable	ITSM Overview Process Types	`0SPR_V_PROCTY_OV`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Average Total Time (D)	`0SPR_CKF_AVG_TOT_DUR`	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_DUR`	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	Transaction Type	`0SPRTTYPE`	—