05-20-2008 7:49 AM
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 !
05-20-2008 7:52 AM
hi
instead of using multiple OUTER joins OR JOINS , better to user SELECT FOR ALL ENTRIES.
05-20-2008 7:53 AM
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.
05-20-2008 7:53 AM