History of Average RFC Work Effort and Duration 
Query: 0SPR_WTQ_RFC_I_AVG_PROC_TIME
This query contains the average total processing time and working time, in days, by calendar weeks. The default values are the transaction types of the change requsts, and system status "Completed".
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Transaction Type | 0SPRTTYPE | 0SPR_V_PROCTY_RC |
| System status | 0SPRC1L___F104 | Finished, Completed, Released |
| 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 Day | 0SPRSCDAY | |
| Status Change Month | 0SPRSCMON | |
| Status Change Quarter | 0SPRSCQUA | |
| Status Change Week | 0SPRSCWEE | |
| 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 |
| System status | 0SPRC1L___F104 |
| Message number | 0SPRMGNO |
| Configuration Item | 0SPRPRODID |
| Configuration Text | 0SPRTXTONJ |
Object Type | Name | Technical Name |
|---|---|---|
| Change Request process types | 0SPR_V_PROCTY_RC |
VariableObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Average Total Time (D) | 0SPR_CKF_AVG_TOT_DUR | Exception aggregation: Average of the detailed values which are not null or 0, or contain errors |
| Average Work Time (D) | 0SPR_CKF_AVG_WORK_DUR | Exception aggregation: Average of the detailed values which are not null or 0, or contain errors |
Key FigureObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Status Change Week | 0SPRSCWEE | — |