Work with Different Source Types

This topic describes how to use the different source types in the Data Filter Builder and Join Condition window to filter and download selected pattern of data from an SAP System.

To configure the source type in the data filter builder window

  1. Open the Data Extractor Process file that you want to update, select Home tab > Data Filter in the Settings section. The Data Filter Builder and Join Condition (<NameOfTables>) window is displayed.
  2. In Field Name, select the name of the field that must be extracted.
  3. In the Source Value column, select one of the following options:
    • Excel To SAP: Extracts the data for the Source Value column from the external Excel file. For example, consider the MARA table to extract the material details using the MATNR field. If you enter the source value as A1, then Process Runner extracts the data for that particular value from SAP.
    • Fix Single Value: Extracts the data for the Source Value column you entered. or example, consider the MARA table to extract the data for material number, enter the fixed value as 100-100, and run the Process file. Process Runner extracts the data from SAP for that particular material number.
    • System Value: Uses the system value selected in the System Values window. System values contain control information for the Process file that must be run. For example, consider MARA table to extract the data for material numbers that are created on the current date. Set Current System Date system value from the list and run the Process file. Process Runner extracts the data from SAP for the materials created on the current date.
    • Excel Cell Value: Places the value received from SAP during the run into the Excel cell specified as the source value in the Data Filter Builder window. For example, if you enter source value as A50 and run the Process file, Process Runner extracts the data from SAP for this specific cell.
    • Excel Row Range: Extracts the data for the Excel range entered in the Excel Range window. For example, enter the Excel Range as A to B and run the Process file. Process Runner extracts the data from SAP for the values given in columns A and B.

      If ACS is enabled, it handles the length of the where condition by splitting the where condition internally and keeping the length within the specified limit. The number of calls made to SAP are the number of slices made by ACS of the where condition. For information about ACS, see Automatic Condition Splitter.

      If you select Skip Blank value, Process Runner skips the row in which the field MATNR is blank.

    • Fix Excel Range: Extracts the data for the Excel range provided in the Data Filter Builder window. For example, enter the Excel Range as A2 to A6 and run the Process file. Process Runner extracts the data from SAP for the values given in the range A2 to A6.

      If ACS is enabled, it handles the length of the where condition by splitting the where condition internally and keeping the length within the specified limit. The number of calls made to SAP are the number of slices made by ACS of the where condition. For information about ACS, see Automatic Condition Splitter.

      If you select Skip Blank value, Process Runner skips the row in which the field MATNR is blank.

    • Start Bracket and End Bracket: Caters to the filtering conditions that simulate the where clause in SAP ABAP select statements with nested OR 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'

  4. Select OK. The changes are saved.