Test Plan Status

Query Query: 0TWB_TESTPLAN_STATUS

This query contains information about distribution of test case statuses and message priorities within test cases.

Note Note

You can use the Test Plan Status View (technical name 0TWB_V_TESTPLAN_STATUS) to retrieve the status of the test cases upon execution of this query.

End of the note.

Structure

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Calendar day	`0CALDAY`
Characteristic	Project	`0TWBPROJ`
Characteristic	Solution	`0TWBSOL`
Characteristic	Test set	`0TWBSEQ`
Characteristic	Nodes	`0TWBNODE`
Characteristic	Node type	`0TWBNDTY`
Characteristic	Business process	`0TBWBP`
Characteristic	Business scenario	`0TBWBS`
Characteristic	Business process step	`0TBWBPS`
Characteristic	System role	`0TWBSYROL`
Characteristic	Test package	`0TWBTPCKG`
Characteristic	Person responsible for test plan	`0TWBTPRES`
Characteristic	Tester	`0TWBTESTR`
Characteristic	Test case: traffic light status	`0TWBTCTLS`
Characteristic	Test case: status	`0TWBTCST`
Characteristic	User guidance restriction	`0TWBRSTHD`
Characteristic	Customizing restriction	`0TWBRSTCU`
Characteristic	Display restriction	`0TWBRSTUI`
Characteristic	Documentation restriction	`0TWBRSTDO`
Characteristic	Functionality restriction	`0TWBRSTFU`
Characteristic	Other restriction	`0TWBRSTOT`
Characteristic	Other text restriction	`0TWBRSTTX`
Characteristic	Translation restriction	`0TWBRSTTR`
Characteristic	Indicator for test completed	`0TWBTSTFI`
Characteristic	Logical component	`0TWBLOGC`
Characteristic	Test	`0TWBTC`
Characteristic	Test case priority	`0TWBTCPRI`
Characteristic	Test case type	`0TWBTCTY`
Characteristic	Person responsible for test case	`0TWBTCRSP`
Characteristic	Message number	`0TWBMGNO`
Characteristic	Short text of message	`0TWBMSGTX`
Characteristic	Message component	`0TWBMGCOM`
Characteristic	Message priority	`0TWBMGPRI`
Characteristic	Status of message	`0TWBMGST`
Characteristic	Message processor	`0TWBMGPRC`
Characteristic	Node type with keyword	`0SM_TWBS___F110`
Characteristic	Keyword	`0SM_TWBS___F112`
Characteristic	Node type with search terms / keywords	`0SM_TWBS___F115`
Characteristic	Search term / keyword	`0SM_TWBS___F117`
Characteristic	Node type with SAP attribute	`0SM_TWBS___F120`
Characteristic	SAP attribute	`0SM_TWBS___F123`
Characteristic	Characteristic of SAP attribute	`0SM_TWBS___F122`
Characteristic	Node type with customer attributes	`0SM_TWBS___F2`
Characteristic	Customer attribute	`0SM_TWBS___F7`
Characteristic	Characteristic of the customer attribute	`0SM_TWBS___F6`
Characteristic	Priority of test package	`0TWBPCPRI`
Characteristic	Planned end date (test package)	`0TWBPEDTPC`
Characteristic	Actual start date (test package)	`0TWBASDTPC`
Characteristic	Actual end date (test package)	`0TWBAEDTPC`
Characteristic	Planned start date (test package)	`0TWBPSDTPC`
Characteristic	Actual end date (test plan)	`0TWBAEDTP`
Characteristic	Actual start date (test plan)	`0TWBASDTP`
Characteristic	Planned end date (test pan)	`0TWBPEDTP`
Characteristic	Planned start date (test plan)	`0TWBPSDTP`
Characteristic	Code	`0TWBCODE`
Characteristic	Code group	`0TWBCGRP`
Characteristic	Category	`0TWBCATEG`
Characteristic	Transaction type	`0TWBTTYPE`
Characteristic	BPCA ID	`0SM_TWBS___F143`
Characteristic	Tester (assigned)	`0TWBATSTER`

Variables
Object Type	Name	Technical Name
Variable	Text variable for test case status to display the column description	`0TWBTCTX`
Variable	Test case status (1) which shall be used for calculating the number of test cases in the 2nd column.	`0TWBTCS1`
Variable	Test case status (2) which shall be used for calculating the number of test cases in the 3rd column	`0TWBTCS2`
Variable	Test case status (3) which shall be used for calculating the number of test cases in the 4th column	`0TWBTCS3`
Variable	Test case status (4) which shall be used for calculating number of test cases in the 5th column	`0TWBTCS4`
Variable	Test case status (5) which shall be used for calculating number of test cases in the 6th column	`0TWBTCS5`
Variable	Test case status (6) which shall be used for calculating number of test cases in the 7th column	`0TWBTCS6`
Variable	Text variable for message priority to display the column description	`0TWBMPRT`
Variable	Message priority (1) which shall be used for calculating the number of messages in the 8th column	`0TWBMPR3`
Variable	Message priority (2) which shall be used for calculating the number of messages in the 9th column	`0TWBMGP2`
Variable	Message priority (3) which shall be used for calculating the number of messages in the 10th column	`0TWBMGP1`
Variable	Message priority (4) which shall be used for calculating the number of messages in the 11th column	`0TWBMPR4`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Test Plan	`0TWBTPID`	—

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Number of tests	`0TWBTCCNT`	Total of tests of all statuses
Formula	Number of tests with status specified in 0TWBTCS1	`0TWBTCCNT`	Sum of tests with status (1)
Formula	Number of tests with status specified in 0TWBTCS2	`0TWBTCCNT`	Sum of tests with status (2)
Formula	Number of tests with status specified in 0TWBTCS3	`0TWBTCCNT`	Sum of tests with status (3)
Formula	Number of tests with status specified in 0TWBTCS4	`0TWBTCCNT`	Sum of tests with status (4)
Formula	Number of tests with status specified in 0TWBTCS5	`0TWBTCCNT`	Sum of tests with status (5)
Formula	Number of tests with status specified in 0TWBTCS6	`0TWBTCCNT`	Sum of tests with status (6)
Formula	Number of messages with the priority in variable 0TWBMPR3	`0TWBMGCNT`	Sum of messages with priority (1)
Formula	Number of messages with the priority in variable 0TWBMGP2	`0TWBMGCNT`	Sum of messages with priority (2)
Formula	Number of messages with the priority in variable 0TWBMGP1	`0TWBMGCNT`	Sum of messages with priority (3)
Formula	Number of messages with the priority in variable 0TWBMPR4	`0TWBMGCNT`	Sum of messages with priority (4)