Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

VBFA fetches

Former Member

‎2008 May 06 7:49 AM

0 Likes
442

Hi,

I am tuning one program to improve the performance which takes one hour in production.

I found that this delay is because of the VBFA table fetches inside the program which has been done several times.And this program is basically for invoice.

Can anyone suggest me how to do the alternate selects for these VBFA selects!

Reward is sure.

Thanks in advance

Hi,

I am tuning one program to improve the performance which takes one hour in production.

I found that this delay is because of the VBFA table fetches inside the program which has been done several times.And this program is basically for invoice.

Can anyone suggest me how to do the alternate selects for these VBFA selects!

Reward is sure.

Thanks in advance

Reply
2 REPLIES 2
Read only

Former Member

‎2008 May 06 7:53 AM

0 Likes
414

hi,

Can you place the piece of code from where it fetches the data from VBFA table .... Also make sure ..

1. It is using all the primary key field in the where condition of your select statement.

2. Else use secondary Index to improve the performance.

regards,

Santosh

Read only

Former Member

‎2008 May 06 1:04 PM

0 Likes
414

Hi,

To improve performance when select VBFA you should select always by vbelv when it is possible. If not, try to use FM

RV_ORDER_FLOW_INFORMATION.

Regards,

Fernando