on 05-16-2006 6:33 AM
I am debugging an existing bapi that's not mine. Aside from the internal tables, What are the things I should check to improve the performance? Someone ask me to check the available indexes in the table, but how will I do it? I only see Key and Initials in the table.
PLease guide me, thanks!
Hi Maui,
Is the BAPI a custom BAPi or a std BAPI? If its a std bapi i dont think there should be any problem in the BAPI. May be its called wrongly.
If its your custom BAPI check if there is any costly select statements.
Cheers
VJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
GOOD
GO THROUGH THIS LINK WHICH WILL GIVE YOU THE COMPLETE IDEA ABOUT THE PERFORMANCE OF THE BAPI.
http://www.sappoint.com/abap/bapiprg.pdf
THANKS
MRUTYUN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Avoid SELECT...ENDSELECT.
Select statement sequence of input field should be same.
Use join instead of for all entries
Avoid nested loop.
Use join or for all entries instead of nested loop.
Avoid select statement in loop.
Use index in where condition with same sequence(Blank range use if u dont have varible in R_VBELN)
Use read statement and use Binary search.
Just have look below document it will be definately useful.
http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm
http://www.sapgenie.com/abap/performance.htm
http://www.sapdevelopment.co.uk/perform/performhome.htm
www.thespot4sap.com/Articles/ SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp
regards
vinod
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In the display table..
U will get <b>Indexes</b> Button on the application toolbar.
Just check them if indexes are defined.
If they are not defined..
U can define the indexes for the fields which ur accessing from the table more often...
Regards,
Simha.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.