Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Abhi_719
Contributor
Contributor

Selection Criteria for Replicate tasks on SAP Extractors

We have a Replicate job built over an SAP ECC Extractor. I am trying to figure out if there is a way to pass selection criteria to the task during execution? On SAP side users are presented with fields for selection when executing the extractor in RSA3. However we don't see such an option on Replicate task. We need to run this task on a specified input values. Where do we specify the selection criteria for Replicate tasks over SAP extractors?

Labels (2)
1 Solution

Accepted Solutions
Hordy_Beauzile
Support
Support

Hello Team,

Go into the SAP Application where you define the Extractor using /n/qtqvc/extrep 

 

Hordy_Beauzile_0-1661265319261.png

 

Click on the Set Filter Criteria and click New Entries 

Hordy_Beauzile_1-1661265342706.png

 

Once you are here you set the Datasource and the Filed you are adding the filter too 

 

Best,

Hordy

View solution in original post

5 Replies
SachinB
Support
Support

Hello @Abhi_719 ,

If I understood it correctly, You are looking for an option where you can pass the selection criteria through a specific table in order to get a specific result ? If yes then we do have There is an option to add a "Fullload Passthru Filter" - with this option everything you write in the filter is added following the WHERE clause of the SELECT statement of the full load, and the entire statement is passed directly to the source DB, so the statement must be in the source db sql syntax.
To add this, HOLD the Ctrl key, while you open "Table Settings" and keep it hold while you click on Filter.

Refer to the below link for more information.

https://community.qlik.com/t5/Knowledge/Filter-for-last-90-days-of-data-in-Qlik-Replicate/ta-p/18807...

Regards,

Sachin B

Abhi_719
Contributor
Contributor
Author

Hello, 

Thanks for your response but it is not working for us. I am guessing this would work with a regular RDBMS source but in our case we are sourcing from SAP ECC Extractors which is accessed via RFC calls. We tried a bunch of filters in ABAP syntax but no good.

lyka
Support
Support

Hello,

How about creating the filters on the extractor itself?

 

From Replicate May 2021 Patch Release 07, the SAP Extractors launch pad offers enhanced Data Extract (filtering) capabilities such as multiple fields and values. The new options allow you to easily create and update filters or use the Adjust Extract Filter option to directly maintain values in the table.

 

Thanks

Lyka

Abhi_719
Contributor
Contributor
Author

Thank you for your response. Is there any documentation or user guide around this? We only see upto activating Extractors in user guides but no examples of using Data Extract.

Hordy_Beauzile
Support
Support

Hello Team,

Go into the SAP Application where you define the Extractor using /n/qtqvc/extrep 

 

Hordy_Beauzile_0-1661265319261.png

 

Click on the Set Filter Criteria and click New Entries 

Hordy_Beauzile_1-1661265342706.png

 

Once you are here you set the Datasource and the Filed you are adding the filter too 

 

Best,

Hordy