Slow running time of Standard SAP Reports

[Former Member]

Hi Experts,

Standard PS reports (such as the one with the transaction code s_alr_87013558) are taking quite a lot of time to fetch the desired results.  After further analysis we have found that the time in retrieving the data from certain standard tables is the root cause behind this issue.

Is there a way in which we can speed up the processing time for fetching the results?

Regards

Varun

[sammar81 · Accepted solution]

Hi Varun,

Your basis guys should be able to help you in this scenario:

They can increase the parameters on the tables, or increase the physical memory, or do some indexing on the tables..

But all of this doesn't come under the purview of SAP PS

Regards

Sammar

[former_member853832]

Please refer note - 1939618  - Long runtime in hierarchy/summarization reports.

Thanks,

Krupali

[Former Member]

Hi Krupali,

Referred the OSS Note , but still the issue persists.

Regards

Varun

[MTerence]

Hi Varun,

It will be good, if you raise it to SAP.So they can provide you the solution.

Regards

Terence

[Former Member]

Thanks Maria. I am planning to do the same.

Regards

Varun

[varshal_kachole3]

Hi,

Do you have the Value categories configured?

If not please configure the same as per the instructions in Note: http://service.sap.com/sap/support/notes/676123

There is no mention whether this long run time is for all the Projects or few isolated cases?

Do you get the time out dump while executing those report?

Hope it Helps!

Thanks and Regards,

Varshal Kachole

[Former Member]

Hi Maria,

There is no custom logic involved.

Regards

Varun

[MTerence]

Hi Varun,

I saw this note, seems to be related, but please check

My best advice is raise to SAP

2003030 - Long runtime in CN41/incorrect residual order plan/incorrect assigned value

Regards

Terence

[MTerence]

Hi Varun,

Check whether there is any custom logic you have used in the coding.

There is always a chance to raise this with SAP if there is no custom coding we have done in this transaction.

Regards

Terence

[Former Member]

Thanks Sammar (For being a little patient with me since most of the questions I have asked you, I remember were outside PS even though personally I have been handling PS).

The point is whether there is a standard way which could increase the response time of the standard reports.(After having tried cjen, the response time seems to have be improved by a few seconds which I have suggested). I did take the help of an ABAPer on this and after subsequent analysis we have found that the results while using this standard SAP report (s_alr_87013558) are fetched from the table COEP .(which is primarily the reason for the response time to be on the higher side)

Kindly suggest.

Regards

Varun

[sammar81]

Hi Varun,

Other than increasing the physical memory all other are standard SAP practices to increases the performance of the reports..

The standard reports will definitely fetch the data from COEP, COSP or RPSCO tables, and these are very heavy tables.

if you are taking help from ABAPer, he should be able to do some primary indexing on these tables to see the querying is faster..

On a lighter note.. wait for HANA upgrade..

Regards

Sammar

[former_member195427]

Hi Varun,

Just a few pointers, you need to discuss it with  your technical consultant:

Check SE30 settings for COEP table -> whether buffering is allowed or not- > if you want to reduce buffering time then you need to deselect buffering.

You also need to keep a trace on its (table) performance on data access in background (You may need to use trace techniques of ABAP for it)

Regards

Saurabh

[Former Member]

Hi Varun,

COEP is the table to fetch CO Object : Line item.

Often it is observed that fetching data from this table takes long time...

In such case, try entering few selection criteria like Company code, controlling area or any other relevant parameters... We tried like this and observed it takes little less time as compared to fetching data with only one parameter.

If this also do not help, then as suggested by others to you already, you can take help of Basis team.

Regards

Tushar