When using and upgrading a SAP system, an extensive amount of manual testing is required, which consumes time, resources and manpower. The main advantages of automated testing are:

Reduction in time to perform the necessary tests
Time saved can be reinvested into higher priority projects
Extensive and complete testing

One solution that can provide the automation of testing is our tool KATE (abbr. of Kit for Automated Testing). KATE by DataVard is a tool for automated tests in frontend testing based on WebTemplate testing and backend testing for various scenarios.

Frontend Testing can be used for the Web Template regression testing to ensure all basic functionalities remain functional despite the changes in the development. Backend Testing offers following functionalities:

Test query outputs on a large scale – Query testing is based on an idea of using a before image and an after image. These images contain results of all the selected queries/bookmarks, which are then stored for later comparison. The after images and before images are then compared to check if both results are the same. The testing of the same queries between two different systems is also supported with the use of RFC functionality.
Test InfoProviders content – Involves the Execution of ListCubes with specified characteristics selections. All key figures are always returned while settings for the DB aggregation, Read NLS, MAX Rows and Number of Hits can also be applied. Results of ListCube execution are stored as before/after images and are compared for similarity. Testing the same queries between two different systems is also supported with the use of RFC functionality.
Test of transformations – is for the Generation of Data Transfer Processes (DTP) and their execution. From the loaded data, the before and after images are created for comparison. By executing the same load two times you can verify if these were performed correctly or if there were any changes made in the transformation logic (changes in lookups, runtimes and other).
Test table content – Involves the creation of data images for Database Tables with specified fields. These fields are used either as characteristics or aggregated key figures columns; the images created are stored and compared for similarity. The testing of the same tables between different systems is also supported with use of RFC functionality.
Test report outputs – Involves the execution of reports with/without variants and the gathering of their outputs that are saved in the spool.

Backend Testing can be used to ensure that after changes in the systems (i.e. system upgrade, migration) were made the data remains unchanged.

Prerequisites and installation

The KATE tool is supplied to the customers in the form of a single transport request with all available functionalities included. DataVard’s Reuse Library is also provided together with KATE and is necessary for the customers that did not receive it yet with other DataVard tools.

All users working with KATE should have authorization “DVD_KATE” assigned, that is included in KATE installation transports.

KATE Restrictions

KATE Section	Prerequisites
General	Windows 7, Windows 8.1 machine SAP BW 7.0 to 7.4 (Recommended 7.01 or higher)
Dashboard	Internet Explorer 8 or more (9 or more recommended)
Test Case Document, Status Document	MS Word (Office 2007 – Office 2016)
Test Plan Report	MS Word (Office 2007 – Office 2016)
Web Template Test Case	Internet Explorer 8 or more with: ActiveX enable Scripting enabled MS Excel (Office 2007 – Office 2016, 32-64 bit) Web Templates newer than 3.5 version
Web Intelligence Test Case	Internet Explorer 8 or more with: ActiveX enabled Scripting enabled MS Excel (Office 2007 – Office 2016, 32-64 bit) SAP BusinessObjects BI Platform 4.1 Support Pack 6
ListCube and DrillDown Test Case	For NLS data testing, SAP 7.3 or more needed
DTP Test Case	Transformation with source: InfoCube, DataSource and DSO are supported Transformation with target: InfoCube, DSO and WODS are supported
Frontend Testing	Scripting enabled on server for ‘sapgui/user_scripting’ parameter Activated scripting for SAP GUI without notifications Disabled SAP GUI security settings on test execution machine

Note: KATE contains tables that are client dependent. Therefore it is required that the KATE transport is imported into the system using the same client where the users will be working with the tool.

KATE Terminology

In this section, basic terminology used in KATE tool is described for better understanding of following chapters.

Test Case – is a basic testing scenario, and the Test Case is a reusable component used in Test Plans, where the Test Cases are executed. Each Test Case is a schema of steps, while steps are defined by variant/variants. Example Test Case 1:

Type: ABAP Test Case
Schema: Execute program CONVERSION_CHECK

Example Test Case 2:

Type: ListCube Test Case
Schema: Create Images for InfoProviders and compare them

Test Case Variant – is the definition of a Test Case step with values that enable the Test Case execution in a Test Plan. The Test Case can be defined by one variant or by multiple.

Example Test Variant 1:

Variant: Execute program CONVERSION_CHECK with standard program variant ‘ALL’ (selection screen options)

Example Test Variants 2:

Variants: InfoProvider ZDC_CUBE1, InfoProvider ZDC_DSO1

Test Plan – specifies combination of Test Cases that can be executed. Test Cases (with variant/variants) assigned to Test Plan have their execution status.

Initial KATE Setup

KATE supports several Test Case types, not all of which may be relevant for you. Therefore, the customization transaction /DVD/KATE_SETUP provides options to only display the Test Cases that are relevant.

Note: After first installing KATE, this transaction needs to be customized according to customer’s preferences.

_{Figure 1:Kate setup}

Dashboard

The KATE Dashboard provides you the overview and access to KATE functions. When KATE is installed in your BW, you can run the transaction /DVD/KATE.

The buttons located at the top of panel and at the bottom of the screen navigate you through the functionality.

_{Figure 2:Kate Dashboard}

The following buttons can be found in KATE Dashboard:

DataVard Button
Refresh (F5)
Test Management
Worklist
Settings
Select Plan/Dir To Display (button inside „Dashboard“ section)

DataVard Button

The DataVard Button is located in the upper left corner of KATE Dashboard; this provides you with general information about the KATE tool, and your license information. You can view more information about other DataVard products for your BW, below the section for KATE.

_{Figure 3:DataVard button}

Select Plan or Directory

The KATE Dashboard contains visual charts that allows you to view the data related to Test Plans (i.e. what is the current status of the Test Plan or what was the progress of the Test Cases in the Test Plan since the testing started).

_{Figure 4:Selecting a Test plan}

Select one of the listed Test Plans, which will be displayed after clicking on the button and several statistics will show up.

_{Figure 5: List of all available Plans in Test Management}

After selecting the Test Plan or Directory, charts will appear as follows

_{Figure 6: KATE Dashboard with charts}

KATE Dashboard contains three additional buttons (from left to right):

Select Plan/Dir To Display – allows you to choose another Test Plan
Close Interactive Charts – closes the chart section and returns you to Dashboard without charts
Expand To Dashboard Full View – allow you to view the charts in a larger scale. The Interface of Dashboard Full View looks like this

_{Figure 7: Dashboard Full View}

The Dashboard Full View contains only Refresh (F5) button. You can return to normal Dashboard by pressing Back button (F3).

The Dashboard also remembers the last chosen Plan even after closing KATE and it will open again when the KATE Dashboard is re-launched.

The Dashboard with charts contain 3 tabs:

Actual Status
Timeline Status
Testers Overview

Each of these tabs shows different sets of data.

Actual Status

The Actual Status tab (shown of Figure 8) contains all Test Cases within a selected Test Plan with their last assigned status. If you want to see statistics for Variants of Test Cases rather than Test Cases themselves, check Display Variants checkbox in lower left corner (under the chart).

_{Figure 8: Displaying statistics for Test Cases (left) and Variants (right)}

Note that when you hover over different parts the charts will display captions.

Timeline Status

The Timeline Status tab contains a timeline that represents the changes over time of a selected Test Plan.

_{Figure 9:Timeline status}

This chart also shows additional information on hover over chart columns.

Testers Overview

The Testers overview tab contains all testers participating on a selected Test Plan and their statistics.

_{Figure 10: Testers Overview}

This chart also shows additional information on hover over chart columns.

Browser not supported