Skip to Content
avatar image
Former Member

FULL OUTER JOIN with ABAP CDS

How can I implement a FULL OUTER JOIN in ABAP CDS ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 22, 2017 at 11:45 AM

    Have you tried UNION ?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2017 at 03:20 PM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for the suggestion.

      While a CROSS JOIN does all combinations of the LHS and RHS, a FULL OUTER JOIN is a UNION of LEFT OUTER and RIGHT OUTER JOINS. I decided to go with the later solution. May not be the best way to do it but I think this is something that one would expect out of CDS views in ABAP given that it is available in HANA.

      I can't think of a way to use a CROSS JOIN in lieu of a FULL OUTER JOIN.

      Just for the enlightenment of readers, here is a note on FULL OUTER JOIN available in HANA

      https://blogs.sap.com/2014/05/25/all-about-joins-using-sql-in-hana/