When you select multiple source objects as the source type, you can configure a relationship to join multiple source objects.

To configure a relationship using the join condition between the source and the related objects, specify the key field in the source SAP object, the type of join, the join operator, the related SAP object and the key field in the related object, and then click

ADD

.

For example, to configure an inner join to join the EKKO and EKPO tables when the value of the EBELN field of the EKPO table is less than the value of the EBELN field of the EKKO table, use the following format:

EKKO.EBELN Inner Join < EKPO.EBELN

The following image shows a configured custom relationship that uses an inner join to join the EKKO and EKPO tables when the value of the EBELN field of the EKPO table is less than the value of the EBELN field of the EKKO table:

Consider the following guidelines when you configure a relationship to join multiple source objects:

When you join a cluster table or pool table with a transparent table, include all key fields in the transparent table in the join condition. List the fields in the order that they appear in the SAP system.
When you join a cluster table or pool table with a transparent table, use all of the source fields in the transparent table that you use in the joins and filters in the field mapping. Also, map at least one field from the cluster or pool table.
You can't configure a custom relationship that uses a right outer join for SAP Table objects from the SAP NetWeaver system version 7.40 SP04 or earlier.