Where Conditions

Above we saw a simple example of Data Extractor. But Process Runner goes far beyond that. It provides “Where Conditions” to filter your Data Extractions according to your needs.

There are 3 types Where Conditions that Process Runner provides

•     Data Filter Builder

•     ABAP

•     From Excel Column

As for example if we want to extract table data from MARA for only those materials which start from 100, we can use Data Filter as follows:

1.   Select “Use where condition” option in Home tab.

2.   In the drop down, select Data Filter.

3.   A new window of Data Filter Builder will open as shown below.

4.   In the Filed Name drop down, select MATNR - Material Number to keep our where condition for Material number.

5.   In Compare operator, select Pattern.

6.   In Source type, select Fix Single Value.

7.   In Source Value, enter 100* (string pattern to look for material numbers starting with 100).

8.   Click on Run.

9.   You can see that Data extractor retrieved all the mapped data according to the Where condition pattern specified.

Go to

Tutorials Home

Transaction Tutorial | Online Video Tutorial of Transaction

BAPI Tutorial | Online Video Tutorial of BAPI

GUI Scripting Tutorial | Online Video Tutorial of GUI Scripting

Header - Detail (Multi line Transaction) | Online Video of Header Detail (Multi line Transaction)