topic Re: VBFA fetches in Application Development and Automation Discussions

VBFA fetches

Former Member — Tue, 06 May 2008 06:49:20 GMT

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

Re: VBFA fetches

Former Member — Tue, 06 May 2008 06:53:51 GMT

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

Re: VBFA fetches

Former Member — Tue, 06 May 2008 12:04:35 GMT

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