History of Average Change Status Iterations 
Query: 0SPR_WTQ_CH_I_AVG_ITERATION
This query contains the average number of status iterations of change documents, by transaction type and calendar week. The default values are the transaction types of the change documents, and user status of the default transactions.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Concatinated Status | 0SPRCSPST | SMADHEADPROC, SHMFHEADPROC, SMMJHEADPROC, SMTMHEADPROC, SMCGHEADBUIL |
| Transaction Type | 0SPRTTYPE | 0SPR_V_PROCTY_CH |
| Status | 0SPRMGST | Proposed Solution |
| Category level 1 | 0SPRCATLV1 | |
| Category level 2 | 0SPRCATLV2 | |
| Category level 3 | 0SPRCATLV3 | |
| Category level 4 | 0SPRCATLV4 | |
| Project/Task List | 0SPRPRJCT | |
| Solution Category | 0SPRSOLCT | |
| IBase | 0SPRIBASE | |
| Message Component | 0SPRMGCOM | |
| Business Partner | 0SPRBPNO | |
| Business partner role | 0SPRBPROLE | |
| Source Process | 0SPRSRCPR | |
| 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 |
| Source Process | 0SPRSRCPR |
| Source-Specific ID | 0SPRSRCRI |
| IBase | 0SPRIBASE |
| Message Component | 0SPRMGCOM |
| Business Partner | 0SPRBPNO |
| Business partner role | 0SPRBPROLE |
| Status Change Day | 0SPRSCDAY |
| Status Change Month | 0SPRSCMON |
| Status Change Quarter | 0SPRSCQUA |
| Status Change Year | 0SPRSCYEA |
| Created on | 0SPRCREATED |
| Transaction Type | 0SPRTTYPE |
| Status | 0SPRMGST |
| Message number | 0SPRMGNO |
| Concatinated Status | 0SPRCSPST |
| Configuration Item | 0SPRPRODID |
| Configuration Text | 0SPRTXTONJ |
Object Type | Name | Technical Name |
|---|---|---|
| Change Process Types | 0SPR_V_PROCTY_CH |
VariableObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Average Iterations | 0SPR_CKF_AVG_ITERATIONS_AGGR | Exception aggregation: Average of the detailed values which are not null or 0, or contain errors — |
| Transaction Type | 0SPRTTYPE |
Key FigureObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Status Change Week | 0SPRSCWEE | — |