performane issue in accesing VBFA table

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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