Performance problem in Zstick report...

[Former Member]

Hi Experts,

I am facing performance problem in Custoom Stock report of Material Management.

In this report i am fetching all the materials with its batches to get the desired output, at a time this report executes 36,000 plus unique combination of material and batch.

This report takes around 30 mins to execute. And this report is to be viewed regularly in every 2 hours.

To read the batch characteristics value I am using FM -> '/SAPMP/CE1_BATCH_GET_DETAIL'

Is there any way out to increase the performance of this report, the output of the report is in ALV.

May i have any refresh button in the report so that data may get refreshed automatically without executing it again. or is there any cache memory concept.

Note: I have declared all the itabs with type sorted, all the select queries are fetched with key and index.

Thanks

Rohit Gharwar

[Former Member]

Hi Experts,

I am facing performance problem in Custoom Stock report of Material Management.

In this report i am fetching all the materials with its batches to get the desired output, at a time this report executes 36,000 plus unique combination of material and batch.

This report takes around 30 mins to execute. And this report is to be viewed regularly in every 2 hours.

To read the batch characteristics value I am using FM -> '/SAPMP/CE1_BATCH_GET_DETAIL'

Is there any way out to increase the performance of this report, the output of the report is in ALV.

May i have any refresh button in the report so that data may get refreshed automatically without executing it again. or is there any cache memory concept.

Note: I have declared all the itabs with type sorted, all the select queries are fetched with key and index.

Thanks

Rohit Gharwar

[Former Member]

Hi,

Without seeing the Code..it is difficult to say Anything.......

[Former Member]

Did you run SE30 and look at the analysis log?

[former_member251078]

Hello,

SE30 is old. Switch on trace on ST12 while running this progarm and identify where exactly most of the time is being spent. If you see high CPU time this problem with the ABAP code. You can exactly figure out the program/function module from ST12 trace where exactly time is being spent. If you see high database time in ST12, problem is with database related issue. So basically you have to analyze sql statement from performance traces in ST12. These could resolve your issue.

Yours Sincerely

Dileep

[Former Member]

> SE30 is old. Switch on trace on ST12 while

incorrect, the St12 is always based on the SE30. But the ST12 is a service add-on and usually not available.

For most purposes the hitlist of the SE30 is sufficient to figure out the problem.

Siegfried

[Former Member]

Hello Siegfried Boes,

I am very much agreed with what you ve told about the st12. The Sm30 is the place where you can see and find the solutions. And if extra needed then go to ST12.

[Former Member]

This message was moderated.

[Former Member]

Hi,

Did you see how much time does it take to execute the function '/SAPMP/CE1_BATCH_GET_DETAIL' ? The trouble could be there. Thus try to incorporate the logic used within that function in your Z program in a subtroutine etc...

When you call functions, the entire function group gets loaded. Also that the function might be performing some extra functionality that your program might not require and this could be causing the long runtime.

regards,

Advait

[Former Member]

Hi

Do you tried replacing /SAPMP/CE1_BATCH_GET_DETAIL with BAPI_BATCH_GET_DETAIL

Let me know it helps you.

Regards,

Sriram

[Former Member]

Thanks Every one....