QUERY > QUERY Tutorial > Introduction: Getting started with QUERY

Back to

QUERY Tutorial

Introduction: Getting started with QUERY

Extracting information in QUERY centers on a three-step process: Select-Map-Run, so that you can easily build and execute your query. After each step of the process, you return to the three-pane screen.

You can output your query to Excel, Access, XML, text, SharePoint lists, or SQL Server files. For the purposes of this demonstration, we will output to an Excel file.

Production servers versus nonproduction servers

When you first create a query, it is good practice to build and test the query on a nonproduction servers.

Creating a query

To begin a query

  1. In QUERY, click New.
  2. In the Select pane, click Create Query.

  3. The SAP logon pad appears. Select the server on which you want to build a test query. It is good practice to test only on a nonproduction server.
  4. To set the system as the default for every logon, select Use selected system as default. Click OK.
  5. Under User Data, enter your user name and password. Click OK. The QUERY File Properties dialog box appears.
    • Select the type of data source you want, whether tables, InfoSets and queries, or logical databases. Note that InfoSets and SAP queries must be enabled by the administrator before you can use them.
    • Specify a title, reason for the file, and add comments as needed. For example, a title might be “Materials type” and a reason for the file might be “List material types acquired in past month.”
    • Add a title and the reason why the file was created, if you want.
    • QUERY supplies the SAP system, the alias of the person who created the file, and the time and date on which the new query was started.
  6. If you want to protect the query with a password, click Lock Queryfile, and then enter and confirm a password. Click OK.

Authorization issues

If you cannot complete a transaction and receive authorization errors, ensure that you have Winshuttle Function Module installed. Winshuttle products use remote function calls to access SAP, which add another layer of security to your processes. Verify that you are authorized to access the appropriate Winshuttle authorization objects by clicking the Authorization Object button on the Tools tab. For more information, see Authorizations.

.ini Issues

If you have problems logging on and receive .ini errors, check the location of the .ini file. You may need to point SAP to your .ini file.

Also in this section

The QUERY screen

Logging on to SAP

Introduction: Building a query

Introduction: QUERY templates

Introduction: Mapping your fields to a result file

Introduction: Submitting files for review

Introduction: Running queries

Introduction: InfoSets, SAP queries, and logical databases