We will see how we can extract multiple tables through chained processes in Process Runner. For the context of this walk through 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 from Start Page, click File -> New Process -> New Data Extractor as shown below
 |
2.Select Data Extractor module and enter 'MARA' in Table/View Name 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 click on 'Process Connection' option stationed at View group, click on folder browse button.
7.Select file “LFA1.ite”.
8.You will notice that the Process Connection would be shown at the left pane in 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.