History of the Average/Total Work Effort

Query Query: 0SPR_WTQ_I_AVG_WORK_EFF

This query contains the average and total work effort in hours, by calendar week and transaction type. The cross-ITSM transaction types are the default values.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Transaction Type	`0SPRTTYPE`	0SPR_V_PROCTY_PR
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	Solution Category	`0SPRSOLCT`
Characteristic	Source Process	`0SPRSRCPR`
Characteristic	IBase	`0SPRIBASE`
Characteristic	Message Component	`0SPRMGCOM`
Characteristic	Message Priority	`0SPRMGPRI`
Characteristic	Business Partner	`0SPRBPNO`
Characteristic	Business partner role	`0SPRBPROLE`
Characteristic	Source-Specific ID	`0SPRSRCRI`
Characteristic	Status Change Week	`0SPRSCWEE`
Characteristic	Status Change Day	`0SPRSCDAY`
Characteristic	Status Change Month	`0SPRSCMON`
Characteristic	Status Change Quarter	`0SPRSCQUA`
Characteristic	Status Change Year	`0SPRSCYEA`
Characteristic	Created on	`0SPRCREATED`
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	Solution Category	`0SPRSOLCT`
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	Message Priority	`0SPRC1L___F103`
Characteristic	Status Change Day	`0SPRSCDAY`
Characteristic	Status Change Month	`0SPRSCMON`
Characteristic	Status Change Quarter	`0SPRSCQUA`
Characteristic	Status Change Year	`0SPRSCYEA`
Characteristic	Created on	`0SPRCREATED`
Characteristic	Message number	`0SPRMGNO`

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 work effort	`0SPR_CKF_AVG_WORK_EFFORT`
Key Figure	Total work effort	`0SPR_CKF_TOTAL_WORK_EFFORT`

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Status Change Week	`0SPRSCWEE`	—