Note: As of Xtract IS Version 5.0, the Table Join component is obsolete. Use the table join functionality of the new table component.

The Table Join component allows to join several tables (and views) on the SAP side and to extract the result.

Possible scenarions are joining data from header and position tables or from attribute and text tables.

The correspondent SQL statement will be generated and executed on the SAP server.

The componente provides additional features as the definition of aggregate functions, where and having conditions.

It is required to install a custom function module on the SAP server to be able to use this component.

Note: Cluster and pool tables are not supported by the Table Join component, but they can be extracted using the table component.

SSIS Version #

The component Table Join requires the SQL Server 2012 Integration Services (SSIS) version or higher. Older versions are not supported.

Define Tables

Define Relations

Select Fields

Where Clause

Aggregate Function

SQL Statement