If a mapping uses multiple SAP ECC sources, use one Application Source Qualifier to join the sources. The sources you join in an Application Source Qualifier must be accessible from the same application server, and they must have primary-foreign key relationships. To join tables, link the columns to one Application Source Qualifier.

When you join sources, the ABAP program can perform an inner join or an outer join. The Designer generates a left outer join in the ABAP program if you select outer join in the ABAP Program Flow dialog box.

If you generate the ABAP program using exec SQL, the ABAP program can only perform an inner join. If you generate the ABAP program using open SQL or ABAP join syntax, you can select the join type in the ABAP Program Flow dialog box.

When you join sources, the Designer uses primary-foreign key relationships to determine the default join condition and, with open SQL, the default join order.

You can enter the join condition in the ABAP Program Flow dialog box.