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: 

'Full Outer Join' in ABAP CDS View

Go to solution
sPatil
Participant

‎04-09-2019 10:08 AM

0 Kudos

Hi,

I am observing that, Eclipse editor is not allowing me to use 'Full Outer Join' in ABAP CDS view. It has only options like association, inner join, join, left/right outer join. PFB image.

Is there any alternative for 'Full Outer Join' so that same functionality can be achieved? Or is it possible to use 'Full Outer Join' in ABAP CDS Views?

Preview file
51 KB
1 ACCEPTED SOLUTION

Go to solution
pfefferf
Active Contributor

‎04-09-2019 12:11 PM

A full outer join is not supported so far in ABAP CDS Views. But what is a full outer join, the combination of the results of a left outer join and a right outer join without duplicates. So you can do a left outer join and a right outer join and combine the results using a union (which removes the duplicates).

1 REPLY 1

Go to solution
pfefferf
Active Contributor

‎04-09-2019 12:11 PM

A full outer join is not supported so far in ABAP CDS Views. But what is a full outer join, the combination of the results of a left outer join and a right outer join without duplicates. So you can do a left outer join and a right outer join and combine the results using a union (which removes the duplicates).