VA05 Performance issues & search indices

[Former Member]

All,

We have a performance issue with transaction VA05 (list of sales orders). On searching SAP notes as well as all forums, no information relevant to our case could be found, so posting it here.

When we run VA05 with selection criteria - customer purchase order number (BSTKD), sales area (VKORG, VTWEG, SPART), the search takes about 5 min or more and times out for some selections. However when I terminate the transaction and rerun it by leaving VTWEG and SPART blank (or VTWEG alone blank), the search is surprisingly quicker - about 5 sec.

An input from our ABAP expert is that ideally VBKD data (based on BSTKD) should be read first and this data should be further filtered after reading VBAK; however transaction VA05 reads both tables independently, i.e. fetches handful records from VBKD for matching BSTKD and several thousands of records from VBAK (matching VKORG, VTWEG, SPART) and then does an 'intersection'. So it is this VBAK table that seems to cause the performance issue.

So we updated statistics of both tables, changed the estimate % from 1 to 10 still there is no improvement. What I don't understand is when only BSTKD and VKORG (VKORG is mandatory) are chosen, the search is much quicker though it is the same two tables relevant for search in both cases. It couldn't have always been this way because this dip in performance is a phenomenon identified only recently.

Can someone please throw some light on this or advise how performance can be improved with complete sales area in selection? (sales area is required in selection as VA05 is used by different businesses)

Thanks & Regards,

KC

SAP SD Analyst

[Former Member]

All,

We have a performance issue with transaction VA05 (list of sales orders). On searching SAP notes as well as all forums, no information relevant to our case could be found, so posting it here.

When we run VA05 with selection criteria - customer purchase order number (BSTKD), sales area (VKORG, VTWEG, SPART), the search takes about 5 min or more and times out for some selections. However when I terminate the transaction and rerun it by leaving VTWEG and SPART blank (or VTWEG alone blank), the search is surprisingly quicker - about 5 sec.

An input from our ABAP expert is that ideally VBKD data (based on BSTKD) should be read first and this data should be further filtered after reading VBAK; however transaction VA05 reads both tables independently, i.e. fetches handful records from VBKD for matching BSTKD and several thousands of records from VBAK (matching VKORG, VTWEG, SPART) and then does an 'intersection'. So it is this VBAK table that seems to cause the performance issue.

So we updated statistics of both tables, changed the estimate % from 1 to 10 still there is no improvement. What I don't understand is when only BSTKD and VKORG (VKORG is mandatory) are chosen, the search is much quicker though it is the same two tables relevant for search in both cases. It couldn't have always been this way because this dip in performance is a phenomenon identified only recently.

Can someone please throw some light on this or advise how performance can be improved with complete sales area in selection? (sales area is required in selection as VA05 is used by different businesses)

Thanks & Regards,

KC

SAP SD Analyst

[Former Member]

To add to my previous thread, transaction SE30 suggests that 99.5% of the total runtime is spent on database access, most of which is due to a select on M_VMVAA (41,140,101 microseconds equivalent to 99.4% of total transaction runtime not just database access). Can anyone advise how the access to M_VMVAA could be improved given that this itself is a matchcode view/table designed for efficient access.

Thanks & Regards,

KC

[Former Member]

>

> All,
> We have a performance issue with transaction VA05 (list of sales orders). On searching SAP notes as well as all forums, no information relevant to our case could be found, so posting it here.

What about note 878680?

If this doesn't help, you should send it to SAP. How can the forum help??

Rob

[Former Member]

Rob,

Note 878680 is about the data not being output as expected rather than about performance. In any case, this note is on our system. I am hoping someone may have had similar experience, i.e. having to do with performance specifically with M_VMVAA.

Cheers,

KC

[Former Member]

It's still an issue for SAP not the forum. If someone suggested you change standard SAP code, would you do that?

If you would, I have a cousin in Nigeria who would like to get in touch with you

Just kidding

Rob

[Former Member]

Now that I come to think of it, this may not be the correct forum for this question after all. I was hoping to get inputs on statistics, estimates, etc. which is a DBA area. Clearly ABAP can't do much for a standard report; so closing the thread.