Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQ02 Infoset Right Join

Go to solution
Former Member

‎10-08-2020 9:28 AM

Hey everyone,

I want to have an outer join with two tables in an infoset.

I can join them and right click the connection to change to a Left Outer Join, but i need a Right Outer Join/Need to switch the two tables around.

Is this possible?

1 ACCEPTED SOLUTION

Go to solution
michael_piesche
Active Contributor

‎10-08-2020 10:03 AM

0 Kudos

A right outer join between tables A and B is the same as a left outer join between tables B and A.

So, yes, you need to switch the two tables around and use the left outer join (or short left join), because ABAP only knows inner joins and left outer joins.

Unfortunately, in my experience with infosets and quick queries, once the tables are inserted and saved, you are limited when trying to get rid of or rearranging them.
You will have to start from scratch again with a new infoset/quick view. (Copying also doesnt work, you still are limited with deleting or rearringing already placed tables)

So when you create your new infoset, start out with the main table (your 'left' table), the one that will contain all relevant records, and then add the table that doesnt contain all relevant records and join them with a left outer join.

5 REPLIES 5

Go to solution
michael_piesche
Active Contributor

‎10-08-2020 10:03 AM

0 Kudos

A right outer join between tables A and B is the same as a left outer join between tables B and A.

So, yes, you need to switch the two tables around and use the left outer join (or short left join), because ABAP only knows inner joins and left outer joins.

Unfortunately, in my experience with infosets and quick queries, once the tables are inserted and saved, you are limited when trying to get rid of or rearranging them.
You will have to start from scratch again with a new infoset/quick view. (Copying also doesnt work, you still are limited with deleting or rearringing already placed tables)

So when you create your new infoset, start out with the main table (your 'left' table), the one that will contain all relevant records, and then add the table that doesnt contain all relevant records and join them with a left outer join.

Go to solution
sdsunny372
Active Participant

‎10-08-2020 3:31 PM

0 Kudos

Hi Kevin,

Infoset doesn't allow right outer join.

It is allow left outer join ,If you you cant to use right outer functionality I belive you can switch table from right to left and apply left outer join.


Best regards,

Sagarkumar Darji | Stridely solutions

Go to solution
Former Member
In response to sdsunny372

‎10-12-2020 7:58 AM

0 Kudos

Hi sdsunny372 ,

but how can i switch the tables?

Regards, Kevin

Go to solution
sdsunny372
Active Participant
In response to sdsunny372

‎10-12-2020 8:42 AM

0 Kudos

Hi Kevin,

To change /switch table ,you need to remove 1 and B table from query and again insert B table as first table (Base table) and thn A . This way you previous A tabke be B and B table will be A.

Go to solution
michael_piesche
Active Contributor
In response to sdsunny372

‎10-12-2020 5:23 PM

0 Kudos
Kevin Holtkamp, please have a look at my answer:
  • You will have to start from scratch.
    (SQ02 doesnt let you delete or switch already placed and saved tables).
  • Insert table B first and then A and create a left join between B and A.
    This is the same as a right join between A and B.
    (You cant do a right join, because a right join has not been implemented in ABAP SQL).