Total Number of ITSM Cross Problem Messages - SAP Documentation

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`

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`

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`