Skip to Content
author's profile photo Former Member
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    Posted on Jan 22, 2015 at 06:11 PM

    Hi Zu,

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

    Alias Tables in Infosets and QuickViews

    10 Useful Tips on Infoset Queries

    ALV Report on Catalog Profile and Catalogs &amp; Codes - (Infoset way)

    hope it helps.



    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 23, 2015 at 07:51 AM


    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.


    Add comment
    10|10000 characters needed characters exceeded