Total Work Effort 
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
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Transaction Type | 0SPRTTYPE | 0SPR_V_PROCTY_PR |
| Category level 1 | 0SPRCATLV1 | |
| Category level 2 | 0SPRCATLV2 | |
| Category level 3 | 0SPRCATLV3 | |
| Category level 4 | 0SPRCATLV4 | |
| IBase | 0SPRIBASE | |
| Message Component | 0SPRMGCOM | |
| Message Priority | 0SPRMGPRI | |
| Project/Task List | 0SPRPRJCT | |
| Solution Category | 0SPRSOLCT | |
| Business Partner | 0SPRBPNO | |
| Business Partner Role | 0SPRBPROLE | |
| Creation Date | 0SPRCREATED | |
| Source Process | 0SPRSRCPR | |
| 0SPRSRCTX | 0SPRSRCTX | |
| Calendar Year/Month | 0CALMONTH | |
| Cal. Year/Quarter | 0CALQUARTER | |
| Calendar Year | 0CALYEAR | |
| Calendar Day | 0CALDAY | |
| Calendar Year/Week | 0CALWEEK |
CharacteristicObject Type | Name | Technical Name |
|---|---|---|
| Category level 1 | 0SPRCATLV1 |
| Category level 2 | 0SPRCATLV2 |
| Category level 3 | 0SPRCATLV3 |
| Category level 4 | 0SPRCATLV4 |
| IBase | 0SPRIBASE |
| Message Component | 0SPRMGCOM |
| Project/Task List | 0SPRPRJCT |
| Solution Category | 0SPRSOLCT |
| Source Process | 0SPRSRCPR |
| Source-Specific ID | 0SPRSRCRI |
| Business Partner | 0SPRBPNO |
| Business partner role | 0SPRBPROLE |
| Created on | 0SPRCREATED |
| Message number | 0SPRMGNO |
Object Type | Name | Technical Name |
|---|---|---|
| ITSM Overview Process Types | 0SPR_V_PROCTY_OV |
VariableObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Message Priority | 0SPRMGPRI | — |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Average Work Effort | 0SPR_CKF_AVG_WORK_EFFORT2 |
Key Figure