Data Filter

This section describes how to configure the data filter settings for Data Extractor Process files.

The Data Filter option is available only for Data Extractor technology.

To configure the data filter options

  1. Open the Data Extractor Process file that you want to update, select Home tab > Data Filter in the Settings section.
  2. To filter the data at field level without writing any ABAP code, select Data Filter Builder. The Data Filter Builder and Join Condition (<NameOfTables>) window is displayed. Perform the following steps:
    1. In Field Name, select the name of the field that must be extracted.
    2. Update the operator in the Compare Operator column and values in the other columns, such as Dynamic Skip and Dynamic Formula.
    3. Update the Source Value to indicate that the material numbers starting with the specified source value or string pattern must be extracted. If the Source Type is Excel to SAP, you can also select the Source Value from the dropdown options, which are the Excel column headers. For information about how to work with the different source types available in Data filter builder, see Work with Different Source Types.
    4. To add, delete, go to next, or go to previous rows, use the options in the lower-left of the window.
    5. Select OK. The changes are saved.
  3. To extract data through custom ABAP code, select ABAP. The ABAP window is displayed. Perform the following steps:
    1. Enter the custom ABAP program.
    2. Select OK. The changes are saved.
  4. To filter data using the ABAP query that is mentioned in the cell or column of the external Excel file, select From Excel Column. The From Excel Column window is displayed. Perform the following steps:
    1. Enter the address of Excel column or cell name where the ABAP query is located in the external Excel file.
    2. Select OK. The changes are saved.
  5. Save the Process file and select Run. The Excel file is displayed with the data extracted.

Review the installed sample BSEG-Accounting Document extract for listed accounts only.ite in the Data Extractor folder for an example.