In Process Runner DB, 'Data filter ‘option provides a unique way to classify and download selected pattern of Data from SAP System.
There are two different data filtering options in Process Runner DB:
1. Data Filter Builder
2. ABAP
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.
Click here to know more about 'Use single SELECT SQL for multiple fields' checkbox.
Description of Different Source Type:
1.Fix Single Value: This source type will tell Process Runner DB to use the ‘Map value’ provided in the source value in Data Filter Builder during extraction. For example, here we consider MARA table to extract the data for material number. Here we provided the fixed value as 100-100 in source value. Now when we execute the process file, Process Runner will extract the data from SAP for that particular material number.
2.Fix Multiple Values:This source type will tell Process Runner DB to extract the data for the multiple values provided in ‘Fix Multiple Value’ popup as source value in Data Filter Builder during execution. If source type 'Fix Multiple Values' is selected, it will automatically change the compare operator to 'Range' .
For example, consider the MARA table to extract the data for material numbers. Suppose we provide the multiple values as ‘100-100’, ‘100-200’, ‘100-300’. Now when you execute the process file, Process Runner DB will extract the data from SAP for those values entered in “Fix Multiple Values” as source value in Data Filter Builder.
3.Select SQL: This source type allows to enter the select statement for the data to be retrieved from the table. In the Data Filter Builder window, select Compare Operator as “Range” and Source Type as “SELECT SQL”.ACS if enabled will handle the length of where condition by splitting the where condition internally keeping the length within the specified limit. The number of calls made to SAP will be number of slices made by ACS of the where condition.
4.Start Bracket and End Bracket: This source type mainly caters to the complex filtering conditions which simulate 'Where' clauses in SAP ABAP select statements with nested 'OR' /'AND'. For example, consider the following SELECT statement:
SELECT kschl FROM nast WHERE kappl = 'EF' AND ( kschl = 'NEU' OR kschl = 'NEUS') AND spras = 'D' AND vstat = '1'
Click here for more details regarding Data Filters .
Click here for details about how to use Data Filters to join two tables.
Next: