PowerExchange for SAP NetWeaver User Guide

Back Next

Join

When you have two or more tables in a data object read operation, you can specify a join condition to join data from multiple tables.

You can configure an inner join or a left join.

The following table describes the properties that you can specify when you configure a join condition:

Property	Description
Joiner Condition	The type of join that you want to configure. Select one of the following options: Inner join Left join
Platform Expression	The expression that you use to join tables.
Left Field	The SAP column on which you want to apply the join condition.
Operator	Simple operators that you can use to join tables. You can select one of the following operators: =, >, >=, <, <=, !=
Right Field	The value you specify to join the SAP tables.

The following restrictions apply when you use an SAP Table data object to read data from SAP tables:

You cannot join more than one SAP cluster or pool table.

You cannot use a left join with a filter condition to join two or more transparent SAP tables.

You cannot use a left join to join a transparent table and a cluster or pool table.