Skip to main content

Record and Run Data Extractor File in Process Runner DB

Data Extractor is a process of extracting table data from SAP in to DS using Process Runner DB for further data processing. You can filter data before extraction using inbuilt featureData Filter in Process Runner DB. Using DD Explorer option, you can search for various Table/Views.

This section contains the following topics:

Extract Data from MARA

This topic describes how to extract data from MARA.

To record and run Data Extractor Process file for MARA,

  1. The steps to create, map, and run a Data Extractor Process file are as follows.
    1. Select File > New Process > New Data Extractor or Data Extractor available on the left side of the New Process window.

    2. In the Table/View Name box, enter the SAP table or view name. For this example, enter MARA.
    3. Optionally, select More and clear Automap all fields. You can select the required fields manually.
    4. If you do not know table name or if you want to find out table joins, select DD Explorer. The SAP Data Dictionary Explorer window appears with a list of all the tables and views as found in standard ECC6 system.

    5. Select OK. The SAP Data Dictionary Explorer window is closed.
    6. Process Runner DB opens the Process file as [MARA| *NEW*] with the Mapper tab opened.

  2. To map the DS tables to SAP Fields, perform the following steps:

    1. Go to the Mapper tab, select Advanced View. A detailed view of the mapper, including the fields that are automatically mapped, is displayed.
    2. Update the mappings; map the fields to the DS by entering the map values or using the drag-and-drop functionality. Optionally, clear the fields that you do not require.

  3. T o save the Process file, select File > Save > Save As Local, enter the name for the Process file, and select Save.
  4. To run the Process file, select Run and the data will be downloaded from SAP system to iTable as shown below:

In Process Runner DB, the Data filter option provides a unique way to classify and download selected pattern of Data from SAP System. see, Data filter.

Data Extractor Advanced Tutorial

This section contains the following topics:

Send Email Notification of Data Extract through Post-Run Script

In this example, you will learn that how a user can be notified by email regarding status of scheduled data extraction process. This mechanism works with the help of Post-Run Script feature.

  1. Start Process Runner DB and open any Data Extractor sample file. For example, consider MARA for this case. Default location for sample file is: \\My Documents\Innowera\Samples\folder.

  2. Go to Edit tab and, select Script And Delays Options > Pre Script. The Pre-Run/Post-Run Process Settings window appears.

  3. Go to Pre-Run iScript tab and enable the Post-Run Process option.
  4. Select sub-option Internal Script in Select process from option.
  5. Select OK.
  6. Go to Post-Run iScript tab in the same window and select Insert Sample Code.

  7. Select Yes to confirm the replacement of existing code.
  8. Select and open the Post-Run-SendMail script file from samples folder.

  9. Change the following email settings according to your Mail Server.

  10. Schedule this process and save the file. After the scheduled file runs successfully, it will automatically send an e-mail to the desired recipient (as per the details in script settings).

Multiple Table Extraction through Connected Process

Process Runner DB can extract multiple tables through chained processes. For example, let's look at the connected process for up to 3 tables (MARA, MARC and LFA1).

Note: You need to have legit authorizations for the target table in SAP for successful extraction.

  1. Start Process Runner DB and select File > New Process to launch New Process window.
  2. Select Data Extractor module and enter MARA in Table/View Name and select OK.
  3. Similarly create Data Extractor Process file for MARC (MARC.ite) and LFA1 (LFA1.ite).

    Now, let's connect all 3 in a chain (MARA> MARC> LFA1) i.e. MARA will run first, followed by MARC and then LFA1. 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.

  4. Open MARC.ite and select Process Connection option from Home > View.
  5. In the Process Connection section, select the folder browse button.

  6. Navigate and select the file, LFA1.ite. The Process Connection information appears at the left pane in tree view.

  7. Save this process file in desired location and exit.
  8. Open MARA.ite and connect MARC.ite (which is already connected to LFA1) and select save.
  9. Select Run. Notice that MARA.ite will run first, followed by MARC.ite and then LFA1.ite.

You can connect multiple tables in the same procedure. You can schedule the file in Process Runner DB using the Schedule option.

Was this article helpful?

We're sorry to hear that.