USE:
Join tables are used to configure SQL join conditions for table configured in the step. The join table might be used both for selection criteria as well as read additional fields to compare.
PROCEDURE:
- Select the Step and table that you would like to add join condition
- Double click on Join Tables
- Add table name, save and mark added row
- Double click on Join Conditions
- Add the fields from initial and joined tables
EXAMPLE:
In the step there is VBAK table and we would like to join it with VBKD table to read additional information
sample configuration for joining sales order item with Sales order Business Data:
Screen 1:
Table Name |
|---|
| VBKD |
Screen 2:
Field Name | Join Field Name |
|---|---|
| VBELN | VBELN |
Above will generate following SQL statement:
SELECT () FROM VBAK JOIN VBKD ON VBAK~VBELN = VBKD~VBELN