topic Re: Selection Criteria for Replicate tasks on SAP Extractors in Qlik Replicate

Selection Criteria for Replicate tasks on SAP Extractors

Abhi_719 — Tue, 16 Aug 2022 01:49:38 GMT

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?

Re: Selection Criteria for Replicate tasks on SAP Extractors

SachinB — Tue, 16 Aug 2022 02:55:10 GMT

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/1880761

Regards,

Sachin B

Re: Selection Criteria for Replicate tasks on SAP Extractors

Abhi_719 — Mon, 22 Aug 2022 18:30:14 GMT

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.

Re: Selection Criteria for Replicate tasks on SAP Extractors

lyka — Mon, 22 Aug 2022 18:57:06 GMT

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

Re: Selection Criteria for Replicate tasks on SAP Extractors

Abhi_719 — Mon, 22 Aug 2022 19:22:12 GMT

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.

Re: Selection Criteria for Replicate tasks on SAP Extractors

Hordy_Beauzile — Tue, 23 Aug 2022 14:36:03 GMT

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