ABAP Customised Reports Are Slow.

[Former Member]

Hello All,

We have a problem with the Abap customized reports, which is taking too long to execute and sometimes throwing dumps like TIME_OUT.

I have evaluated the program from se38 for those reports and the result was:

The ABAP Graph is showing green.

The Database Graph is showing RED.

What can i do to reduce the execution time of 'Z' Reports.

The other standard reports are working fine and not taking that much time to execute.

Thanks.

Regards,

Mudassir.Imtiaz

[markus_doehr2]

> The ABAP Graph is showing green.

> The Database Graph is showing RED.

> What can i do to reduce the execution time of 'Z' Reports.

Optimize your program.

Since the database execution seems to take most of the time you have to check your selects.

I have seen many program where there are nested select statements reading too much data, e. g. using "select *" instead of only reading the necessary fields. You may also check the sequence of how you access the data if you read from the database. You may also check whether it may be better to use function modules to get specific data instead of trying to read from the tables directly.

Markus

[Former Member]

Thanks Markus for you helpful answer.

I will make the changes and update here.

Regards,

Mudassir.Imtiaz