Hello everyone, I have some problem when I try to use WHERE EXISTS instead of INNER JOIN.

I want to complete the elective course Data Integration Case Study - Accounts Payable inside Get Data into the EMS, but I have some problem at the step Transform - Add an Activity: Enter Invoice in SAP.

No problems when I write the code with the INNER JOIN, but I'm not able to run the code whit clause WHERE EXISTS. In attachment you can find both codes. The "WHERE EXISTS" code returns the following error:

Execution error: ERROR: Missing FROM-clause entry for table "BKPF".

Where I'm wrong? I tried to follow the syntax reported in the Get Data into the EMS course but I'm in a dead end.

Thanks in advance.

Page 1 / 1

The problem is in this line

you are referring to BKPF, but BKPF is inside a subquery (the SELECT inside the where exits), so you can not refer it.

As a thumbrule, WHERE EXISTS is only to select a subset of records based on a relation to another table.

If, as in this case, you need to retrieve any column from the second table, then you need JOIN

HTH

Thanks a lot, Guillermo.

So, if I understand well, in this case, is better to use the JOIN condition.

Thanks a lot, Guillermo.

So, if I understand well, in this case, is better to use the JOIN condition.

Yes

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN