Messages: Last Status - SAP Documentation

Messages: Last Status

Query Query: 0SPR_LAST_STATE_REPORT

This query gives you an overview of the current processing status 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	Message created on	`0SPRCREATED`
Characteristic	IBase	`0SPRIBASE`
Characteristic	Component	`0SPRMGCOM`
Characteristic	Message number	`0SPRMGNO`
Characteristic	Business partner	`0SPRBPNO`
Characteristic	Business partner role	`0SPRBPROLE`
Characteristic	Priority	`0SPRMGPRI`
Characteristic	Code	`0SPRCODE`
Characteristic	Code group	`0SPRCGRP`
Characteristic	Flag: Completed	`0SPRCOMPL`
Characteristic	System status	`0SPRMGUST`
Characteristic	Message status	`0SPRMGST`

Variables
Object Type	Name	Technical Name
Variable	Text variable for message priority	`0SPRPRTH`
Variable	Message priority (1), is used to calculate the number of messages in the 1st row	`0SPRPRI1`
Variable	Message priority (2), is used to calculate the number of messages in the 2nd row	`0SPRPRI2`
Variable	Message priority (3), is used to calculate the number of messages in the 3rd row	`0SPRPRI3`
Variable	Message priority (4), is used to calculate the number 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 number of messages in the 1st row	`0SPRST1`
Variable	Message status (2) is used to calculate the number of messages in the 2nd row	`0SPRST2`
Variable	Message status (3) is used to calculate the number of messages in the 3rd row	`0SPRST3`
Variable	Message status (4) is used to calculate the number of messages in the 4th row	`0SPRST4`
Variable	Message status (5) is used to calculate the number of messages in the 5th row	`0SPRST5`
Variable	Message status (6) is used to calculate the number of messages in the 6th row	`0SPRST6`
Variable	Message status (7) is used to calculate the number of messages in the 7th row	`0SPRST7`
Variable	Message status (8) is used to calculate the number of messages in the 8th row	`0SPRST8`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Formula	Number of messages with the priority in variable 0SPRPRI1	`0SPRPRTH`	Sum of messages with priority (1)
Formula	Number of messages with the priority in variable 0SPRPRI2	`0SPRPRTH`	Sum of messages with priority (2)
Formula	Number of messages with the priority in variable 0SPRPRI3	`0SPRPRTH`	Sum of messages with priority (3)
Formula	Number of messages with the priority in variable 0SPRPRI4	`0SPRPRTH`	Sum of messages with priority (4)
Formula	Total	`0SPRPRTH`	Total of messages of all priorities
Formula	Number of messages with the status in variable 0SPRST1	`0SPRSTXH`	Sum of messages with status (1)
Formula	Number of messages with the status in variable 0SPRST2	`0SPRSTXH`	Sum of messages with status (2)
Formula	Number of messages with the status in variable 0SPRST3	`0SPRSTXH`	Sum of messages with status (3)
Formula	Number of messages with the status in variable 0SPRST4	`0SPRSTXH`	Sum of messages with status (4)
Formula	Number of messages with the status in variable 0SPRST5	`0SPRSTXH`	Sum of messages with status (5)
Formula	Number of messages with the status in variable 0SPRST6	`0SPRSTXH`	Sum of messages with status (6)
Formula	Number of messages with the status in variable 0SPRST7	`0SPRSTXH`	Sum of messages with status (7)
Formula	Number of messages with the status in variable 0SPRST8	`0SPRSTXH`	Sum of messages with status (8)
Formula	Messages	`0SPRINCNUMB`	Total of messages of all statuses

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