The following section describes the functions of the Xtract Table component of Xtract IS.

Warning! Missing Authorization To use the Table component, access to the designated authority objects (RFC) in SAP must be available. For more information, see the knowledge base article on SAP User Rights: Table.

Extraction types of Xtract Table component

  • Table: Enables mass data extraction directly from SAP tables and views.
  • Table Join: Allows joining two or more SAP tables on the SAP side before extracting.

Objects supported by Xtract Table component

  • Transparent tables
  • Views
  • ABAP CDS views
  • Pool tables (joining not possible)
  • Cluster tables (joining not possible)

Tip: To get information on the basics, refer to Getting Started with Xtract IS.

How to use the Xtract Table component #

  1. Define a valid connection manager that connects to an SAP system, see Connection Manager.
  2. Drag&drop the Xtract component from the SSIS toolbox into your data flow task.
  3. Double-click on the component. The main window of the component opens. The majority of the functions of the component can be accessed using the main window.

More information on working with the Xtract Table component is provided in the following sections.

Tables and Fields

Defining a Table Data Extraction

Table Joins

WHERE Clause



Custom Properties


Avoid Restrictions