topic outer join in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832233#M921535 <HTML><HEAD></HEAD><BODY><P>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 !</P></BODY></HTML> Tue, 20 May 2008 06:49:22 GMT Former Member 2008-05-20T06:49:22Z outer join https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832233#M921535 <HTML><HEAD></HEAD><BODY><P>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 !</P></BODY></HTML> Tue, 20 May 2008 06:49:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832233#M921535 Former Member 2008-05-20T06:49:22Z Re: outer join https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832234#M921536 <HTML><HEAD></HEAD><BODY><P>hi </P><P> instead of using multiple OUTER joins OR JOINS , better to user SELECT FOR ALL ENTRIES.</P></BODY></HTML> Tue, 20 May 2008 06:52:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832234#M921536 Former Member 2008-05-20T06:52:21Z Re: outer join https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832235#M921537 <HTML><HEAD></HEAD><BODY><P>Better you can use FOR ALL ENTRIES rather than using any type of joins.</P><P>then loop the data and select accordingly</P><P></P><P> SELECT vbeln matnr zzarea posnr FROM vbap INTO TABLE it_vbap_area</P><P> FOR ALL ENTRIES IN it_lhemaster WHERE vbeln = it_lhemaster-quotation</P><P> AND matnr = it_lhemaster-buildno.</P></BODY></HTML> Tue, 20 May 2008 06:53:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832235#M921537 Former Member 2008-05-20T06:53:05Z Re: outer join https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832236#M921538 <HTML><HEAD></HEAD><BODY><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5182282"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5089584"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5300920"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5142713"></A></P><P></P><P>Reward points..</P></BODY></HTML> Tue, 20 May 2008 06:53:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/outer-join/m-p/3832236#M921538 Former Member 2008-05-20T06:53:54Z