Help Center>Studio v11 (Foundation)

Choose tables and fields

choose step of choose define map submit approve run process

To build the query that the script will use, you add tables to the workspace on the Studio Query Workspace tab and choose the fields for the data you want to download.

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

Important: The number of tables that you can add to a query is specified in the Foundation site's settings. To change the number of tables, go to the Foundation site, click Settings, and then click Developer Proficiency Level. If you do not have access to these settings, contact your Foundation site manager.

Winshuttle Function Module is required for multiple-table queries on systems that are running Winshuttle SAP Integration Server v11.x.

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 Tables.
  4. On the Winshuttle 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.

    Tip: 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.

Choose the tables

  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
    • XML Form (for web services)
    • SQL Server file
    • SharePoint list

    drop down list of data file choices

    Note: 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. On the Studio Query Workspace tab, you have several ways to add tables:
    • In the Quick add box, type the table name and click Add to Workspace or press Enter.

      To add multiple tables, type the names separated by commas or spaces. For example: MARA MAKT MARC or MARA,MAKT,MARC.

    • In the Search for tables box, type part of the table name or description and a wildcard character—for example, mat*l. Use the options in the drop-down list to narrow the search.

      search options are all table table description field field description

      Then click Search and click the Add Table to Workspace button in the Search Results pane.

      add a search result to the workspace

      Note: To see which fields are in the table before you add it, click the Inspect Table button, which is next to the Add Table to Workspace button.

    • Click the drop-down list at the top of the pane, click Data Dictionary, browse to the table you want, and then drag it onto the workspace.

      table search drop-down list

The tables in the workspace are connected by inner joins.

inner join between two tables

If you are using only one table, you can add it again and join it to itself. If you have tables that aren't connected by joins, you can manually add the joins or find an intermediary table to connect the other tables. You can also convert inner joins to left outer joins. For more information about joins, see Create joins between tables.

Select the fields

  1. Check the Output box for each field that you want to download data from SAP.

    Note: If an input field has a conversion exit applied to it, no data will be returned.

  2. Check the Criteria box for each field that you want to use to define the data set that you are downloading.

    For example, if you want 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.