topic Re: left outer join for internal tables in Application Development and Automation Discussions

left outer join for internal tables

Former Member — Wed, 27 Feb 2013 05:32:08 GMT

Hi guys,

First of all thanks for your support for my previous posts.

here,i need to join two internal tables.(i.e i am retriving the data from the archivied object,and after retriving it in to an internal table, i need to display it according to the condition in the select stmt.In select stmt they first inner join vbrp and vbrk and left outer join to the likps table)the same i need to do using internal table(archivied table) .

Re: left outer join for internal tables

adam_krawczyk1 — Thu, 28 Feb 2013 11:26:11 GMT

Hi Krishna,

I was going to write some code example, but then I try to first search in SCN forum.

Here is the link with good example for left inner join, look at the correct answer. You can adjust it for own needs. It is just important to set table that you considerer as "left" in the top in the loop.

http://scn.sap.com/thread/901169

Regards,

Adam