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.

The number of tables that you can add to a query is specified in the Evolve application configuration settings.

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.