topic Re: SAP Extractor Connector: Where clause doesn't work in QlikView

SAP Extractor Connector: Where clause doesn't work

Mon, 26 Jan 2026 21:26:37 GMT

Hi everyone,

i'm trying to add a where clause into sap extraction but it is not working.

[ZBI_NEW_ZTPRC_VP]:

LOAD

[AKTNR_TVK] as [AKTNR_TVK.Номер акции (YMMDD)],

[AUFNR_TVP] as [AUFNR_TVP.Ссылочный номер заказа],

[BISMT_TVP] as [BISMT_TVP.Номер материала внешнего магазина],

(... other fields)

;

SQL EXTRACTOR ZBI_NEW_ZTPRC_VP

TFRMETHOD T // tRFC transfer method

UPDMODE F // full extractor

//UPDMODE C // initial extraction, to be followed by delta extractions

//UPDMODE D // delta extraction

//INITRNR <NR> // Resend extraction

//IDOC <NR> // Resend single IDoc

EXTRLANGUAGE E

LOGSYS QTQVCEXTR1

WHERE

AUFNR_TVP I EQ 098341769064

;

Please take into account additional comments:

1) I tried it with and without single quotes, any variants doesn't work either.

2) The field AUFNR_TVP in SAP extractor is marked for selection.

3) When I try to test extractor in SAP ERP using RSA3 and with applying filter by field AUFNR_TVP - it works.

4) The SAP extractor is based on view.

Please let me know if you have any solution regarding this problem.

Re: SAP Extractor Connector: Where clause doesn't work

Tomas_Sommergyll — Wed, 27 May 2015 07:31:37 GMT

Hi Ivan,

Which Connector version do you have?

Can you attach the connector log file (QvSAPExtr_...txt) from:

C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log

Thanks,

Tomas

Re: SAP Extractor Connector: Where clause doesn't work

Thu, 28 May 2015 07:40:58 GMT

Hi Tomas,

thank you for your reply. I've just checked.

The cause of this problem was in stucked JOB.

After I removed this Job in /QTQVC/STATUS table the problem was resolved.

Re: SAP Extractor Connector: Where clause doesn't work

Tomas_Sommergyll — Thu, 28 May 2015 10:48:18 GMT

Hi Ivan,

Please upgrade to the latest version of the Qlik Extractor Connector for SAP.

The issue with WHERE clause (e.g. WHERE VKORG I LT "1001") is fixed in version 6.00 IR.

Thanks,

Tomas