Multiple Table Extraction through Connected Process

We will see how we can extract multiple tables through chained processes in Process Runner. For the context of this walkthrough we will show the connected process for up to 3 tables (MARA, MARC and LFA1).

Note that you need to have legit authorizations for the target table in SAP for successful extraction.

1.Start Process Runner and launch New Process Wizard.

2.Select Data Extractor module and enter MARA in transaction code and click OK.

3.Similarly create Data Extractor Process file for MARC (MARC.ite) and LFA1 (LFA1.ite).

4.Now we will connect all 3 in a chain (MARA-> MARC-> LFA1) i.e. MARA will run first, followed by MARC and then LFA1.

5.Start from the process which is of least importance (LFA1 in our case) among the tables and connect the processes in the reverse order of importance.

6.Open MARC.ite and go to advanced tab. Select “Enable Connection” and click on folder browse button.

7.Select file “LFA1.ite”.

8.You will notice that the Process Connection would be shown in the left tree view.

9.Save this file.

10.Now Open MARA.ite and connect MARC.ite (which is already connected to LFA1) and save it.

11.Click on Run. Notice that MARA.ite will run first, followed by MARC.ite and then LFA1.ite.

Multiple tables can be connected together in a similar fashion.

This can further be scheduled in Process Runner through Scheduler.

Click here, to check out Pseudo table join of two SAP tables in detail.

Click here, to check out Pseudo table join of three SAP tables in detail.

Next:

Working with Process Runner -Pull Down Menus