Skip to Content
0
Former Member
Apr 24, 2007 at 12:44 AM

Select in VBFA Table

728 Views

Hello All,

We need to improve performance in a program that uses VBFA table in three ways. How can we avoid this table or what we have to do in select statements to improve the program performance.

1) select vbeln posnn vbelv posnv vbtyp_n vbtyp_v

into table it_vbfa1

from vbfa

where vbtyp_n = 'R'

and erdat in r_budat.

2) select vbeln posnn vbelv posnv vbtyp_n

appending table it_vbfa1

from vbfa

for all entries in it_mseg_vbfa_nf

where vbeln = it_mseg_vbfa_nf-vbeln

and posnn = it_mseg_vbfa_nf-posnn

and vbtyp_n = 'R'

3) select vbelv posnv vbeln posnn vbtyp_n

into table it_vbfa2

from vbfa

for all entries in it_vbfa1

where vbelv = it_vbfa1-vbelv

and posnv = it_vbfa1-posnv.

Points will be rewarded!

Thanks,

Michel Khouri

Mars, Inc