Qlik Community

QlikView Connector for SAP

Discussion Board for collaboration related to the QlikView Connector for SAP.

p_sauren
New Contributor II

Qlik Sense SAP Connector - Where Exists

Dear All,

I have some trouble with loading only relevant data with the SAP Connector; is it possible to work with a "where exists" statement? Could anyone provide me with an example of it?

E.g. I'm loading one table LIKP where LFDAT >= '20170101' and I would like to load only those details from LIPS where VBELN already exists..

Thanks and regards,

Philipp

3 Replies

Re: Qlik Sense SAP Connector - Where Exists

Off the top of my head, you can try using a nested select. Something like:

SELECT * FROM LIPS WHERE VBELN IN (SELECT VBELN FROM LIKP WHERE LFDAT >= '20170101');

Best,

Peter

Employee
Employee

Re: Qlik Sense SAP Connector - Where Exists

Hi Philipp,


Syntax:

... [NOT] EXISTS subquery ...


Effect:

This expression is true if the resulting set of the subquery contains at least one line (not).


Example:

SELECT VBAP~VBELN VBAP~POSNR VBAP~MATNR VBAK~VKORG

VBAK~VTWEG FROM VBAP INNER JOIN VBAK ON VBAP~VBELN

EQ VBAK~VBELN WHERE EXISTS ( SELECT VBELN FROM VBUK

WHERE VBELN EQ VBAP~VBELN )

Regards,

Hakan

p_sauren
New Contributor II

Re: Qlik Sense SAP Connector - Where Exists

Thanks! Works well; didnt think about the nested select..

Philipp

Community Browser