Create a script to query SAP

Creating a Query script is a five-step process.

  1. Choose fields by using tables, InfoSets, or logical databases. Or, if you are more familiar with transactions in SAP, you can create a query from a transaction recording.
  2. Specify criteria.
  3. Map the script's fields to a data file.
  4. Submit the script for approval.
  5. Run the script to download the data from SAP.

These topics walk you step-by-step through the basic end-to-end process of building and running a query.

For information on more advanced features, see the Best Practices or click the links at the end of a topic.

Important: The number of tables that you can add to a query is specified in the Evolve application configuration settings.
Important: If you are not able to add all the tables you need, contact your Evolve application manager or consider using an InfoSet or a logical database (LDB).

Approving your own queries

If you have a Solution Developer role, and if self-approval is enabled by the administrator, you can run files on a non-production server without submitting them for approval.

If your Evolve application administrator removes the approval requirement, all queries can be created and run without first being approved.