topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Thu, 26 Apr 2007 03:46:55 GMT

hi gurus,

You are running a report. It is taking long time for execution. What steps will you do to reduce the execution time.

thanx,

loki

Former Member — Thu, 26 Apr 2007 03:56:58 GMT

hi,

just go to se38 and enter the program name then in the menu bar

program->check->extendend program check

program->check->code inspector.

this will run and show p-erformance issues with your program.

regards,

Navneeth.K

Former Member — Thu, 26 Apr 2007 03:59:51 GMT

Hi,

1.Avoid Nested Loops.

2.Avoid using select * from....you can mention the fields in the selct statement like

select werks matnr from....

3.Use for All entries....Before using for all entries check whether the internal table is intiial or not.

4.Use SE30 to find the Runtime analysis.From there you can find out which part is taking too much time.

5.Keep Break point inside the program and exdecute...you can find where it is takking too much of time.

Reward if it helpful

Regards,

Sangeetha.A

Former Member — Thu, 26 Apr 2007 04:09:59 GMT

Hi Yogi,

If possible just put your code here...

We will try to find the performance factors..

regards,

Navneeth.K