Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Link EKKO, EKPO, EIKP, EIPO in SQVI - missing results

Former Member

‎10-16-2015 8:01 PM

0 Kudos

Hello everybody,

I have created a join with EKKO, EKPO, EIKP and EIPO and some other tables. I would like to show the foreign trade relevant data (Customs code, Country of origin) of different POs but I also want to Display those POs in the result that do not have any import data. Is there any chance to have both as a result POs with the requested data and the ones without?

The link is as follows:

coming from RSEG, EBELN = EKKO, EBELN

EKKO, EBELN = EKPO, EBELN

EKKO, EXNUM = EIKP, EXNUM

EIKP, EXNUM = EIPO, EXNUM

The query itself works but I would like to add the missing POs.

Thank you in advance.

Regards,

Julian

1 REPLY 1

Florian
Active Contributor

‎10-17-2015 8:05 AM

0 Kudos

Hi Julian.

Depends on the release you could archive it with CDS.

Otherwise you need to build an outer join to add the tables, which are not showing up for every po.

Anyway, what is the problem with two select-statements? The performance might be not more bad than it is with one...

~Florian