Choose query fields in an InfoSet or an SAP Query - 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

An InfoSet includes predefined criteria fields, which must be included in your query. You can also select additional criteria fields.

You cannot select additional criteria fields for an SAP Query.

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 InfoSet.
  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 InfoSet or SAP Query and the fields

  1. 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 (XML Form for web services)
    • SQL Server file
    • Reference Data

    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.

  2. Click Create Script.
  3. Click Global Area (all clients on the SAP system) or Standard Area (only the client you are using).
  4. Click SAP InfoSets or SAP Queries
  5. Search for the InfoSet or SAP Query, or click InfoSet/Query Search, click Data Dictionary, and double-click the InfoSet you want.
  6. Check the Output box for each field you want to download data from SAP.
  7. Check the Criteria box for each additional field that you want to use to narrow your query.
    Note:

    You can select additional criteria fields in InfoSets. SAP Queries can use only the predefined criteria fields.

The next step is to define criteria.