Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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!
Hi Ferran!
I have the same problem. Did you fine a solution?
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
Hi,
You are using the 2LIS_13_VDHDR in full mode , you already filled the setup tables??