QUERY > QUERY Tutorial > Introduction: QUERY templates

Back to

QUERY Tutorial

Introduction: QUERY templates

QUERY provides query templates which guide you through the most common queries used for accounting, finance, material master transactions and help you to customize your own queries. Templates are made available online and can be downloaded to build queries. You can browse all templates or browse only Excel templates or only QUERY scripts. When you select a file, the file name, description, and size is displayed.

Creating a query using Winshuttle Templates

  1. On the Select pane, click Create Query Using Winshuttle Templates.
  2. To use a template, do one of the following:
    • To use a QUERY script template, double-click the template or select the script and click Create. Save it to your computer. You can update this query as required.

    -or-

    • To use an Excel template, download the template to your computer by double-clicking the template or select the script and click Create.
  3. Start the Excel template or open the query file that is embedded inside the Excel template. If you open query script, the embedded query opens. You can modify the query according to your requirements and run it.
  4. If you open the Excel template, you can use the QUERY add-in for Excel to download data into the template.

Firewall issues

If you experience difficulty downloading templates, your company's firewall might be preventing the downloads. Contact your IT department. You can also contact Winshuttle support to have the template sent to you through an e-mail message.

Also in this section

The QUERY screen

Logging on to SAP

Introduction: Getting started with QUERY

Introduction: Building a query

Introduction: Mapping your fields to a result file

Introduction: Submitting files for review

Introduction: Running queries

Introduction: InfoSets, SAP queries, and logical databases