Performance problem in ABAP code

[Former Member]

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

[Former Member]

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.

[andreas_mann3]

or look here

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

regards Andreas

[Former Member]

hay

could you pls tell me transaction code for Code inspector.

I am working in 40B system.

SCII is not working here..

ambichan.

[Former Member]

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.

[Former Member]

Hello AMbichan,

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

Regards,

Anand Mandalika.

[Former Member]

Hello,

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

Regards, Juha

[Former Member]

Hi,

The code inspector transaction is 'SCI'.

[Former Member]

Hi Ambi chan,

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

Srinivas

[VijayasekarK]

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

[Former Member]

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.

[Former Member]

Post your selection code...

There are loads of run time analyzers in SDN

Cheers,

Ram

[Former Member]

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

Smiles,

Anand.

[Former Member]

hey i think ihave awarded points for this thread

but why still its marked as question...

[Former Member]

which is the criteria to marked it as question?