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

[olivergrande]

Hallo,

if you are on 4.70 (or higher) you can use the code inspector. The tool covers a lot of check including performance checks.

Regards,

Oliver

[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.

[Former Member]

look at the Code Inspector (transaction SCI). Available for version higher than 4.6c. For version 4.6c please look at OSS note 543359

regards,

Andrzej

[Former Member]

Hi Surendher,

As far as I know there are no such standard program to check the efficiency of the source code. This job can be done by the basis team when there is a load to the DB tables.

Job of the auditors to check the standards maintained in the programs, online documentations/comments other necessary docu.

Few more what I absorbed for efficiency,

1.In read statements try to use BINARY SEARCH.

2.Reduce SORT statements.

If you know any please let me know.