Join Tables

USE:

Join tables are used to configure SQL join conditions to filter the selected data for the current step table configuration. You can still validate the table entries of the join table. However, 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 also be used for selection criteria as well as for 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 the added row
Double click on Join Conditions
Add the fields from initial and joined tables

EXAMPLE:

There is a VBAK table in the step, and we would like to join it with the VBKD table to read 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 the following SQL statement:

SELECT (VBAK fields) FROM VBAK JOIN VBKD ON VBAK~VBELN = VBKD~VBELN