PowerExchange for SAP NetWeaver User Guide for PowerCenter

Back Next

Rules for Specifying Join Conditions

Use the following rules to specify join conditions:

Join conditions must follow ABAP syntax. Specify the join condition using the following syntax:

TABLE_NAME2-FIELD_NAME = TABLE_NAME1-FIELD_NAME

If you want to enter two statements in the join condition, separate the statements with a semicolon (;) or AND.

The syntax for join conditions is the same regardless of whether you configure the Application Source Qualifier to use open SQL or exec SQL.

If you do not include the table name with the field name in a join condition, the session might fail due to ambiguous references.

If you create a join condition that joins fields in the same table, the session might result in incorrect data.

To specify a join condition:

In the ABAP Program Flow dialog box, select the Join Condition tab.

Select the table in Program Flow to edit the join condition.

Double-click a table name in Source Level Attributes to view a list of field names.

Double-click the field name to enter it in the join condition.

Enter the join condition.

Click Validate to validate the syntax of the join condition.

Click OK.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.