topic Re: performane issue in accesing VBFA table in Application Development and Automation Discussions

performane issue in accesing VBFA table

Former Member — Thu, 28 Aug 2008 00:49:26 GMT

Hi frnds,

I have requirement that get sales return value and flow is get delivery document and from delivery get sales detail data and further get return and sales value for particular sales order.

Now when I am accessing VBFA table for getting Sales order from delivery document number, it is taking more time to get sales order and it is performance issue.

So any suggestions are welcome...

Thanks

Priyank

Re: performane issue in accesing VBFA table

Former Member — Thu, 28 Aug 2008 01:02:06 GMT

Did you try using any of these FM's:

SD_VBFA_ARRAY_READ_VBELV

SD_VBFA_READ_WITH_VBELV

SD_VBFA_SELECT

SD_VBFA_SINGLE_READ

SD_VBFA_TRANSFER_TO_BUFFER

Re: performane issue in accesing VBFA table

Former Member — Thu, 28 Aug 2008 03:27:08 GMT

Hi Priyank,

To get a Sales Order Number for a Delivery Number you can go for the Delivery tables LIKP (Delivery Header) and LIPS (Delivery Item)

In LIPS we have VGBEL field which is the Sales Order Number, and VGPOS is Sales Item.

Regards,

Chandra Sekhar

Re: performane issue in accesing VBFA table

Former Member — Fri, 29 Aug 2008 23:22:38 GMT

Got the solution with other method, but thanks for help.