Extract Data From Three SAP Tables Using Dynamic Table Join Feature

This topic describes how to create a table join from more than one SAP table in Process Runner using the dynamic table join condition functionality.

The Data Extractor (DE) module of Process Runner extracts data from tables or views using standard remote function module (RFM) that is provided by SAP.Process Runner also provides a custom data extraction remote function module for other business requirements and optimization. To create a join between tables for custom data extraction, configure the Data Extractor settings in the Tools > Options > Data Extractor tab and select Use Extended RFM. For more information, see Data Extractor.

Scenario:

Let us consider an example of table join between three SAP Tables, LTAP, LTAK and LTBK and the requirement is to extract the data from the following columns, and also other information:

• Warehouse Number/ Warehouse Complex from LTAP
• Transfer Order Number from LTAK
• Transfer Requirement Number from LTBP
Screenshot: LTAP, LTAK and LTBK tables

To extract data from three data tables using join condition

1. Open Process Runner and select New Process. The New Process window is displayed.
2. Select Data Extractor module and in the Table/View Name box, enter LTAP, LTAK and LTBK separated by commas.
3. Select More and clear Automap all fields. You can select the required fields manually.
   Screenshot: Recording a Data Extractor Process file using three tables

   
4. Select OK. The Magnitude Connector for SAP window is displayed. Perform the following steps:
   1. Select the SAP system, select Logon, and enter the information for Client, User, Password, and Language.
   2. Select OK. Process Runner displays a message to indicate that the tables are validated and that you must update the required mappings.
5. Go to the Mapper tab, select the required fields from the three tables, and map the fields to the Excel columns by entering the map values or using the drag-and-drop functionality.
   Screenshot: Mapping the required fields in Mapper tab

   
6. Select Join Condition from the Edit section. The JoinCondtion(<NameOfTables>) window is displayed with the default table join condition on the Join Condition tab and the table names that are included in the join condition on the Tables tab. In this case, the default join condition joins the primary keys of the three tables; the Transfer Requirement Number (TBNUM) from the LTAK table is not a primary key and is not included in the default join condition.

   LTAP INNER JOIN LTAK ON ( LTAP~LGNUM = LTAK~LGNUM AND LTAP~TANUM = LTAK~TANUM )

   INNER JOIN LTBK ON ( LTAP~LGNUM = LTBK~LGNUM )

7. To edit the default condition, perform the following steps:
   1. Add the Transfer Requirement Number (TBNUM) to the inner join with the LTBK table tab.

      LTAP INNER JOIN LTAK ON ( LTAP~LGNUM = LTAK~LGNUM AND LTAP~TANUM = LTAK~TANUM )

      INNER JOIN LTBK ON ( LTAP~LGNUM = LTBK~LGNUM AND LTAK~TBNUM = LTBK~TBNUM )

      Screenshot: Updated join condition

      
   2. To check the join condition for any errors, select Syntax Check.
   3. To display a warning message about the join condition, select Always Display Join Condition Run warning message.
   4. Optionally, to reset the join condition, select Default.
   5. Select OK. The changes to the join condition are saved.
8. Save the Process file and select Run. The Excel file is displayed with the data extracted from the three tables.
   Screenshot: Extracted data

   

For information about how to extract data from three tables using Process Connection functionality, see Create Pseudo Table Join Between Three SAP Tables.