Total Number of ITSM Cross Problem Messages

Query Query: 0SPR_WTQ_T_TOTAL_TICKETS

This query contains the total number of tickets, by priority and transaction type. The cross-ITSM transaction types are the default values. 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_OV
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	Source-Specific ID	`0SPRSRCRI`
Characteristic	IBase	`0SPRIBASE`
Characteristic	Message Component	`0SPRMGCOM`
Characteristic	Business Partner	`0SPRBPNO`
	Business partner role	`0SPRBPROLE`
Characteristic	Created on	`0SPRCREATED`
Characteristic	Message Priority	`0SPRMGPRI`
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	Solution Category	`0SPRSOLCT`
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	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	ITSM Overview Process Types	`0SPR_V_PROCTY_OV`

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

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Number of Events	`0SPRINCNUMB`	—
Characteristic	Transaction Type	`0SPRTTYPE`