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
Showing results for 
Search instead for 
Did you mean: 

outer join

Former Member
0 Kudos

what is the way to use multiple outer joins for slecting data from multiple tables , i want to use multiple outer joins, r/3 usually supports only 1 outer join of slect statement !

3 REPLIES 3

Former Member
0 Kudos

hi

instead of using multiple OUTER joins OR JOINS , better to user SELECT FOR ALL ENTRIES.

Former Member
0 Kudos

Better you can use FOR ALL ENTRIES rather than using any type of joins.

then loop the data and select accordingly

SELECT vbeln matnr zzarea posnr FROM vbap INTO TABLE it_vbap_area

FOR ALL ENTRIES IN it_lhemaster WHERE vbeln = it_lhemaster-quotation

AND matnr = it_lhemaster-buildno.

Former Member
0 Kudos

Reward points..