In Process Runner, ‘Data filter ‘option provides a unique way to classify and download selected pattern of Data from SAP System.
There are three different data filtering options in Process Runner in Home menu:
1.Data Filter Builder
2.ABAP
3.From Excel Column
Let us consider an example to extract data using ‘Data Filter Builder’ option in Process Runner. In 'Home' tab, enable ‘Data Filter’ option by a single click on 'Data Filter' option and select ‘Data Filter Builder’ option in the drop-down menu.
Following dialog box will appear on the screen.
In the first column ‘Field Name’ drop-down menu, select ‘MATNR - Material Number’ as shown below.
In the fourth column ‘Compare Operator’ drop-down menu, select ‘Pattern’ option.
In the Fifth column ‘Source Type’ drop-down menu, select ‘Fix Single Value’ option.
In the Sixth column ‘Source Value’, enter 100* (string pattern to look for material numbers starting with 100). Add leading zeroes will automatically add leading zeroes if any required. Currently this works only for 2 fields - KUNR and MATNR.
Click on 'Run' button to download selected data from SAP system to external Excel file.
Click here to know the description of different Source Types available in Data filter builder. Click here, to know how to extract data from two tables using Data Filters. Click here , to know how to extract data from three tables using Data Filters. |
Next |
|