Skip to Content

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

SAP Query multiple left outer join


For the project we need to create reports with entries that are not linked to another tables. For ex. we need a report of all investment positions, wbs linked to them and assets.

Report should contain all the IM positions, even if they are not connected to wbs. Through sap query we've got situaiton that at first step when we connect table IMPR with IMZO with left outer join it works perfectly, when we add connection between IMZO and PRPS there only IM positions with WBS elements left in report.

I've tried to use Alias table like: IMPR <-loj IMZO -> IMZO2 (Alias) <-lojĀ  PRPS but no use.

Is there any way we can do such report without help of ABAP?


Helpful Answer

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