You can specify the join condition for each table you join in the Application Source Qualifier. If you do not specify a join condition, the Designer uses one of the following conditions as a default join condition:
Default join condition imported from the SAP system.
Key relationship you entered in the Source Analyzer. PowerCenter converts the key relationship to a join condition when it runs the session.
The ABAP Program Flow dialog box does not display the default join condition. When you enter a join condition in the ABAP Program Flow dialog box, you override the default join condition.
You can also create a relationship in the join condition for tables that do not have a relationship. Creating a relationship in the join condition is similar to specifying a key relationship in the Source Analyzer. However, the key relationship you specify in the Source Analyzer applies to all the mappings in the folder. The relationship you specify in the join condition applies only to the mapping. You can then join the tables using an inner join or an outer join.
The join condition must follow ABAP syntax. The Designer validates the syntax of the join condition in the ABAP Program Flow dialog box.