Message Processing Duration Analysis

Query Query: 0SPR_DURATION_ANALYSIS

This query gives you an overview of the processing duration of messages, by business partners. The messages are shown by priority or status, depending on the filter.

Structure

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Component	`0SPRC1L___F101`
Characteristic	Status	`0SPRC1L___F99`
Characteristic	Message created on	`0SPRCREATED`
Characteristic	Business partner	`0SPRC1L___F92`
Characteristic	Business partner role	`0SPRC1L___F93`
Characteristic	IBase	`0SPRC1L___F72`
Characteristic	Day	`0CALDAY`
Characteristic	Message number	`0SPRMGNO`
Characteristic	Year	`0CALYEAR`
Characteristic	Calendar Year/Week	`0CALWEEK`
Characteristic	Calendar Year/Month	`0CALMONTH`
Characteristic	Calendar Year/Quarter	`0CALQUARTER`
Characteristic	Code	`0SPRC1L___F73`
Characteristic	Code group	`0SPRC1L___F78`
Characteristic	Flag: Completed	`0SPRCOMPL`
Characteristic	Priority	`0SPRC1L___F103`
Characteristic	System status	`0SPRC1L___F104`
Characteristic	Message short text	`0SPRMSGTX`
Characteristic	Status	`0SPRMGST`
Characteristic	Priority	`0SPRMGPRI`
Characteristic	Business partner	`0SPRBPNO`
Characteristic	Business partner role	`0SPRBPROLE`

Variables
Object Type	Name	Technical Name
Variable	Text variable for message priority	`0SPRPRTH`
Variable	Message priority (1), is used to calculate the processing duration of messages in the 1st row	`0SPRPRI1`
Variable	Message priority (2), is used to calculate the processing duration of messages in the 2nd row	`0SPRPRI2`
Variable	Message priority (3), is used to calculate the processing duration of messages in the 3rd row	`0SPRPRI3`
Variable	Message priority (4), is used to calculate the processing duration of messages in the 4th row	`0SPRPRI4`
Variable	Text variable for message status, to display row text	`0SPRSTXH`
Variable	Message status (1) is used to calculate the processing duration of messages in the 1st row	`0SPRST1`
Variable	Message status (2) is used to calculate the processing duration of messages in the 2nd row	`0SPRST2`
Variable	Message status (3) is used to calculate the processing duration of messages in the 3rd row	`0SPRST3`
Variable	Message status (4) is used to calculate the processing duration of messages in the 4th row	`0SPRST4`
Variable	Message status (5) is used to calculate the processing duration of messages in the 5th row	`0SPRST5`
Variable	Message status (6) is used to calculate the processing duration of messages in the 6th row	`0SPRST6`
Variable	Message status (7) is used to calculate the processing duration of messages in the 7th row	`0SPRST7`
Variable	Message status (8) is used to calculate the processing duration of messages in the 8th row	`0SPRST8`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Formula	Processing duration of messages with the priority in variable 0SPRPRI1	`0SPRPRTH`	Sum of messages with priority (1)
Formula	Processing duration of messages with the priority in variable 0SPRPRI2	`0SPRPRTH`	Sum of messages with priority (2)
Formula	Processing duration of messages with the priority in variable 0SPRPRI3	`0SPRPRTH`	Sum of messages with priority (3)
Formula	Processing duration of messages with the priority in variable 0SPRPRI4	`0SPRPRTH`	Sum of messages with priority (4)
Formula	Processing duration of messages with the status in variable 0SPRST1	`0SPRSTXH`	Sum of messages with status (1)
Formula	Processing duration of messages with the status in variable 0SPRST2	`0SPRSTXH`	Sum of messages with status (2)
Formula	Processing duration of messages with the status in variable 0SPRST3	`0SPRSTXH`	Sum of messages with status (3)
Formula	Processing duration of messages with the status in variable 0SPRST4	`0SPRSTXH`	Sum of messages with status (4)
Formula	Processing duration of messages with the status in variable 0SPRST5	`0SPRSTXH`	Sum of messages with status (5)
Formula	Processing duration of messages with the status in variable 0SPRST6	`0SPRSTXH`	Sum of messages with status (6)
Formula	Processing duration of messages with the status in variable 0SPRST7	`0SPRSTXH`	Sum of messages with status (7)
Formula	Processing duration of messages with the status in variable 0SPRST8	`0SPRSTXH`	Sum of messages with status (8)
Formula	Mean duration (hrs)	`0SPRPRTH`	Average processing duration of messages (filtered by priority or status)

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Customer number	`0SPRCUNO`	—