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?