Total Work Effort CH 
Query: 0SPR_WTQ_CH_T_AVG_WORK_EFF
This query contains the average work effort in hours, by priority. The transaction types of the change documents are the default values.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Transaction Type |
0SPRTTYPE |
0SPR_V_PROCTY_CH |
| 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 |
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 |
Object Type | Name | Technical Name |
|---|---|---|
| Process Types of Changes |
0SPR_V_PROCTY_CH |
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