History of Average/Total IN Work Required 
Query: 0SPR_WTQ_IN_I_AVG_WORK_EFF
This query gives you an overview of the total and average work required by messages, listed by calendar week. You can use other attributes as well as calender week, 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 | |
| Project/Task List | 0SPRPRJCT | |
| Solution Category | 0SPRSOLCT | |
| Source Process | 0SPRSRCPR | |
| IBase | 0SPRIBASE | |
| Message Component | 0SPRMGCOM | |
| Message Priority | 0SPRMGPRI | |
| Business Partner | 0SPRBPNO | |
| Business partner role | 0SPRBPROLE | |
| Source-Specific ID | 0SPRSRCRI | |
| Status Change Week | 0SPRSCWEE | |
| Status Change Day | 0SPRSCDAY | |
| Status Change Month | 0SPRSCMON | |
| Status Change Quarter | 0SPRSCQUA | |
| Status Change Year | 0SPRSCYEA | |
| Created on | 0SPRCREATED | |
| Message number | 0SPRMGNO | |
| Configuration Item | 0SPRPRODID | |
| Configuration Text | 0SPRTXTONJ |
CharacteristicObject Type | Name | Technical Name |
|---|---|---|
| Category level 1 | 0SPRCATLV1 |
| Category level 2 | 0SPRCATLV2 |
| Category level 3 | 0SPRCATLV3 |
| Category level 4 | 0SPRCATLV4 |
| Project/Task List | 0SPRPRJCT |
| Solution Category | 0SPRSOLCT |
| Transaction Type | 0SPRTTYPE |
| Source Process | 0SPRSRCPR |
| Source-Specific ID | 0SPRSRCRI |
| IBase | 0SPRIBASE |
| Message Component | 0SPRMGCOM |
| Business Partner | 0SPRBPNO |
| Business partner role | 0SPRBPROLE |
| Message Priority | 0SPRC1L___F103 |
| Status Change Day | 0SPRSCDAY |
| Status Change Month | 0SPRSCMON |
| Status Change Quarter | 0SPRSCQUA |
| Status Change Year | 0SPRSCYEA |
| Created on | 0SPRCREATED |
| Message number | 0SPRMGNO |
| Configuration Item | 0SPRPRODID |
| Configuration Text | 0SPRTXTONJ |
Object Type | Name | Technical Name |
|---|---|---|
| Process Types in Incident Management | 0SPR_V_PROCTY_IN |
VariableObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Average work effort | 0SPR_CKF_AVG_WORK_EFFORT | Exception aggregation: Average of the detailed values which are not null or 0, or contain errors — |
| Total work effort | 0SPR_CKF_TOTAL_WORK_EFFORT | Total |
Key FigureObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Status Change Week | 0SPRSCWEE | — |