Let us consider an example to extract data using ‘Data Filter Builder’ option in Process Runner.
In Home tab, enable ‘Use Data Filters’ 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 third column ‘Compare Operator’ drop-down menu, select ‘Pattern’ option.
In the fourth column ‘Source Type’ drop-down menu, select ‘Fix Single Value’ option.
In the fifth 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 iBook as shown below:
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.
|