topic Re: Qlik Sense SAP Connector - Where Exists in QlikView

Qlik Sense SAP Connector - Where Exists

Anonymous — Mon, 26 Jan 2026 21:26:37 GMT

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

Re: Qlik Sense SAP Connector - Where Exists

Peter_Cammaert — Mon, 20 Nov 2017 13:09:12 GMT

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

Re: Qlik Sense SAP Connector - Where Exists

Hakan_Ronningberg — Mon, 20 Nov 2017 13:15:16 GMT

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

Re: Qlik Sense SAP Connector - Where Exists

Anonymous — Mon, 20 Nov 2017 13:18:16 GMT

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

Philipp