SAP Query multiple left outer join

[Former Member]

Hello.

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?

[former_member195427 · Accepted solution]

Hi Zu,

There are documents posted by Mr. which give all information about it.Please see these posts:

hope it helps.

Br

Saurabh

[Former Member · Accepted solution]

Very useful information about Query. But no related articles to my problem.

[sanjeevc]

Hi,

Yes it is possible to joint various tables without help of abap. when you execute sqvi transaction the top of screen you got the option basis layout/layout mode click on then check data source here you have to select table join option the it will ask to you to more table put table one by one and save the query with selection in put and output parameter.

still have any issue please let us know with screenshot.

Regards,
Sanjeev