Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ferranpuchol
Partner - Contributor
Partner - Contributor

SAP Extractor Connector: Where clause no filtering

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

5 Replies
Not applicable

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.

ferranpuchol
Partner - Contributor
Partner - Contributor
Author

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!

Not applicable

Hi Ferran!

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

Tomas_Sommergyll
Employee
Employee

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

german_avanzato
Creator
Creator

Hi,

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