The following section describes the functions of the Table component of Xtract for Alteryx.
The Table component can be used to extract content from SAP tables and views and process it in Alteryx. The Table component is also used to join several tables on the SAP side, see Table Joins.

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

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

Objects supported by the Table Component #

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

Restrictions #

When extracting tables from older SAP releases you may encounter restrictions when using the SAP standard function module (RFC_READ_TABLE). Possible restrictions include poor performance with large tables, limited width of columns, etc.

To avoid restrictions, install the Theobald Software custom function module /THEO/READ_TABLE on your SAP system, see Custom Function Module for Table.

How to use the Xtract Table component #

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

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.


Functions Overview

Defining a Table Extraction

Table Joins

WHERE Clause

HAVING Clause

Extraction Settings

Runtime Parameters