Link EKKO, EKPO, EIKP, EIPO in SQVI - missing results
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.