ABAP ALV Report Issue

[former_member205363]

Hi Friends,

I have a report with 2 big queries, reading all Open POs and PRs, then looping to calculate the PO count, PR Count and other values.

Problem is after running the report I am getting Log Off popup.

I used the progress indicator in side the loop to keep the program running, still issue is coming.

Thanks,

Prasad.

[Former Member]

you need to work step by step.

First remove progress indicator code then check..

if still issue coming then look for another.

also show your code. from where it occurs.

-Avirat

[former_member809980]

hi,

why does this Log off pop up appears??

thanks!!

[former_member205363]

Hi,

If I give the selection parameter to limit the number of records then its working fine, otherwise without any selection screen values, its loging off.

I dont know why loging off popup is coming, thats what the issue.

Thanks,

Prasad.

[shadab_maldar]

Hi Lakshmi,

Is the system giving any dump??

I think this is because the report is taking too much time to execute, check once with the BASIS consultant.

Regards,

Shadab.

[shadab_maldar]

Hi Lakshmi,

I think you are using the FM 'SAP_GUI_PROGRESS_INDICATOR' , as I remember this will also handles timeouts.

My suggestion is process the logic of progress BAR for selected line of records.

Example: executes process bar logic for every 20000 records once or even less in a loop(Do not execute for each record in a loop).

And also use commit work statement after the FM this will remove your timeout/logoff error.

Note: First try to optimize your code, if nested loop exists try to implement parallel cursor.

Regards,

Shadab.

[danesh_ms]

hi prasad,

could u post your code here

so that your issue can be fixed

[former_member229519]

Hi Lakshmi,

You may refer to below links for using Open, Fetch and Close CURSOR statements.

It may help.

http://scn.sap.com/thread/1760961

https://help.sap.com/saphelp_470/helpdata/en/fc/eb3b23358411d1829f0000e829fbfe/content.htm

Thanks and Regards,

Vikram

[former_member205363]

Thanks to all for your inputs, I came to know the issue, its regarding continues usage of progress indicator status inside the loop.

[roberto_forti]

Hi Lakshmi,

Implement package size, ok?

Select ... appending table it_...[] package size 1000 where ..."

Regards