Total Average Change Status Iterations

Query Query: 0SPR_WTQ_CH_T_AVG_ITERATION

This query contains the average number of status iterations of change documents, by priority. The default values are the transaction types of the change documents, and user status of the default transactions.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Concatinated Status	`0SPRCSPST`	SMTMHEADPROC, SMMJHEADPROC, SMHFHEADPROC, SMADHEADPROC, SMCGHEADBUIL
Characteristic	Transaction Type	`0SPRTTYPE`	0SPR_V_PROCTY_CH
Characteristic	Status	`0SPRMGST`	Proposed Solution
Characteristic	Category level 1	`0SPRCATLV1`
Characteristic	Category level 2	`0SPRCATLV2`
Characteristic	Category level 3	`0SPRCATLV3`
Characteristic	Category level 4	`0SPRCATLV4`
Characteristic	Project/Task List	`0SPRPRJCT`
Characteristic	Solution Category	`0SPRSOLCT`
Characteristic	IBase	`0SPRIBASE`
Characteristic	Message Component	`0SPRMGCOM`
Characteristic	Business Partner	`0SPRBPNO`
Characteristic	Business partner role	`0SPRBPROLE`
Characteristic	Status Change Day	`0SPRSCDAY`
Characteristic	Created on	`0SPRCREATED`
Characteristic	Message Priority	`0SPRMGPRI`
Characteristic	Message number	`0SPRMGNO`

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Category level 1	`0SPRCATLV1`
Characteristic	Category level 2	`0SPRCATLV2`
Characteristic	Category level 3	`0SPRCATLV3`
Characteristic	Category level 4	`0SPRCATLV4`
Characteristic	Project/Task List	`0SPRPRJCT`
Characteristic	Solution Category	`0SPRSOLCT`
Characteristic	IBase	`0SPRIBASE`
Characteristic	Message Component	`0SPRMGCOM`
Characteristic	Business Partner	`0SPRBPNO`
Characteristic	Business partner role	`0SPRBPROLE`
Characteristic	Status Change Day	`0SPRSCDAY`
Characteristic	Created on	`0SPRCREATED`
Characteristic	Transaction Type	`0SPRTTYPE`
Characteristic	Status	`0SPRMGST`
Characteristic	Message number	`0SPRMGNO`
Characteristic	Concatinated Status	`0SPRCSPST`

Variables
Object Type	Name	Technical Name
Variable	Change Process Types	`0SPR_V_PROCTY_CH`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Message Priority	`0SPRC1L___F103`	—

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Average Iterations	`0SPR_CKF_AVG_ITERATIONS_AGGR`	Exception aggregation: Average of the detailed values which are not null or 0, or contain errors —