topic Re: VBFA in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/vbfa/m-p/1477290#M223694 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>To get the document flow from VBFA, you could use function module: RV_ORDER_FLOW_INFORMATION</P><P></P><P>l_comwa-mandt = sy-mandt.</P><P> l_comwa-vbeln = g_order.</P><P></P><P> CALL FUNCTION 'RV_ORDER_FLOW_INFORMATION'</P><P> EXPORTING</P><P> belegtyp = g_vbtyp</P><P> comwa = l_comwa</P><P> IMPORTING</P><P> belegtyp_back = l_belegtyp_back</P><P> TABLES</P><P> vbfa_tab = gitab_vbfa</P><P> EXCEPTIONS</P><P> no_vbfa = 1</P><P> no_vbuk_found = 2</P><P> OTHERS = 3.</P><P></P><P>Relevant document records can be found in GITAB_VBFA.</P><P>Then use the normal Loop at ITAB / ENDLOOP and collect the relevant records.</P><P></P><P>Hope this helps.</P><P></P><P>Rgds,</P><P>HR</P></BODY></HTML> Wed, 26 Jul 2006 09:28:49 GMT Former Member 2006-07-26T09:28:49Z VBFA https://community.sap.com/t5/application-development-and-automation-discussions/vbfa/m-p/1477288#M223692 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>just want to ask help how to get the following records from the table VBFA</P><P></P><P>main records:</P><P> VBELV POSNV VBELN POSNN VBTYP_N</P><P> 00001 00010 12345 00001 J</P><P> 00001 00010 23456 00002 J</P><P> 00001 00010 34567 00010 J</P><P> 12345 00010 xxxxx nnnnn R</P><P> 23456 00010 xxxxx nnnnn R</P><P></P><P>how to get the following without looping from VBFA:</P><P>A:</P><P> 12345 00010 xxxxx nnnnn R</P><P> 23456 00010 xxxxx nnnnn R</P><P></P><P>B:</P><P> 00001 00010 34567 00010 J</P><P></P><P></P><P>thank you.</P><P></P><P>donna</P></BODY></HTML> Wed, 26 Jul 2006 03:15:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/vbfa/m-p/1477288#M223692 Former Member 2006-07-26T03:15:04Z Re: VBFA https://community.sap.com/t5/application-development-and-automation-discussions/vbfa/m-p/1477289#M223693 <HTML><HEAD></HEAD><BODY><P>1)st fetch all main record....</P><P>main records:</P><P>VBELV POSNV VBELN POSNN VBTYP_N</P><P>00001 00010 12345 00001 J</P><P>00001 00010 23456 00002 J</P><P>00001 00010 34567 00010 J</P><P>12345 00010 xxxxx nnnnn R</P><P>23456 00010 xxxxx nnnnn R</P><P></P><P>2)</P><P>mow declare two internal table for difrent recored...</P><P></P><P>3)ex--</P><P>main recored in itab.</P><P>two another internal tables are itab1 and itab2.</P><P></P><P>loop at itab1.</P><P>read table itab binary search with key vbeln = itab1-vbeln</P><P>VBTYP_N = 'J'.</P><P>append itab to itab1.</P><P>endloop.</P></BODY></HTML> Wed, 26 Jul 2006 04:17:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/vbfa/m-p/1477289#M223693 Former Member 2006-07-26T04:17:27Z Re: VBFA https://community.sap.com/t5/application-development-and-automation-discussions/vbfa/m-p/1477290#M223694 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>To get the document flow from VBFA, you could use function module: RV_ORDER_FLOW_INFORMATION</P><P></P><P>l_comwa-mandt = sy-mandt.</P><P> l_comwa-vbeln = g_order.</P><P></P><P> CALL FUNCTION 'RV_ORDER_FLOW_INFORMATION'</P><P> EXPORTING</P><P> belegtyp = g_vbtyp</P><P> comwa = l_comwa</P><P> IMPORTING</P><P> belegtyp_back = l_belegtyp_back</P><P> TABLES</P><P> vbfa_tab = gitab_vbfa</P><P> EXCEPTIONS</P><P> no_vbfa = 1</P><P> no_vbuk_found = 2</P><P> OTHERS = 3.</P><P></P><P>Relevant document records can be found in GITAB_VBFA.</P><P>Then use the normal Loop at ITAB / ENDLOOP and collect the relevant records.</P><P></P><P>Hope this helps.</P><P></P><P>Rgds,</P><P>HR</P></BODY></HTML> Wed, 26 Jul 2006 09:28:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/vbfa/m-p/1477290#M223694 Former Member 2006-07-26T09:28:49Z