Table Joins

The Join functionality allows joining two or more tables and extract the result of the join. To perform the extraction the corresponding SQL command is generated dynamically and the join is executed on the SAP server.

Possible scenarios can be joining tables for header and item data or tables for master data and texts.

Supported Join Types

The following join types are supported:

• Inner Join
• Left Outer Join, also referred to as Left Join.

For more information on join types see SAP Help: Inner Join and Outer Join.

Prerequisites

To use table join, the function module /THEO/READ_TABLE needs to be available in SAP.

Join Tables

The following example shows how to join the tables KNA1 and KNVV.

1. In the tab Tables and Fields, click [Add] to add two tables (e.g., KNA1 and KNVV).
   
2. Select both tables on the left and check the fields you want to extract .
3. Optional: Switch to the WHERE clause tab and specify a WHERE clause.
4. Switch to the Joins tab . A Join condition with default values is automatically available. The join condition is based on the foreign key relationship of the joined tables.
5. Click [ ] to edit the join condition. The window "Join" opens.
   

6. Select a table column in the Left Table field and in the Right Table field to map the table contents. In the depicted example a left outer join on tables KNA1 (left table) and KNVV (right table) on the field KUNNR is performed. It is possible to add multiple join conditions.

   • Click [Add] to extend the join condition to more fields.
   • Click [ ] to delete existing joins.

   Tip

   Different tables can have identical field / column names. Defining a join condition based on the identical field names not always delivers the expected result, e.g., VBAK~VBELN <> LIPS~VBELN. Make sure the fields you use in a join condition contain the same content/data.

7. Click [OK] to save the join.

You can join additional tables by adding tables more in the tab Tables and Fields.

Auto Mapping

The [Auto-map] button deletes existing join conditions and performs a new field mapping based on the foreign key relationship of the joined tables.