Validate and test the script - Automate_Studio - Latest

Automate Studio with Evolve User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
Language
English
Product name
Automate Studio
Title
Automate Studio with Evolve User Guide
Topic type
How Do I
Administration
Installation
Overview
First publish date
2018
ft:lastEdition
2024-06-13
ft:lastPublication
2024-06-13T14:35:52.915393

To ensure that anyone who runs your script first validates the data in the data file before posting it, you can turn on validation.

Validation checks the data row-by-row, but it does not check the document as a whole. To check the entire document, click Simulate.

Note:

Validate will not check upload fields in the last screen of the recording. Any errors in those fields will be returned during the run.

Validate

When data validation is turned on, you do not need a separate validation sheet.

Turn on data validation

Important: Before you turn validation on, be sure that the script contains only one commit code and that the commit code appears at the end of the script.A commit code represents any kind of save action. Example commit code values include =BU and =SICH.If a transaction script contains more than one commit code, some of the data might be committed to SAP during validation in Studio 11 and 11.0.1. This has been fixed in Studio 11.0.2 and later.Exception: PA30 and PA40 are supported if Automate Function Module 11.1 or later is installed and the script contains only one commit code.
  • On the Map tab, click Allow Validation.
  • Studio automatically adds the Validate Log field to the Mapper and maps it to the data file.

Validate the data against the script's rules

Click Check Data to check that the data meets all the script's requirements for required fields and allowed values. You do not need to be logged on to SAP.

Validate the data against SAP

Validate checks the fields in each line item against both the script's requirements and the requirements in SAP. Errors are returned against the individual line items, and the results are written back to the data file against each line item. Validate does not check the document as a whole. Validate is not supported for HR t-codes with the exception of PA30 and PA40.

You must be logged on to SAP. You can log on from the lower left area of the status bar on the Run tab.

Next, validate the line items against SAP.

  1. On the Run tab, click Validate.

    When you validate, the data is uploaded to SAP but it is not committed to SAP, as long as there is only one commit code and it is at the end of the script.

  2. Correct any errors or make changes.
  3. Click Run to upload the data.

Studio gives you additional validation options. Click the arrow below the Validate button to do any of the following:

  • Validate Specified Range
  • Validate First 5 Transactions
  • Validate Error Rows and Unprocessed Rows
  • Validate Only Error Rows
  • Validate Only Unprocessed Rows
    Note:

    When you click Validate Only Unprocessed Rows, the setting can be changed only by you, the script developer. Runners cannot change this setting.

Validating data in loops

In an Excel data file, validation checks all line items, and the validation log messages appear next to the individual line items.

Important: Automate Function Module does not support validation of multiple Do-While loops at the same level in a transaction script. Nested loops are supported. Validation is not supported for Access data files that contain loops.

Validating linked scripts

You can run validation on linked scripts in the following configurations:

  • Column-based mapping and cell-based mapping in Excel forms
  • Column-based mapping in Access forms
  • Column-based files linked to cell-based files and vice versa
  • Linked scripts with different types of data files

Validation for cell-based mapping

When you turn on validation for the script, Studio automatically maps the Validate Log column to the first empty row. In the Mapper, the Validate Log row appears below the Log row.

Simulate

Simulate checks the fields in each line item against the script's requirements and checks the entire document against the requirements in SAP. Click Simulate, or click the arrow for the following options:

  • Simulate Specified Range
  • Simulate First 5 Transactions
  • Simulate Error Rows and Unprocessed Rows
  • Simulate Only Error Rows
  • Simulate Only Unprocessed Rows

Simulate: supported t-codes

Studio version Simulate: supported t-codes
20.3 F-02, F-05, F-22, F-43, F-65, FB01L, FB50L, FB65, FB75, FBB1,FBV1, FV50, FV50L, FV60, FV65, FV70, and FV75, FB01, FBD1, FBS1, FB50, FB60, FB70, ME21N, ME22N, ME51N, PA30, PA40VA01, and VA02.

 

Test the script

After you run validation or simulation, you can test the script by running it on a non-production server.

On the Run tab, click Test and select the run options that you want.

The results of the test will be displayed in the yellow bar.