How to work with different source types in Data Filter |
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: 1.Data Filter Builder 2.ABAP 3.From Excel Column
Click here to know more on Use Data Filters option.
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.
Description of Different Source Type: 1.Excel To SAP: This source type will extract the data for the source value provided in Data Filter Builder from iBook/External Excel. For example, here we consider the MARA table to extract details of material using ‘MATNR’ field. Suppose we have provided the source value as ‘A’ column then Process Runner will extract the data for that particular value from SAP.
2.Fix Single Value: This source type will tell Process Runner 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.
3.Excel Cell Value: This source type will tell Process Runner to place the value received from SAP during execution to given Excel cell as source value in Data Filter Builder. For example, we entered source value as ‘A5’ from iBook/External Excel. Now when you execute the process file, Process Runner will extract the data from SAP for that particular cell given in Data Filter Builder as source value.
4.Fix Multiple Values: This source type will tell Process Runner to extract the data for the multiple values provided in ‘Fix Multiple Value’ popup as source value in Data Filter Builder during execution. 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 will extract the data from SAP for those values entered in “Fix Multiple Values” as source value in Data Filter Builder.
5.Excel Row Range: This source type will extract the data for the Excel range provided in Data Filter Builder. For example, let provide the Excel Range as ‘A’ to ‘B’. Now when you execute the process file, Process Runner will extract the data from SAP for the values given in column ‘A’ and ‘B’.
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. Click here to know more about ACS.
Skip Blank value when enabled skips the row in which the field(MATNR) is blank.
6.Fix Excel Range: This source type will extract the data for the Excel range provided in Data Filter Builder. For example, let provide the Excel Range as ‘A2’ to ‘A6’. Now when you execute the process file, Process Runner will extract the data from SAP for the values given in the range ‘A2’ to ‘A6’.
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.Click here to know more about ACS.
Skip Blank value when enabled skips the row in which the field(MATNR) is blank.
7.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 = 'NEU1' OR kschl = 'NEU2') AND spras = 'E' AND vstat = '1'
8.System Value: This source type will tell Process Runner to use the system value selected in Data Filter Builder during extraction. System values contain control information for the process file to be executed.
For example, we have considered MARA table to extract the data for material numbers and require only data which are created on current date. Set 'Current System Date' system value in data filter builder from list and when we execute the process file, Process Runner will extract the data from SAP for the materials created on current date.
Run time behavior:
Next: |