Skip to main content

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 DB 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: No changes in SAP are required to use ACS.

Let us understand the working of ACS by an example. We have a table with the list of material numbers extracted from MARC table from SAP and now we want to extract details for those material numbers using MARA table from SAP . Perform the following steps:

  1. Create a new process file for MARA table.

  2. Select the Home tab, select Use External Data Source option and choose the database connection from the dropdown list. Select the table in which the output is to be extracted.

  3. Select the Mapper tab and map the fields to be downloaded from SAP. Please note that the Total Field width of 512 characters per record is standard (feature/limitation) delivered in all standard SAP systems.

  4. Select the Home tab. Select Use Data Filters> Data Filter Builder option from the drop down menu. The Data Filter Builder window appears.

  5. Select Compare Operator as Range and Source Type as SELECT SQL. A pop up window appears.

  6. In the SELECT SQL pop up window, enter the select query statement . Select the Activate Automatic Condition Splitter (ACS) check-box to activate this feature. Provide the length of where condition in the text-box provided. Select OK.

  7. Back In the Data Filter Builder window, select OK.

  8. Execute the file by selecting the Run button in the toolbar.

After executing the file, it will populate the table with the details for the material numbers which were provided in the where condition.


Was this article helpful?

We're sorry to hear that.