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:
- Create a new Process file for
MAKT
table. - On the Home tab, attach the Excel file containing the list of material numbers for which the description must be extracted.
- On the Mapper tab, map the fields that must be downloaded from SAP.
- On the Home tab, select Data Filter Builder option from the dropdown options. The Data Filter Builder window is displayed.
- Select Range in the Compare Operator column and select Fix Excel Range in the Source Type column.
- 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 ofwhere
condition in the text box, and select OK. - Add language filter if the description of specific language is required. In the example, description is filter for English language.
- Select OK. The changes to the data filter builder are saved.
- Select Run. The Excel file with the description of material number is displayed.