Skip to content

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

Warning

Missing Authorization.
To use the Xtract Query component, access to the designated authority objects (RFC) in SAP must be available. Adjust SAP Authority Objects: SAP Query accordingly.

Add an Xtract Query Component

To add an Xtract Query component to your SSIS package:

  1. Drag&drop the Xtract Query component from the SSIS toolbox into your data flow task.
    New

  2. Double-click the component. A connection manager is automatically assigned to the component.

    Note

    If there are multiple connection managers, the window "Select Connection Manager" opens, see SAP Connection. Once a connection manager is selected, the main window of the component opens.

The main window of the component opens and you can start setting up your component.

Look up an SAP Query

Follow the steps below to look up a query in SAP:

  1. In the main window of the component, click [ ]. The window "Query Lookup" opens.
    Query_main-window_add
  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.
    Look-Up-Query
  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 query is selected and the application returns to the main window.

Configure the Xtract Query Component

Follow the steps below to configure the Xtract Query component:

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

The Xtract Query component is configured and ready to run.

Last update: January 7, 2026