topic Re: Performance problem in ABAP code in Application Development and Automation Discussions

Performance problem in ABAP code

Former Member — Thu, 17 Mar 2005 06:42:55 GMT

hai guys,

I created report using tables like bsis,t001 etc,( tax report).

I have performance problem in this report.

COuld you pls tell me how to analyse the report and find out the place where process is taking more memory etc.

i did abap trace and runtime analysis..but could not find out exact point.

how to do this..

i want to analysis each subroutine,internal table and query process.

could you pls give me some ideas.

ambichan

Re: Performance problem in ABAP code

Former Member — Thu, 17 Mar 2005 06:59:24 GMT

There is an excellent tool available in SAP - <b>Code Inspector.

</b>

Transaction is SCII

Try the following link and I am sure you will find a bunch of useful documents.

<a href="http://www.google.co.in/search?hl=en&safe=off&q=site%3Asdn.sap.comfiletype%3ApdfCode+Inspector&btnG=Search&meta=">ABAP Performance</a>

I use the Code Inspector to search for

a) All the select statements which are present within the loop

b) Nested Loops

c) Select query without providing criteria for primary keys, depending upon situation

d) Can the search be narrowed with extra conditions

e) Using READ .. BINARY SEARCH if internal table has lots of records.

The list is actually endless, but this is something to start with.

You can actually have a checklist, and depending upon it, go through your code. The more you adhere to checklist, you will find that, the performance would dramatically improve.

Also use <b>ST05</b> transaction, for SQL Trace and find out which select query is taking the maximum time for response.

Regards,

Subramanian V.

Re: Performance problem in ABAP code

andreas_mann3 — Thu, 17 Mar 2005 07:18:12 GMT

or look here

http://help.sap.com/saphelp_470/helpdata/en/5a/ace273ca0211d194b500a0c94260a5/frameset.htm

regards Andreas

Re: Performance problem in ABAP code

Former Member — Thu, 17 Mar 2005 09:01:27 GMT

hay

could you pls tell me transaction code for Code inspector.

I am working in 40B system.

SCII is not working here..

ambichan.

Re: Performance problem in ABAP code

Former Member — Thu, 17 Mar 2005 09:07:14 GMT

Hi,

I think the problem could be in the SELECT query where you access BSIS table ( may be without primary keys ).

Regards,

Sameej T.K.

Re: Performance problem in ABAP code

Former Member — Thu, 17 Mar 2005 09:16:30 GMT

Hello AMbichan,

I don't think the code inspector is available in the 4.0B Version of R/3.

Regards,

Anand Mandalika.

Re: Performance problem in ABAP code

Former Member — Thu, 17 Mar 2005 09:36:45 GMT

Hello,

Code Inspector is available in 4.6C by OSS-note 543359. Also in 4.7.

Regards, Juha

Re: Performance problem in ABAP code

Former Member — Thu, 17 Mar 2005 15:55:07 GMT

Hi Ambi chan,

Please post the select statement portion of your code here. Your performance problem may be there.

Srinivas

Re: Performance problem in ABAP code

Former Member — Thu, 19 May 2005 13:04:48 GMT

Hi,

The code inspector transaction is 'SCI'.

Re: Performance problem in ABAP code

VijayasekarK — Thu, 19 May 2005 13:15:33 GMT

Hi Ambi ,

Use Tcode SE30 , give the program name and execute it . At the end of SE30 execution ...you can able find whether the problem is with Database Access , ABAP or System.

If Database time is high , then use ST05 and identify the dbase query and fix it (check "where " clause).

If ABAP runtime is high , there may be a problem in loop's.....restructure the code.

Hope it helps...

Regards,

Vijay

Re: Performance problem in ABAP code

Former Member — Tue, 07 Jun 2005 19:22:39 GMT

To identify those bad "WHERE" clauses you can use AboveSoft Analyzer; download it using the link below and ask for the free license:

http://download.abovesoft.com

Regards,

Diego.

Re: Performance problem in ABAP code

Former Member — Wed, 08 Jun 2005 03:20:11 GMT

Post your selection code...

There are loads of run time analyzers in SDN

Cheers,

Ram

Re: Performance problem in ABAP code

Former Member — Wed, 08 Jun 2005 03:45:16 GMT

That's a good one, Ram :-).

Smiles,

Anand.

Re: Performance problem in ABAP code

Former Member — Wed, 08 Jun 2005 10:10:56 GMT

hey i think ihave awarded points for this thread

but why still its marked as question...

Re: Performance problem in ABAP code

Former Member — Wed, 08 Jun 2005 13:17:16 GMT

which is the criteria to marked it as question?