(DV-2205) ERP Report Execution & Backend

Owned by SNP
May 20, 2022
6 min read

Prerequisites

Before executing of ERP Report Test the following prerequisites has to be set:

  1. Decimal notation (decimal and thousandths separator) and date/time format of the user who executes the ERP Report Tests has to be the same on all systems from which report output images are created. In the case of using the RFC connection, the user name used in the connection is relevant.
  2. Printing layout format for tested reports should be predefined for using layout X_65_132. This should be set for a user who will execute the Report Testing. Using the same printing format for all tested reports can be also set with setup printing format on wrapping report /DVD/EQS_RUN_REPORT_WRAP (see section Setup printing format layout).

ERP Report Test Case Execution

When an ERP Report Test Case is added to a Test Plan then a new backend Test Run is automatically created and a Run ID is generated. The description holds the technical name of the Test Plan and the Test Case. All of the Report Variants selected during the creation of the ERP Report Test Case are automatically added into Report Variant selection for the generated Test Run.

To execute an ERP Report Test Case from the Test Management click on Execute , which will display the standard ERP Report Testing scenario.

Report Variant Execution Authorization!

To create, change, or display report variants, you need proper authorization. It is checked against Auth. Object /DVD/VVAR. Auth. Fields checked are 'Activity' (16 - Execute), 'Validate test type' (REP - ERP Report), and then 'Variant testing object and sub-object' (which in this case are report name and its variant).

User starting execution must have appropriate authorization. If another user is specified to run the report, both user executing the variant and the user executing the report must have appropriate authorization. In case of execution via RFC the user used in RFC connection must also have appropriate authorization.

Default '/DVD/VALIDATE' role allows you to execute all reports whose names start with '/DVD/', all report variants are allowed. At the moment 'Test Plan' and 'Test Case' are not checked.

Report based testing

The Report based testing scenarios execute and focus on the ERP standard reports, with or without variants. 

The reports are executed with background jobs and their output is saved to the spool. The outputs are then read after the execution and are compared based on your preferred settings. 

Test scenario EQS_ERP (Report testing)

Report Testing Scenario


Report testing contains the following steps:

  1. Selecting Report Variants
  2. Generation of before image tasks
  3. Creation of before images
  4. Performing a specific task in the system outside SNP Validate (like conversion, migration, etc.)
  5. Generation of after image tasks
  6. Generation of comparison tasks
  7. Execution of comparison tasks
  8. Display of results

Select Report Variants

By double-clicking on the first Test Step Select Report Variants you can define which Report variants are to be used in the specified Test Run for testing, or you can create new Report Variants. 
Once you have the variants selected for the Test Run you need to save the selection by clicking on the button Save  (Ctrl + S) in the main screen of the Report variants selection.
You can add Report Variants in the following ways:


Create New Report Variant –  You can create a new Report Variant by clicking on Create New Report Variant button (Shift + F4). For more information please refer to Create New Report Variant section. 
Add Existing Report Variant – You can display all of the existing Report variants in the system by clicking on the Add Existing Report Variant button (SHIFT + F5), select one or more variants to be added into the Test Run. 
Add Report Variants of Run – By clicking on the Add Report Variants of Run button (SHIFT + F6) you can select another (distinct from current) run, and add all of the Report Variants used in this Test Run also into the current Test Run. 
Copy Report Variants of Run – By clicking on the Copy Report Variants of Run button (SHIFT + F8) you can select another (distinct from current) run, and add all of the Report Variants used in this Test Run also into the current Test Run as copies. 
Add Variants of Test Case – By clicking on the Add Variants of Test Case button (SHIFT + F11) you can select the existing Test Case, and add all of the Report Variants used in this Test Case into the current Test Run.
Copy Variants of Test Case – By clicking on the Copy Variants of Test Case button (SHIFT + F12) you can select the existing Test Case, and add all of the Report Variants used in this Test Case into the current Test Run as copies. 
Copy Variants – Please refer to Copy Variants section for function details.

Generate tasks for before image

You can execute the generation of tasks by double-clicking on generate step or selecting generate step and clicking on Execute  button. This will prepare the tasks for the following step Create before images.

Create before images

By double-clicking on this step, you first define the number of background jobs to be used to create the before image for each of the specified Report variants. Then data images of report outputs for each selected variant will be created and saved.

Generate tasks for after image

You can execute the generation of tasks by double click on generate step or selecting generate step and click on Execute  button. This will prepare the tasks for the following step Create after images.

Create after images

By double-clicking on this step, you first define the number of background jobs to be used in the creation of the after image of the specified Report variants. Then data images of report outputs for each selected variant will be created and saved.

Generate tasks for comparison

You can execute the generation of tasks by double click on generate step or selecting generate step and click on Execute  button. This will prepare the tasks for the following step Compare before and after images.

Compare before and after images

You define the number of background jobs to be used for tasks execution. Each of the tasks compares the before image data with the after image data for one Report Test Variant, please refer to the Comparison logic section.

Display of results

By clicking on this step you can review the output and comparison results of reports executed in the steps before. There are some differences between the report testing scenario and other scenarios, which are specified more in detail in the section Reports Display Results.

Setup printing format layout

The printing format layout X_65_132 has to be set for the report /DVD/EQS_RUN_REPORT_WRAP. The program directly executes tested ERP report for getting report output. The printing format defined for him is adopted by all reports which are tested. Proper format guarantees that report outputs will not be cut out at the end of each line and will be written in the same format for before and after image.

To set up the proper format, do the following steps: 

  1. Run report /DVD/EQS_RUN_REPORT_WRAP via transaction SE38 to display selection screen.  
  2. Choose option Execute in Background (F9) in Program menu. 
  3. Click on button Properties in the displayed popup. 
  4. Click on button Specification (or Defaults on higher releases) in the displayed popup. 
  5. Now add the following default values for printing parameters for the current report only. 
  6. Confirm the setup of the top popup window and close the rest (without confirmation and execution).