Total Work Effort IN 
Query: 0SPR_WTQ_IN_T_AVG_WORK_EFF
This query gives an overview of the work effort required by messages, by priority. You can use other attributes as well as priority, for display and filter selection. The default restriction refers to the procedure type (here: incident message).
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Transaction Type | 0SPRTTYPE | 0SPR_V_PROCTY_IN |
| 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 | |
| Created on | 0SPRCREATED | |
| Source Process | 0SPRSRCPR | |
| Source-Specific ID | 0SPRSRCRI | |
| Message number | 0SPRMGNO | |
| Configuration Item | 0SPRPRODID | |
| Configuration Text | 0SPRTXTONJ | |
| Customer Character 1 | 0SPRCUCH0 | |
| Customer Character 2 | 0SPRCUCH1 | |
| Customer Character 3 | 0SPRCUCH2 | |
| Customer Character 4 | 0SPRCUCH3 | |
| Customer Character 5 | 0SPRCUCH4 | |
| Customer Character 6 | 0SPRCUCH5 | |
| Customer Character 7 | 0SPRCUCH6 | |
| Customer Character 8 | 0SPRCUCH7 | |
| Customer Character 9 | 0SPRCUCH8 | |
| Customer Character 10 | 0SPRCUCH9 | |
| Customer Date 1 | 0SPRCUDT0 | |
| Customer Date 2 | 0SPRCUDT1 | |
| Customer Date 3 | 0SPRCUDT2 | |
| Customer Date 4 | 0SPRCUDT3 | |
| Customer Date 5 | 0SPRCUDT4 | |
| Customer Date 6 | 0SPRCUDT5 | |
| Customer Date 7 | 0SPRCUDT6 | |
| Customer Date 8 | 0SPRCUDT7 | |
| Customer Date 9 | 0SPRCUDT8 | |
| Customer Date 10 | 0SPRCUDT9 | |
| Customer Number 1 | 0SPRCUNO0 | |
| Customer Number 2 | 0SPRCUNO1 | |
| Customer Number 3 | 0SPRCUNO2 | |
| Customer Number 4 | 0SPRCUNO3 | |
| Customer Number 5 | 0SPRCUNO4 | |
| Customer Number 6 | 0SPRCUNO5 | |
| Customer Number 7 | 0SPRCUNO6 | |
| Customer Number 8 | 0SPRCUNO7 | |
| Customer Number 9 | 0SPRCUNO8 | |
| Customer Number 10 | 0SPRCUNO9 |
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 |
| Transaction Type | 0SPRTTYPE |
| Source Process | 0SPRSRCPR |
| Source-Specific ID | 0SPRSRCRI |
| Business Partner | 0SPRBPNO |
| Business partner role | 0SPRBPROLE |
| Created on | 0SPRCREATED |
| Message number | 0SPRMGNO |
| Configuration Item | 0SPRPRODID |
| Configuration Text | 0SPRTXTONJ |
| Customer Character 1 | 0SPRCUCH0 |
| Customer Character 2 | 0SPRCUCH1 |
| Customer Character 3 | 0SPRCUCH2 |
| Customer Character 4 | 0SPRCUCH3 |
| Customer Character 5 | 0SPRCUCH4 |
| Customer Character 6 | 0SPRCUCH5 |
| Customer Character 7 | 0SPRCUCH6 |
| Customer Character 8 | 0SPRCUCH7 |
| Customer Character 9 | 0SPRCUCH8 |
| Customer Character 10 | 0SPRCUCH9 |
| Customer Date 1 | 0SPRCUDT0 |
| Customer Date 2 | 0SPRCUDT1 |
| Customer Date 3 | 0SPRCUDT2 |
| Customer Date 4 | 0SPRCUDT3 |
| Customer Date 5 | 0SPRCUDT4 |
| Customer Date 6 | 0SPRCUDT5 |
| Customer Date 7 | 0SPRCUDT6 |
| Customer Date 8 | 0SPRCUDT7 |
| Customer Date 9 | 0SPRCUDT8 |
| Customer Date 10 | 0SPRCUDT9 |
| Customer Number 1 | 0SPRCUNO0 |
| Customer Number 2 | 0SPRCUNO1 |
| Customer Number 3 | 0SPRCUNO2 |
| Customer Number 4 | 0SPRCUNO3 |
| Customer Number 5 | 0SPRCUNO4 |
| Customer Number 6 | 0SPRCUNO5 |
| Customer Number 7 | 0SPRCUNO6 |
| Customer Number 8 | 0SPRCUNO7 |
| Customer Number 9 | 0SPRCUNO8 |
| Customer Number 10 | 0SPRCUNO9 |
Object Type | Name | Technical Name |
|---|---|---|
| Process Types in Incident Management | 0SPR_V_PROCTY_IN |
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 | Exception aggregation: Average of the detailed values which are not null or 0, or contain errors — |
Key Figure