topic Re: Join Condition in Application Development and Automation Discussions

topic Re: Join Condition in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391141#M531755 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>What for you are using the VAPMA table?</P><P>remove it and take MATNR and WERKS from VBAP table and AUDAT from VBAK table</P><P>and see the sequence of the table fields</P><P>and tables like VBAK, VBAP,VBEP, VBUK,VBUP, KNA1</P><UL><LI level="1" type="ul"><P>select </P></LI><LI level="1" type="ul"><P>vbak~audat</P></LI><LI level="1" type="ul"><P> vbap~matnr</P></LI><LI level="1" type="ul"><P>vbap~werks</P></LI><LI level="1" type="ul"><P>vbap~kzwi2</P></LI><UL><LI level="2" type="ul"><P>vbep~wmeng</P></LI></UL><LI level="1" type="ul"><P>vbep~cmeng "rounded quantity</P></LI><LI level="1" type="ul"><P>vbep~vrkme</P></LI><LI level="1" type="ul"><P>vbep~meins</P></LI><LI level="1" type="ul"><P>vbep~vbeln</P></LI><LI level="1" type="ul"><P>vbep~posnr</P></LI><LI level="1" type="ul"><P>vbep~etenr</P></LI><LI level="1" type="ul"><P>kna1~name1</P></LI><LI level="1" type="ul"><P>into table it_orders</P></LI><LI level="1" type="ul"><P>from vbak join vbap</P></LI><LI level="1" type="ul"><P>on vbak<SUB>vbeln = vbap</SUB>vbeln</P></LI><LI level="1" type="ul"><P>join vbep</P></LI><LI level="1" type="ul"><P>on vbep<SUB>vbeln = vapma</SUB>vbeln</P></LI><LI level="1" type="ul"><P>and vbep<SUB>posnr = vapma</SUB>posnr</P></LI><LI level="1" type="ul"><P>join vbuk</P></LI><LI level="1" type="ul"><P>on vbuk<SUB>vbeln = vbak</SUB>vbeln</P></LI><LI level="1" type="ul"><P>join vbup</P></LI><LI level="1" type="ul"><P>on vbup<SUB>vbeln = vbap</SUB>vbeln</P></LI><LI level="1" type="ul"><P>and vbup<SUB>posnr = vbap</SUB>posnr</P></LI><LI level="1" type="ul"><P>join kna1</P></LI><LI level="1" type="ul"><P>on kna1<SUB>kunnr = vbak</SUB>kunnr</P></LI><LI level="1" type="ul"><P>for all entries in i_marc</P></LI><LI level="1" type="ul"><P>where vbap~matnr = i_marc-matnr</P></LI><LI level="1" type="ul"><P>and vbap~werks = i_marc-werks</P></LI><LI level="1" type="ul"><P>and vbak~auart in s_auart</P></LI><LI level="1" type="ul"><P>and ( vbak~lifsk = ' ' and</P></LI><LI level="1" type="ul"><P>vbep~lifsp = ' ' and</P></LI><LI level="1" type="ul"><P>and vbep~wmeng <> 0</P></LI><LI level="1" type="ul"><P>and vbep~edatu < sy-datum</P></LI><LI level="1" type="ul"><P>and vbup~lfgsa <> 'C'</P></LI><LI level="1" type="ul"><P>and vbup~absta <> 'C'</P></LI><LI level="1" type="ul"><P>and vbup~rfgsa <> 'C'</P></LI><LI level="1" type="ul"><P>and vbup~gbsta <> 'C'</P></LI><LI level="1" type="ul"><P>vbuk~cmgst not in ('B', 'C') ). </P></LI></UL><P></P><P>Reward points for useful Answers</P><P>Regards</P><P>Anji</P></BODY></HTML> Tue, 19 Jun 2007 12:35:34 GMT Former Member 2007-06-19T12:35:34Z Join Condition https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391138#M531752 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> I have one code , in that i used many JOIN Conditions.It degrades the performance. Can u plz send me a new code by splitting bellow code.</P><P></P><P></P><UL><LI level="1" type="ul"><P> select vapma~matnr</P></LI><LI level="1" type="ul"><P> vapma~werks</P></LI><UL><LI level="2" type="ul"><P> vbep~wmeng</P></LI></UL><LI level="1" type="ul"><P> vbep~cmeng "rounded quantity</P></LI><LI level="1" type="ul"><P> vbep~vrkme</P></LI><LI level="1" type="ul"><P> vbep~meins</P></LI><LI level="1" type="ul"><P> vbep~vbeln</P></LI><LI level="1" type="ul"><P> vbep~posnr</P></LI><LI level="1" type="ul"><P> vbep~etenr</P></LI><LI level="1" type="ul"><P> vapma~audat</P></LI><LI level="1" type="ul"><P> vbap~kzwi2</P></LI><LI level="1" type="ul"><P> kna1~name1</P></LI><LI level="1" type="ul"><P> into table it_orders</P></LI><LI level="1" type="ul"><P> from vapma</P></LI><LI level="1" type="ul"><P> join vbak</P></LI><LI level="1" type="ul"><P> on vbak<SUB>vbeln = vapma</SUB>vbeln</P></LI><LI level="1" type="ul"><P> join vbuk</P></LI><LI level="1" type="ul"><P> on vbuk<SUB>vbeln = vapma</SUB>vbeln</P></LI><LI level="1" type="ul"><P> join vbup</P></LI><LI level="1" type="ul"><P> on vbup<SUB>vbeln = vapma</SUB>vbeln</P></LI><LI level="1" type="ul"><P> and vbup<SUB>posnr = vapma</SUB>posnr</P></LI><LI level="1" type="ul"><P> join vbep</P></LI><LI level="1" type="ul"><P> on vbep<SUB>vbeln = vapma</SUB>vbeln</P></LI><LI level="1" type="ul"><P> and vbep<SUB>posnr = vapma</SUB>posnr</P></LI><LI level="1" type="ul"><P> join vbap</P></LI><LI level="1" type="ul"><P> on vbap<SUB>vbeln = vapma</SUB>vbeln</P></LI><LI level="1" type="ul"><P> and vbap<SUB>posnr = vapma</SUB>posnr</P></LI><LI level="1" type="ul"><P> join kna1</P></LI><LI level="1" type="ul"><P> on kna1<SUB>kunnr = vapma</SUB>kunnr</P></LI><LI level="1" type="ul"><P> for all entries in i_marc</P></LI><LI level="1" type="ul"><P> where vapma~matnr = i_marc-matnr</P></LI><LI level="1" type="ul"><P> and vapma~werks = i_marc-werks</P></LI><LI level="1" type="ul"><P> and vapma~auart in s_auart</P></LI><LI level="1" type="ul"><P> and vbep~wmeng <> 0</P></LI><LI level="1" type="ul"><P> and vbep~edatu < sy-datum</P></LI><LI level="1" type="ul"><P> and vbup~lfgsa <> 'C'</P></LI><LI level="1" type="ul"><P> and vbup~absta <> 'C'</P></LI><LI level="1" type="ul"><P> and vbup~rfgsa <> 'C'</P></LI><LI level="1" type="ul"><P> and vbup~gbsta <> 'C'</P></LI><LI level="1" type="ul"><P> and ( vbak~lifsk = ' ' and</P></LI><LI level="1" type="ul"><P> vbep~lifsp = ' ' and</P></LI><LI level="1" type="ul"><P> vbuk~cmgst not in ('B', 'C') ).</P></LI></UL><P></P></BODY></HTML> Tue, 19 Jun 2007 11:24:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391138#M531752 Former Member 2007-06-19T11:24:33Z Re: Join Condition https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391139#M531753 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Try using the 'FOR ALL ENTRIES'</P><P></P><P>Regards,</P><P></P><P>Shehryar Dahar</P></BODY></HTML> Tue, 19 Jun 2007 12:24:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391139#M531753 Former Member 2007-06-19T12:24:31Z Re: Join Condition https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391140#M531754 <HTML><HEAD></HEAD><BODY><P>Hi Nagaraju </P><P></P><P>U can use the statment </P><PRE><CODE>FOR ALL ENTRIES</CODE></PRE><P> or else you can also use <b>View</b> to join all these conditions dynamically </P><P></P><P>Reward all helpfull answers</P><P></P><P>Regards</P><P>Pavan</P></BODY></HTML> Tue, 19 Jun 2007 12:27:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391140#M531754 Former Member 2007-06-19T12:27:46Z Re: Join Condition https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391141#M531755 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>What for you are using the VAPMA table?</P><P>remove it and take MATNR and WERKS from VBAP table and AUDAT from VBAK table</P><P>and see the sequence of the table fields</P><P>and tables like VBAK, VBAP,VBEP, VBUK,VBUP, KNA1</P><UL><LI level="1" type="ul"><P>select </P></LI><LI level="1" type="ul"><P>vbak~audat</P></LI><LI level="1" type="ul"><P> vbap~matnr</P></LI><LI level="1" type="ul"><P>vbap~werks</P></LI><LI level="1" type="ul"><P>vbap~kzwi2</P></LI><UL><LI level="2" type="ul"><P>vbep~wmeng</P></LI></UL><LI level="1" type="ul"><P>vbep~cmeng "rounded quantity</P></LI><LI level="1" type="ul"><P>vbep~vrkme</P></LI><LI level="1" type="ul"><P>vbep~meins</P></LI><LI level="1" type="ul"><P>vbep~vbeln</P></LI><LI level="1" type="ul"><P>vbep~posnr</P></LI><LI level="1" type="ul"><P>vbep~etenr</P></LI><LI level="1" type="ul"><P>kna1~name1</P></LI><LI level="1" type="ul"><P>into table it_orders</P></LI><LI level="1" type="ul"><P>from vbak join vbap</P></LI><LI level="1" type="ul"><P>on vbak<SUB>vbeln = vbap</SUB>vbeln</P></LI><LI level="1" type="ul"><P>join vbep</P></LI><LI level="1" type="ul"><P>on vbep<SUB>vbeln = vapma</SUB>vbeln</P></LI><LI level="1" type="ul"><P>and vbep<SUB>posnr = vapma</SUB>posnr</P></LI><LI level="1" type="ul"><P>join vbuk</P></LI><LI level="1" type="ul"><P>on vbuk<SUB>vbeln = vbak</SUB>vbeln</P></LI><LI level="1" type="ul"><P>join vbup</P></LI><LI level="1" type="ul"><P>on vbup<SUB>vbeln = vbap</SUB>vbeln</P></LI><LI level="1" type="ul"><P>and vbup<SUB>posnr = vbap</SUB>posnr</P></LI><LI level="1" type="ul"><P>join kna1</P></LI><LI level="1" type="ul"><P>on kna1<SUB>kunnr = vbak</SUB>kunnr</P></LI><LI level="1" type="ul"><P>for all entries in i_marc</P></LI><LI level="1" type="ul"><P>where vbap~matnr = i_marc-matnr</P></LI><LI level="1" type="ul"><P>and vbap~werks = i_marc-werks</P></LI><LI level="1" type="ul"><P>and vbak~auart in s_auart</P></LI><LI level="1" type="ul"><P>and ( vbak~lifsk = ' ' and</P></LI><LI level="1" type="ul"><P>vbep~lifsp = ' ' and</P></LI><LI level="1" type="ul"><P>and vbep~wmeng <> 0</P></LI><LI level="1" type="ul"><P>and vbep~edatu < sy-datum</P></LI><LI level="1" type="ul"><P>and vbup~lfgsa <> 'C'</P></LI><LI level="1" type="ul"><P>and vbup~absta <> 'C'</P></LI><LI level="1" type="ul"><P>and vbup~rfgsa <> 'C'</P></LI><LI level="1" type="ul"><P>and vbup~gbsta <> 'C'</P></LI><LI level="1" type="ul"><P>vbuk~cmgst not in ('B', 'C') ). </P></LI></UL><P></P><P>Reward points for useful Answers</P><P>Regards</P><P>Anji</P></BODY></HTML> Tue, 19 Jun 2007 12:35:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join-condition/m-p/2391141#M531755 Former Member 2007-06-19T12:35:34Z