...
Join tables are used to configure SQL join conditions in order to filter the selected data, for table configured in the step. The join table might be used both the current step table configuration. You can still validate the table entries of the join table, but it must be declared in a parent step or a proper predefined database view should be used in the current step instead of the database table. The joined table might be also used for selection criteria as well as read for additional fields to compare.
...
In the step there is VBAK table and we would like to join it with VBKD table to read additional informationsample filtered data.
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 (VBAK fields) FROM VBAK JOIN VBKD ON VBAK~VBELN = VBKD~VBELN