Run: Upload the mapped data to SAP - 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

After mapping SAP fields in the Mapper to the columns in the data file, you enter the data and run the script. Each row of data in the data file is uploaded to or downloaded from SAP.

You can upload the data from the Run tab in Studio, or you can use the Excel Add-in. If the script requires data file approval, you must submit the data file to Evolve from the Excel Add-in. Until the script is approved, a Test command replaces the Run command.

Note:

To enter data in an Access database file, click the Map tab, and then click Start Access.

Click the Run tab to view commands for validating and running the script.

The Run tab displays details about the Transaction script and data file that are being used.

Validate the data

First, check that the data meets all of the script's requirements by clicking Check Data.

Next, do one or both of the following:

  • Click Validate to check each row in the worksheet.
    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.

  • Click Simulate to check the document as a whole. This is especially helpful if you are scheduling the script to run later. (Simulate is available only for certain transaction codes and only on systems that have Automate Function Module installed).

For more details, see Validate before the run.

Run the script

  1. Click the File tab, and click Open.
  2. Under Open, click Transaction Solution Library.
  3. Double-click the script in the Transaction Solution Library on the right side of the screen.
  4. Click the Run tab.
    Note:

    To enter data in an Access database file, click the Map tab, and then click Start Access.

  5. Enter the data that you want to upload.
  6. Click the top of the Run button.

    If prompted, save the script file.

    If you do not see the Run button, or you see a button that says Test, either the script has not been approved or you opened a local copy. Open the file from the Transaction Solution Library.

If errors occur while the script is running, Studio continues to upload data for any remaining records. In Excel, any success and error messages returned from SAP are logged into the log result column, with one log per record.

Fix errors

  1. Correct the values.
  2. Click the arrow on the Run button, and then click Run Only Error Rows.

Studio Transaction uploads only the corrected records.

Run options for script developers and runners

These options can be chosen by the script developer or the script runner when the script is run.

  • Run Specified Range: To upload only some of the rows in your data file. Use the Start Row and End Row boxes to specify the range.
  • Run and Stop on Errors: To stop the run on the SAP screen where the error happened. This option brings the SAP screen into the foreground whenever an error occurs during the run.
  • Run First 5 Transactions: To test the data by running the first five rows, or the first five header plus line item transactions, in the data file. This is helpful before you start a large run.
  • Run Error Rows and Unprocessed Rows in a single step: To process Error Rows (rows in which you have fixed the data) AND Unprocessed Rows (rows which have been added or were not processed because the run stopped) in a single step.
  • Run Only Error Rows: To process rows after you have fixed the data in them.
  • Run Only Unprocessed Rows: To run rows that have been added or were not processed because the run stopped. This option can be set by the person running the script.
  • Debug: To open the SAP console and step through the script screen by screen while uploading data from the data file to SAP. For more options, click the arrow under the Debug button and choose Debug Specified Range or Debug First Row Only.

The following options can be set only by the script developer:

  • Require Run Reason: To open the Run reason box when the script is run. Studio adds some basic information about the script, but the person who starts the run can provide more details.
  • Run Only Unprocessed: To run rows that have been added or were not processed because the run stopped. This check box can be selected only by the script developer.
  • Upload Delay (ms): To add a slight processing delay (in milliseconds) between each row for transactions that require a delay for commit code processing.

For troubleshooting specific situations, see Automate Support.