topic Re: SAP Extractor Connector: Where clause no filtering in QlikView

SAP Extractor Connector: Where clause no filtering

ferranpuchol — 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. I'm always downloading all the table without filtering by my where clause.

[2LIS_13_VDHDR]:

LOAD

[ANZFK] as [ANZFK.No.of billing docs],

[BUKRS] as [BUKRS.Company Code],

[BZIRK] as [BZIRK.Sales district],

[ERDAT] as [ERDAT.Date on Which Record Was Created],

[FKART] as [FKART.Billing Type],

[FKDAT] as [FKDAT.Billing date for billing index and printout],

// [FKSTO] as [FKSTO.Billing document is cancelled],

[FKTYP] as [FKTYP.Billing category],

[HWAER] as [HWAER.Local Currency],

[KDGRP] as [KDGRP.Customer group],

// [KNUMV] as [KNUMV.Number of the document condition],

[KUNAG] as [KUNAG.Sold-to party],

[KUNRG] as [KUNRG.Payer],

[KURRF] as [KURRF.Exchange rate for FI postings],

[KURST] as [KURST.Exchange Rate Type],

[PERIV] as [PERIV.Fiscal Year Variant],

[PVRTNR] as [PVRTNR.Sales employee],

[ROCANCEL] as [ROCANCEL.Indicator: Cancel Data Record],

[STWAE] as [STWAE.Statistics currency],

[VBELN] as [VBELN.Sales and Distribution Document Number],

[VBTYP] as [VBTYP.SD document category],

[VKORG] as [VKORG.Sales Organization],

[VTWEG] as [VTWEG.Distribution Channel],

[WAERK] as [WAERK.SD Document Currency];

SQL EXTRACTOR 2LIS_13_VDHDR

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

KUNRG I EQ 'D128125';

I tried it without single quotes, but it doesn't work either.

Can someone help me please?

THX!

Ferran

Re: SAP Extractor Connector: Where clause no filtering

Tue, 10 Feb 2015 12:18:55 GMT

Hi, Just a thought, only specific fields are selectable in BW datasources, it depends on the configuration for that datasource. Is KUNRG selectable when you use the SAP transaction RSA3? I'm guessing that only selectable fields can be used in the where clause. In our system only BUKRS, Company Code and VKORG, Sales Organisation are selectable.

Re: SAP Extractor Connector: Where clause no filtering

ferranpuchol — Tue, 10 Feb 2015 12:32:50 GMT

Thanks for your answer.

KUNRG is no selectable at RSA3. I tried what you said:

[2LIS_13_VDHDR]:

LOAD

[ANZFK] as [ANZFK.No.of billing docs],

[BUKRS] as [BUKRS.Company Code],

[BZIRK] as [BZIRK.Sales district],

[ERDAT] as [ERDAT.Date on Which Record Was Created],

[FKART] as [FKART.Billing Type],

[FKDAT] as [FKDAT.Billing date for billing index and printout],

// [FKSTO] as [FKSTO.Billing document is cancelled],

[FKTYP] as [FKTYP.Billing category],

[HWAER] as [HWAER.Local Currency],

[KDGRP] as [KDGRP.Customer group],

// [KNUMV] as [KNUMV.Number of the document condition],

[KUNAG] as [KUNAG.Sold-to party],

[KUNRG] as [KUNRG.Payer],

[KURRF] as [KURRF.Exchange rate for FI postings],

[KURST] as [KURST.Exchange Rate Type],

[PERIV] as [PERIV.Fiscal Year Variant],

[PVRTNR] as [PVRTNR.Sales employee],

[ROCANCEL] as [ROCANCEL.Indicator: Cancel Data Record],

[STWAE] as [STWAE.Statistics currency],

[VBELN] as [VBELN.Sales and Distribution Document Number],

[VBTYP] as [VBTYP.SD document category],

[VKORG] as [VKORG.Sales Organization],

[VTWEG] as [VTWEG.Distribution Channel],

[WAERK] as [WAERK.SD Document Currency];

SQL EXTRACTOR 2LIS_13_VDHDR

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 VKORG I EQ 1002;

It should had returned 0 values due to VKORG is 1000 at all records, but it returned all the data without filtering.

Any idea what's happening?

Thanks!

Re: SAP Extractor Connector: Where clause no filtering

Tue, 26 May 2015 06:29:02 GMT

Hi Ferran!

I have the same problem. Did you fine a solution?

Re: SAP Extractor Connector: Where clause no filtering

Tomas_Sommergyll — Thu, 28 May 2015 10:47:23 GMT

Hi,

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

Re: SAP Extractor Connector: Where clause no filtering

german_avanzato — Mon, 01 Jun 2015 15:30:51 GMT

Hi,

You are using the 2LIS_13_VDHDR in full mode , you already filled the setup tables??