Record the Script - Automate_Studio - 20.3

Automate Studio with Connect User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
20.3
Language
English
Product name
Automate Studio
Title
Automate Studio with Connect User Guide
Topic type
Administration
Installation
Overview
How Do I
First publish date
2018
ft:lastEdition
2024-05-06
ft:lastPublication
2024-05-06T08:28:10.436135

If you make a mistake and decide to click Cancel in SAP, you can delete the script after it opens by clicking File, clicking New, clicking Transaction, and then clicking Discard All Changes in the Save box.

Tip: Tips: Always record and test your script in a non-production SAP system.For the highest-quality recording, click only the SAP fields you want to include in the script. If necessary, practice a few times in SAP before you start to record in Studio.Have your data ready, and do not use F4 Lookup during the recording. Using F4 Lookup can end the transaction and the recording.If you want to create a loop, be sure to type the first line item in the correct location for recording that t-code, and then click Insert Row, Create item, or Page down (depending on the t-code). It's good to record two line items, so that you can see the repeatable pattern. Some t-codes, such as ME21N, require two line items, because the Filter function is not available until you complete the first line item.For information on specific t-codes, see the Studio Step-by-step guides.For more tips, see Studio best practices.

Choose a creation method and log on to SAP

  1. Click the File tab, and then click New.
  2. Click Transaction, and click Create from SAP recording.
  3. On the Studio logon screen, do one of the following:
    • The first time that you use Studio 20.3, choose your SAP system and type your client number, user name, and password in the box that opens.
    • Click the SAP system box, click the SAP system you want to log onto, and type your password.
    • Click Advanced SAP Logon. In the SAP Shuttle Logon box, choose your SAP system, and then type your client number, user name, and password.

      For more information on Group Logon, message server logon, and other options, see Add SAP system.

    Note: To save your credentials for future sessions, check the Save as auto logon credential box and type a name for the credentials in the Auto logon name box. The next time you log on to SAP from Studio, you will see your auto logon name in the SAP system box and your other credentials. All you have to do is click the Log on to SAP button.
  4. Click Log On to SAP.

Record the script

  1. In the Transaction code box, type the t-code you want to use to upload data to SAP.
  2. If you want to record the script in Batch Input mode, Non-Batch Input mode (with or without controls), or GUI Scripting mode, click Change, click the mode you want, and then click OK.

    The mode options depend on whether you are using Automate Function Module (WFM). If WFM is installed on the SAP system, the default mode is Standard, and WFM selects the optimum mode for the t-code that is being recorded. If WFM is not installed, the default mode is Non-Batch Input Mode without SAP controls.

    For more information, see Recording modes.

  3. In the Data type box, choose the type of data file you want to use—an Excel worksheet or an Access database.
  4. To use an existing data file for your script, check the I have an existing data file box, and then click the folder icon next to the Data file box and browse to the file that you want to use.
    Note:

    If the data file contains any PivotTables, 3-D charts, or custom XML, the file will open in read-only mode. To keep PivotTables and other elements in the file, open it in Excel and run it in Background Mode.

    Password-protected files and .xlsb files are not supported.

    Note: If you are using Access as the data type, choose an existing Access database for best results.
  5. To automatically map the fields to the data file, check the Auto map when recording is finished box.
  6. Click Start Recording.
  7. In the SAP Console, enter values in the fields that you want to include in the script.
    Note:

    Do not use F4 Lookup while recording.

    When selecting views, use the view selector button instead of the tabs.

    To stop the recording without finishing the script, click Discard Recording.

  8. When you have finished entering data, click the SAP Save button.

For the next step, see Map the fields.

Record a transaction that includes a loop

If you are recording a transaction that includes multiple line items for one set of header fields, follow steps 1-7 above, and then do the following:

  1. Type information into the fields that will become the header, and then press Enter.
  2. Type in the information for one line item.

    Where you type the first line item depends on the t-code. For example, if you record VA01, start on the second row of the grid. If you record FB50, start on the first row of the grid.

  3. Click the SAP Create Item or Insert Row button.
  4. Repeat steps 2-3 to enter the second line item. This creates a visible pattern that you can find in the Mapper. After you add the loop, you will disable the extra line item's rows in the Mapper.

You will add the loop when you map the fields.

Advanced recording features

Recording modes

Using Transaction with Virsa Firefighter or GRC

Record long text

For troubleshooting specific situations, see Automate Support.