Xtract Query

This page shows how to use the Xtract Query component.
The Xtract Query component 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 Xtract Query component 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.

Add an Xtract Query Component

Follow the steps below to add an Xtract Query component to your workflow:

1. Drag & drop the Xtract component to your Alteryx workflow .
2. Assign an existing SAP connection .
   
3. Click [ Edit] to open the main window of the component.

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

Look up an SAP Query

1. In the main window of the component, 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 component.

Define the Xtract Query Component

The Xtract Query component 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 before running the workflow.
4. Click [OK] to save the component.

You can now run the workflow.