The Table Join component allows to join many 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 funktion 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.

Caution! Please note that this chapter only describes the use of the Table Join Component. For all other basics please refer to Step I: Define a Table Extraction . For this chapter the knowledge about the basic usage of the BOARD Connector is assumed!

Define Tables

Define Relations

Select Fields

Where Clause

Aggregate Function

SQL Statement

Settings