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
Showing results for 
Search instead for 
Did you mean: 

How To Do Right Outer Join, Full Outer Join ?

SugguSandeep
Active Participant
0 Kudos

Hi SCN,

Is Full Outer Join Available in ABAP Programming ? If not how to perform it ?

I need clarity regarding joins In terms of ABAP Programming

Please help with Syntax for all available joins

Thanks.

3 REPLIES 3

Nitish2027
Participant
0 Kudos

Hi sandeepsuggu,

Yes, we can perform right outer join and full outer join in SAP ABAP. Famous SFLIGHT table example:

DATA(lv_city) = 'XYZ'.

SELECT c~carrname, p~connid
FROM scarr AS c 
RIGHT OUTER JOIN spfli AS p
ON p~carrid = c~carrid AND
   p~cityfrom = @lv_city
INTO TABLE @DATA(lt_flights).<br>
Check out the latest documentation for joins on SAP, here you will find more examples: Inner, Outer, and Cross Joins

Sandra_Rossi
Active Contributor
0 Kudos

See ABAP documentation SELECT, join for syntax and examples

  • [INNER] JOIN
  • LEFT [OUTER] JOIN
  • RIGHT [OUTER] JOIN
  • CROSS JOIN (= cartesian product of all lines of both tables)

([xxx] means xxx is optional)

There's no Full Outer Join (full join being left and right at the same time) as you can see.