Show TOC

Incident Management Reports - Message Duration Locate this document in the navigation structure

Query Query: 0SPR_MESSAGE_LIST_DURATION

 

This query analyzes the time distribution of the processing statuses of messages. You can, for example, check how long a message assigned to a specified business partner has a specified processing status.

Structure

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Creation Date of the Message

0SPRCREATED

Characteristic Characteristic

IBase

0SPRC1L___F72

Characteristic Characteristic

Customer Number

0SPRCUNO

Characteristic Characteristic

System Status

0SPRC1L___F104

Characteristic Characteristic

Flag: Completed

0SPRCOMPL

Characteristic Characteristic

Code

0SPRC1L___F73

Characteristic Characteristic

Code Group

0SPRC1L___F78

Characteristic Characteristic

Unique State Identifier

0SPRSTUID

Characteristic Characteristic

Calendar Day

0CALDAY

Characteristic Characteristic

Business Partner

0SPRBPNO

Characteristic Characteristic

Business Partner Role

0SPRBPROLE

Characteristic Characteristic

Priority

0SPRMGPRI

Characteristic Characteristic

Status

0SPRMGST

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Message Number

0SPRMGNO

—

Characteristic Characteristic

Short Text of Message

0SPRMSGTX

—

Characteristic Characteristic

GUID of the CRM Message

0SPRCRMGUID

—

Characteristic Characteristic

Component

0SPRC1L___F101

—

Characteristic Characteristic

Priority

0SPRC1L___F103

—

Characteristic Characteristic

Status

0SPRC1L___F99

—

Characteristic Characteristic

Business Partner Role

0SPRC1L___F93

—

Characteristic Characteristic

Business Partner

0SPRC1L___F92

—

Characteristic Characteristic

System ID

0SMD_LSID

—
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Formula Formula

Duration (hrs)

0SPRDURAT

Duration of processing states in hours