Show TOC

Total Work Effort Locate this document in the navigation structure

Query Query: 0SPR_WTQ_T_AVG_WORK_EFF

 

This query contains the average work effort in hours, by priority and transaction type. The cross-ITSM transaction types are the default values.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Transaction Type

0SPRTTYPE

0SPR_V_PROCTY_PR

Characteristic Characteristic

Category level 1

0SPRCATLV1

Characteristic Characteristic

Category level 2

0SPRCATLV2

Characteristic Characteristic

Category level 3

0SPRCATLV3

Characteristic Characteristic

Category level 4

0SPRCATLV4

Characteristic Characteristic

IBase

0SPRIBASE

Characteristic Characteristic

Message Component

0SPRMGCOM

Characteristic Characteristic

Message Priority

0SPRMGPRI

Characteristic Characteristic

Project/Task List

0SPRPRJCT

Characteristic Characteristic

Solution Category

0SPRSOLCT

Characteristic Characteristic

Business Partner

0SPRBPNO

Characteristic Characteristic

Business partner role

0SPRBPROLE

Characteristic Characteristic

Created on

0SPRCREATED

Characteristic Characteristic

Source Process

0SPRSRCPR

Characteristic Characteristic

Source-Specific ID

0SPRSRCRI

Characteristic Characteristic

Message number

0SPRMGNO

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Category level 1

0SPRCATLV1

Characteristic Characteristic

Category level 2

0SPRCATLV2

Characteristic Characteristic

Category level 3

0SPRCATLV3

Characteristic Characteristic

Category level 4

0SPRCATLV4

Characteristic Characteristic

IBase

0SPRIBASE

Characteristic Characteristic

Message Component

0SPRMGCOM

Characteristic Characteristic

Project/Task List

0SPRPRJCT

Characteristic Characteristic

Solution Category

0SPRSOLCT

Characteristic Characteristic

Source Process

0SPRSRCPR

Characteristic Characteristic

Source-Specific ID

0SPRSRCRI

Characteristic Characteristic

Business Partner

0SPRBPNO

Characteristic Characteristic

Business partner role

0SPRBPROLE

Characteristic Characteristic

Created on

0SPRCREATED

Characteristic Characteristic

Message number

0SPRMGNO

Variables

Object Type

Name

Technical Name

Variable Variable

ITSM Overview Process Types

0SPR_V_PROCTY_OV

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Message Priority

0SPRMGPRI

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Average Work Effort

0SPR_CKF_AVG_WORK_EFFORT2