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