Automatic Condition Splitter

This topic describes how to use the automatic condition splitter functionality for a Data Extractor Process file with a large where condition that might result in an issue if the length of the where condition exceeds the limit specified by the SAP database. You can use the Automatic Condition Splitter (ACS) functionality of Process Runner to split the where condition internally to ensure that the length is within the specified limit. ACS is designed especially to work with the SAP standard delivered function modules. The number of calls made to SAP are the number of slices made by ACS of the where condition. Note that no changes in SAP are required to use ACS.

Let us consider an Excel file with a list of 5000 material numbers extracted from the MARC table. To extract the description from the MAKT table for each material number, perform the following steps:

  1. Create a new Process file for MAKT table.
  2. On the Home tab, attach the Excel file containing the list of material numbers for which the description must be extracted.
  3. On the Mapper tab, map the fields that must be downloaded from SAP.
  4. On the Home tab, select Data Filter Builder option from the dropdown options. The Data Filter Builder window is displayed.
  5. Select Range in the Compare Operator column and select Fix Excel Range in the Source Type column.
  6. Enter the Excel cell range from which the data for the where condition must be extracted and sent to SAP, select the Activate Automatic Condition Splitter (ACS) option, enter the length of where condition in the text box, and select OK.
  7. Add language filter if the description of specific language is required. In the example, description is filter for English language.
  8. Select OK. The changes to the data filter builder are saved.
  9. Select Run. The Excel file with the description of material number is displayed.