Selection Criteria for Replicate tasks on SAP Extractors

[Abhi_719]

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?

[SachinB]

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]

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]

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]

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 · Accepted solution]

Hello Team,

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

Click on the Set Filter Criteria and click New Entries 

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

Best,

Hordy