Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

left outer join for internal tables

Former Member

‎02-27-2013 5:32 AM

0 Kudos

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) .

1 REPLY 1

adam_krawczyk1
Contributor

‎02-28-2013 11:26 AM

0 Kudos

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