topic Re: alternative for it! in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767736#M644684 <HTML><HEAD></HEAD><BODY><P>It's not incorrect, just slow. You are trying to get the preceding document from the subsequent document using document flow. VBFA is generally used the other way around. You may be able to get the preceding document number from the table you get tvbdpl-vbeln.</P><P></P><P>Rob</P></BODY></HTML> Mon, 10 Sep 2007 13:46:40 GMT Former Member 2007-09-10T13:46:40Z alternative for it! https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767732#M644680 <HTML><HEAD></HEAD><BODY><P>SELECT SINGLE posnv INTO v_posnv FROM vbfa WHERE vbeln = tvbdpl-vbeln AND</P><P> posnn = tvbdpl-posnr.</P><P></P><P>table:</P><P></P><P>MANDT</P><P>VBELV</P><P>POSNV</P><P>VBELN</P><P>POSNN</P><P>VBTYP_N</P><P>RFMNG</P><P>MEINS</P><P>RFWRT</P><P>WAERS</P><P>VBTYP_V</P></BODY></HTML> Mon, 10 Sep 2007 07:11:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767732#M644680 Former Member 2007-09-10T07:11:09Z Re: alternative for it! https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767733#M644681 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>what exactly is your question?</P><P></P><P>Regards,</P><P>Gianpietro</P></BODY></HTML> Mon, 10 Sep 2007 07:52:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767733#M644681 Former Member 2007-09-10T07:52:04Z Re: alternative for it! https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767734#M644682 <HTML><HEAD></HEAD><BODY><P>usually select single means that you read one line because you specify a complete unique key. Sometimes it is used to read only one record of several fulfilling the where condition.</P><P></P><P>Is there a secondary key on on VBFA with VBELN and POSNN?</P></BODY></HTML> Mon, 10 Sep 2007 08:36:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767734#M644682 Former Member 2007-09-10T08:36:25Z Re: alternative for it! https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767735#M644683 <HTML><HEAD></HEAD><BODY><P>no. </P><P>i wanted to create it..is it right thought?</P></BODY></HTML> Mon, 10 Sep 2007 09:37:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767735#M644683 Former Member 2007-09-10T09:37:02Z Re: alternative for it! https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767736#M644684 <HTML><HEAD></HEAD><BODY><P>It's not incorrect, just slow. You are trying to get the preceding document from the subsequent document using document flow. VBFA is generally used the other way around. You may be able to get the preceding document number from the table you get tvbdpl-vbeln.</P><P></P><P>Rob</P></BODY></HTML> Mon, 10 Sep 2007 13:46:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767736#M644684 Former Member 2007-09-10T13:46:40Z Re: alternative for it! https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767737#M644685 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>yes you had writen the code in correct way </P><P></P><P>select single * </P><P> from table </P><P> into table </P><P> where condition</P></BODY></HTML> Tue, 11 Sep 2007 04:45:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alternative-for-it/m-p/2767737#M644685 Former Member 2007-09-11T04:45:24Z