SAP Query

This page shows how to use the Query extraction type.
The Query extraction type can be used to extract data via SAP queries.

About SAP Queries

SAP Queries are used to access data sets in SAP, see SAP Help - Working with Queries for more information. The SAP queries that can be used with Query extraction type are created by the SAP transactions SQ02 and SQ01. To use a BW Query as a data source, see BW InfoCubes and BExQueries.

Prerequisites

• A connection to an SAP system is available, see SAP Connection.
• The SAP user has sufficient user rights, see SAP Authority Objects.

Create a Query Extraction

1. In the main window of the Designer, click [New] to create a new extraction. The window "Create Extraction" opens.
   
2. Select an SAP Connection from the drop-down menu in Source and enter a unique name for your extraction.
3. Select the extraction type Query and click [OK]. The main window of the extraction type opens automatically.

The majority of the functions of the extraction type can be accessed in the main window.

Look up an SAP Query

1. In the main window of the extraction type, click [ ]. The window "Query Lookup" opens.
   
2. Enter the name of an SAP query in the field Query Name or the name of a user group in the field User group . Use wildcards (*) if needed.
   
3. Select the query work area that contains the query object . For more information, see SAP Help: Query Areas.
4. Click [ ]. Search results are displayed.
5. Select a query and click [OK].

The application returns to the main window of the extraction type.

Define the Query Extraction Type

The Query extraction type offers the following options for query extractions:

1. If the SAP query has variants, select a variant from the drop-down-list Variant. For more information, see Choose a Variant.
   
2. In the section Selection Screen, edit a selection criterion you want to change or dynamize . For more information, see Edit Selections.
   
3. Check the Extraction Settings and the General Settings before running the extraction.
4. Click [OK] to save the extraction type.

You can now run the extraction, see Run Extractions.