To check ABAP Code efficiency

[Former Member]

Hi friends.

Instead of SQL Trace/SE30/Extended Program check,Is there any SAP Standard or ABAP Program available in SAP R/3 to <b><u>audit</u></b>(To test the efficiency of Source code) the <u><b>Z-Programs</b></u> ?

Please if any share with me!

Thanks.

Surendher Reddy.B

[Former Member]

Hi,

Get ride of any nested selects. try to select all your data upfront into internal tables and process them instead of loads of selects nested as this increases the number of hits between the application server (front-end) and the database server (back-end).

Also, use FOR ALL ENTRIES syntax to improve efficiently.

In SE38 run the menu Environment -> Examples -> Performance examples. This will highlight any areas you may be able to make big savings.

You can also use the runtime analysis to see where your bottlenecks are.

If you provide me an e-mail, I will send you some source code you can manipulate for QA checking. However, it is a little hard to understand but you are welcome to view it.

Cheers

Colin.