outer join

[Former Member]

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 !

[Former Member]

hi

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

[Former Member]

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]

Reward points..