topic Re: How To Do Right Outer Join, Full Outer Join ? in Application Development and Automation Discussions

How To Do Right Outer Join, Full Outer Join ?

sandeep_suggu — Tue, 30 Aug 2022 06:17:23 GMT

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.

Re: How To Do Right Outer Join, Full Outer Join ?

Nitish2027 — Tue, 30 Aug 2022 06:39:42 GMT

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

Re: How To Do Right Outer Join, Full Outer Join ?

FredericGirod — Tue, 30 Aug 2022 06:42:03 GMT

Did you search ?

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

...

Re: How To Do Right Outer Join, Full Outer Join ?

Sandra_Rossi — Tue, 30 Aug 2022 12:39:43 GMT

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.