Choose query fields from a recording - 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

If you are not familiar with the tables you need to use, and you are familiar with transactions in SAP, you can find the tables by recording an SAP transaction.

Fields that are in structures, instead of tables, will not be included in the recording.

After you choose the fields, you narrow the data set that you want to download by specifying criteria.

Choose the creation method and log on to SAP

  1. Click the File tab, and then click New.
  2. Click Query.
  3. Under Choose a Creation Method, click Create from Recording.
  4. On the Studio logon screen, do one of the following:
    • Click the SAP system box and then click the SAP system you want to log onto.
    • Click Advanced SAP Logon. In the SAP Logon box, choose your SAP system, and then type your client number, user name, and password.

    To save your credentials for future sessions, check the Save as auto logon credentials 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 logon button.

  5. Click OK.

Select the tables and fields

  1. In the Transaction Code box, type the T-code you want to record.
  2. In the Recording Description box, type a description for the recording. The description must be unique.
  3. In the Data type box, choose the type of result file you want to use for the downloaded data:
    • Excel worksheet
    • Access database file
    • Text file
    • Web Form
    • SQL Server file
    • Reference Data list

    The account that you use to write to SQL Server must have db_owner or db_ddladmin membership on the database that contains the target table.

  4. Click Create Script.

    The SAP GUI opens.

  5. Record the transaction. Be sure to enter data for all the fields that you want to include in your query.

    If you do not want to commit the data to SAP, exit out of SAP GUI instead of clicking Save.

    After you complete the recording, Query opens on the Workspace tab.

  6. Under Data Dictionary, click the arrow next to Recorded Transaction Codes (RC), and then click the arrow next to your recording.
  7. Drag a table to the workspace, or double-click it.

    The fields that you changed during the recording are already selected.

    Note:

    Some of the tables might contain only fields such as check boxes. Click the table, click Inspect Table, and confirm that the table contains fields that you want. If it does not, click the red x in the upper right corner of the table to remove it from the query.

  8. Check the Output box for each additional field that you want to download data from SAP.
  9. Check the Criteria box for each field you want to use to define the data set that you are downloading.

    For example, if you want to tell Query to return material data based on a range of material numbers, check the Criteria box for the MARA.MATNR field.

The next step is to define criteria.