Using Variants for Long Text Query

Scenario

Using Variants to limit data extracted via Syniti Replicate on BOAQ_READ_TEXT or BS4Q_READ_TEXT

You are extracting data from SAP using Syniti Replicate, and you want to limit the extraction of long texts. However, while simple filters can be applied directly in Syniti Replicate, that is, /BOA/READ_TEXT-OBJECT = ‘EKKO'), ranges are not supported by the tool. This creates a challenge when you need to extract long text data.

Solution

To address this, you will need to specify the ranges within variants on the SAP system. These variants can then be passed as hidden parameters to the replication process using the Source Filter Where Clause in Syniti Replicate. This method ensures that the long text data is filtered according to the specified ranges while still being processed efficiently by Syniti Replicate.

Complete the following steps described at high-level to set up variants on the SAP system:

1. In the SAP system, select the BOAQ_READ_TEXT query and open the SQ01 transaction to define the variant.

   

2. Enter the filters for the variant that you want to use to extract long text in Syniti Replicate.

3. Click the button next to the available fields to specify individual values to include Ranges, Individual Values to Exclude, and Ranges to Exclude.

4. Click Save and provide the variant with a name and an optional description.

   

   

5. Run your SAP Query with the variant you have defined in SAP to confirm that it returns the data as expected.

   

6. After saving the variant, you can test the extract by selecting the BOAQ_READ_TEXT or BS4Q_READ_TEXT table under the SAP connection in Syniti Replicate and choosing Open Table.

7. On the SQL Query page, add the where clause with the variant you defined earlier.

   

8. Modify the replication created specifically for the variant-based long text extract and add the Source Filter Where clause on the Refresh Properties page as you have defined in Step 7, that is, where Variant = ''.