You use this query to check the planned and actual test effort required for executing test cases, over time. You can analyze if planned targets have been met and monitor the status of the overall effort for all test cases.
Note
You can use the Status Progress View (technical name 0TWB_V_TEST_EFFORT
) to retrieve the distribution of test case statuses upon execution of this query.
Object Type | Name | Technical Name |
---|---|---|
Characteristic | Project |
0TWBPROJ |
Characteristic | Solution |
0TWBSOL |
Characteristic | Test set |
0TWBSEQ |
Characteristic | Nodes |
0TWBNODE |
Characteristic | Node level |
0TWBNDLV |
Characteristic | Node text |
0TWBNDTXT |
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 | 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 | Responsible for test case |
0TWBTCRSP |
Characteristic | Short text of message |
0TWBMSGTX |
Characteristic | Status of message |
0TWBMGST |
Characteristic | Message processor |
0TWBMGPRC |
Characteristic | Message component |
0TWBMGCOM |
Characteristic | Message number |
0TWBMGNO |
Characteristic | Message priority |
0TWBMGPRI |
Characteristic | Calendar year |
0CALYEAR |
Characteristic | Calendar year / month |
0CALMONTH |
Characteristic | Calendar year / week |
0CALWEEK |
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 | Characteristic of SAP attribute |
0SM_TWBS___F122 |
Characteristic | SAP attribute |
0SM_TWBS___F123 |
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 plan) |
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 |
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 5th column. |
0TWBTCS1 |
Variable | Test case status (2) which shall be used for calculating the number of test cases in the 6th column. |
0TWBTCS2 |
Variable | Test case status (3) which shall be used for calculating the number of test cases in the 7th column. |
0TWBTCS3 |
Variable | Test case status (4) which shall be used for calculating number of test cases in the 8th column. |
0TWBTCS4 |
Variable | Test case status (5) which shall be used for calculating number of test cases in the 9th column. |
0TWBTCS5 |
Variable | Test case status (6) which shall be used for calculating number of test cases in the 10th column. |
0TWBTCS6 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Calendar day |
0CALDAY |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Formula | Expected total effort |
D3I3U4T33YNQZKB2ZBKV20JL6 |
Total of planned effort for the whole test plan, including its test packages and test cases, in hours |
Formula | Effort up to now |
ALGM79UKC5CVSULFSZASEN0O3 |
Total of actual effort for all test cases whose execution has begun, in hours |
Formula | Planned effort |
2O7LEJFYGL7F6ICLHQZIVOZL6 |
Total of planned effort for all test cases whose execution has begun, in hours |
Formula | White space |
0LMH0C6O93YXYRP4LEZZ6C3ZE |
Reference graph which is the minimum value of the set consisting of planned and actual effort; the designated area below this graph is displayed white |
Formula | Effort above plan |
0JHQV082VQ89TLIKDRAGC0GTM |
Graph of the actual effort, if it exceeds the planned effort; the designated area below this graph and the reference graph is displayed red |
Formula | Effort below plan |
0HD0PO9HICHLOFC063KXHOTNU |
Graph of the actual effort, if it exceeds the planned effort; the designated area below this graph and the reference graph is displayed green |
Formula | Plan deviation |
D17043ZCB9JS4TZ19PVW297OQ |
Deviation of the actual and planned effort |
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) |