How To Do Right Outer Join, Full Outer Join ?

[sandeep_suggu]

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.

[sandeep_suggu]

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

[Nitish2027]

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

[FredericGirod]

Did you search ?

https://discoveringabap.com/2021/09/23/abap-7-4-and-beyond-7-open-sql-enhancements-part-2/

...

[Sandra_Rossi]

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.