Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member
Not what you were looking for? View more on this topic or Ask a question