Current Number of Open PR Problem Messages

Query Query: 0SPR_WTQ_PR_T_OPEN_TICKETS

This query gives you an overview of the number of currently open messages, listed by priority and category level. You can use other attributes as well as priority and category, for display and filter selection. The default restrictions refers to the procedure type (here: problem message) and the system status of the problem messages (here: open). You can display the first 5 problem messages directly, with a default condition.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Transaction Type	`0SPRTTYPE`	0SPR_V_PROCTY_PR
Characteristic	System status	`0SPRMGUST`	In Process, Open, Completed, Released, New
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 Priority	`0SPRMGPRI`
Characteristic	Message number	`0SPRMGNO`

Free Characteristics
Object Type	Name	Technical Name
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	Created on	`0SPRCREATED`
Characteristic	System status	`0SPRMGUST`
Characteristic	Message number	`0SPRMGNO`

Variables
Object Type	Name	Technical Name
Variable	Process Types in Problem Management	`0SPR_V_PROCTY_PR`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Number of Events	`0SPRINCNUMB`	Default Aggregation
Characteristic	Category level 1	`0SPRCATLV1`

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