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 function module on the SAP server to be able to use this component.
SSIS Version #
The component Table Join requires the SQL Server 2012 Integration Services (SSIS) version or higher. Older versions are not supported.