Full outer join in ABAP?

[Former Member]

My understanding is that in ABAP you only have INNER JOIN and LEFT OUTER JOINs available. If this is correct, what would be an efficient way to "emulate" a FULL OUTER JOIN (as defined here: http://en.wikipedia.org/wiki/Outer_join#full_outer_join )?

I would like to avoid looping through tables row by row for performance reasons. That said, my tables will hold less than 100,000 records each which is probably not too bad (worst case I would end up with 200,000 records).

Thanks,

Dennis

[Former Member]

My understanding is that in ABAP you only have INNER JOIN and LEFT OUTER JOINs available. If this is correct, what would be an efficient way to "emulate" a FULL OUTER JOIN (as defined here: http://en.wikipedia.org/wiki/Outer_join#full_outer_join )?

I would like to avoid looping through tables row by row for performance reasons. That said, my tables will hold less than 100,000 records each which is probably not too bad (worst case I would end up with 200,000 records).

Thanks,

Dennis

[Former Member]

I would use FOR ALL ENTRIES (bearing in mind that it does eliminate duplicates).

Rob

[Former Member]

Rob, thanks for your immediate reply.

I should have mentioned that I am an ABAP newbie. Can you elaborate a little bit more how this works? How would duplicate records be determined (by the table's key, I assume)? Can you give a quick code example?

Dennis

[Former Member]

Read:

<a href="/people/rob.burbank/blog/2007/03/19/joins-vs-for-all-entries--which-performs-better">JOINS vs. FOR ALL ENTRIES - Which Performs Better?</a>

I give some example of each there.

Rob