topic Re: Performance issues in ABAP Programs in Application Development and Automation Discussions

Performance issues in ABAP Programs

Former Member — Wed, 19 Dec 2007 16:47:26 GMT

Hi Guys,

Tell me how to take care of performance issues while writing any ABAP Program?

Regards,

Amruth

Re: Performance issues in ABAP Programs

Former Member — Wed, 19 Dec 2007 16:50:17 GMT

Check:

<a href="/people/rob.burbank/blog/2006/11/16/performance--what-will-kill-you-and-what-will-leave-you-with-only-a-flesh-wound">/people/rob.burbank/blog/2006/11/16/performance--what-will-kill-you-and-what-will-leave-you-with-only-a-flesh-wound</a>

Rob

Re: Performance issues in ABAP Programs

Former Member — Wed, 19 Dec 2007 16:52:58 GMT

Refer to this URL.

http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b7e358411d1829f0000e829fbfe/frameset.htm

Lokesh

Re: Performance issues in ABAP Programs

Former Member — Wed, 19 Dec 2007 16:55:40 GMT

Hi Amruth,

Performance of ABAPs can be improved by minimizing the amount of data to be transferred.

The data must be transferred throught the network to the aplications, so reducing the amount of time & also reduces the network traffic.

Some measures that can be taken care :

-Use views defined in the ABAP/4 DDIC(also has the advantage of better reusability)

-Use field list(SELECT clause) rather than SELECT *.

-Range tables should be avoided(IN Operator)

-Avoid nested SELECTs.

Regards,

Chandru

Re: Performance issues in ABAP Programs

Former Member — Wed, 19 Dec 2007 17:02:49 GMT

Hi Chandru,

Can u list all the performance issues that should be taken care?

Regards,

Amruth

Re: Performance issues in ABAP Programs

Former Member — Wed, 19 Dec 2007 17:11:50 GMT

Hi,

check out this link

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_Introduction.asp

Its a good one.

Lokesh

Re: Performance issues in ABAP Programs

Former Member — Wed, 19 Dec 2007 21:50:47 GMT

Dear Amruth,

The following guidelines can be used to improve the performance of an ABAP Program:

> 1. Follow the naming standards (of the company or client you are working)

> 2. Use select field one field two etc do not use select *

> 3. Avoid unnecessary loops. If requirec use loop with where clause or Read with binary search

> 4. Use case statement in place of if else

> 5. use clear table before select single or where ever applicable.

> 6. check for sy-subrc where ever applicable

> 7. avoid collect statement if possinble

> 8. do proper documentation of the program inside abap editor and also in se38 (screen-documentation radio button )

> 9. try to use views rather than nested select statement

> 10. use ABAP TRACE try to work on those SQL statements to improve performance

> 11. use index only if it is required

> 12. in internal table declaration try to use correct occurs number say occurs 1000. Otherwise use occurs 0.

> 13. while using select statements use single select, select * upto 5 rows ,etc based on the requirement.use select options wisely taking performance into account.

> 14. declare variables / parameters with meaningful words like v_matnr for material number or v_bukrs for plant or at least v_matnum for material number etc.

> 15. Beautify the code using pretty printer, pattens(***** ——- etc)

Best Regards,

Rajesh

Please reward points if found helpful.