02-21-2007 7:25 AM
Hi,
Please can anybody help me in the performance tuning of the VA01 transaction since its consuming a lot of time in production.
This issue is very urgent.
Pls help.
02-21-2007 8:30 AM
first check Y it is taking lot of time ? Have u done any changes for this Tcode , i.e any user exits ?
make use of ST05 .
Regards
Prabhu
02-21-2007 9:21 AM
Thanks for ur reply.
The ST05 SQL trace has been taken and two userexits have been written
MV45AFZB
MV45AFZZ
02-21-2007 9:34 AM
Set a break point in MV45AFZB
MV45AFZZ user exits. check how much time it is taking, if it is taking too much in this exits, then try to change the code.
02-21-2007 9:14 AM
Hi,
in addition to checks for bad code in user exits (see above), are already not-used standard functions deactivated? Like follow-on materials, batches, availability check and so on?
Regards
Christian
02-21-2007 1:55 PM
Have you checked SAP notes? This is a standard SAP transaction and your answer may well be there.
Rob
02-22-2007 2:15 PM
The performance tuning of the user exits of va01 transaction will help in performance tuning of va01.
02-22-2007 2:16 PM
The performance tuning of the user exits of va01 transaction will help in performance tuning of va01.
reward with points
02-22-2007 6:12 PM
I would suggest you check if any (or many) outputs are processed with timing "immediately" for your orders, since in this case they are processe din update task of VA01 na dbad runtime of the output will impact VA01 for sure.
To check -> compare VA01 with all outputs set to timing '1' -> via batch program
and VA01 with outputs as usual (timing '4' - immediately, if you have any).
02-25-2007 3:05 AM
The only way to improve the performance of standard transactions is by modifying the logic in the user exits (if any).. if not then restricting the usage of the transaction by controlling the processes in customizing...
We faced similar problem with VA01 at our previous client and we fine tuned all the user exits in the sales order... removed the unwanted code...and now its working fine..
02-26-2007 8:20 AM
Check the following Links
http://www.sapgenie.com/abap/performance.htm
http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp
check the below link
http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm
See the following link if it's any help:
http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp
Check also http://service.sap.com/performance
and
books like
http://www.sap-press.com/product.cfm?account=&product=H951
http://www.sap-press.com/product.cfm?account=&product=H973
http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm
02-26-2007 8:31 AM
Always check the driver internal tables is not empty, while using FOR ALL ENTRIES
Avoid for all entries in JOINS
Try to avoid joins and use FOR ALL ENTRIES.
Try to restrict the joins to 1 level only ie only for tables
Avoid using Select *.
Avoid having multiple Selects from the same table in the same object.
Try to minimize the number of variables to save memory.
The sequence of fields in 'where clause' must be as per primary/secondary index ( if any)
Avoid creation of index as far as possible
Avoid operators like <>, > , < & like % in where clause conditions
Avoid select/select single statements in loops.
Try to use 'binary search' in READ internal table. Ensure table is sorted before using BINARY SEARCH.
Avoid using aggregate functions (SUM, MAX etc) in selects ( GROUP BY , HAVING,)
Avoid using ORDER BY in selects
Avoid Nested Selects
Avoid Nested Loops of Internal Tables
Try to use FIELD SYMBOLS.
Try to avoid into Corresponding Fields of
Avoid using Select Distinct, Use DELETE ADJACENT
you can refer these links :
http://www.sapgenie.com/abap/performance.htm
chk this
Check the following Links
http://www.sapgenie.com/abap/performance.htm
http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp
check the below link
http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm
See the following link if it's any help:
http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp
Check also http://service.sap.com/performance
and
books like
http://www.sap-press.com/product.cfm?account=&product=H951
http://www.sap-press.com/product.cfm?account=&product=H973
http://www.sap-img.com/abap/more-than-100-abap-interview-faqs.htm
cheers!
sri