Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Slow response of ALV report for a high volume internal table

Former Member
0 Kudos

We have a requirement in which we have to display more than 5 lac records (= 500,000) in a single alv report. The internal table has 30 fields. it takes around five minutes to display the alv.



i_callback_program = l_repid

i_callback_pf_status_set = pfstatus

it_fieldcat = it_fcat[]

i_save = 'A'

is_layout = gs_layout

  • is_variant = import_variant

it_events = events[]


t_outtab = i_tab.

above is the code used to display the alv. Any change in the coding to be done to improve the performance?

Thanks in advance.

K Mohan

Edited by: Thomas Zloch on May 23, 2011 4:16 PM


Active Contributor
0 Kudos

ALV is not designed for handling very large data volumes, check the online documentation of the ALV function modules and classes.

All data must be in memory at once and is even multiplied inside the standard function modules / classes before display, as far as I have observed. Thus the runtime increases with growing size of the internal table, the system will probably start swapping to hard disk at some point.

Search for related SAP notes if still in doubt.


Former Member
0 Kudos

ALV display will be slow in these cases where there is too many records. may be try out other output options, but with these many records in the output most of the other options too will be slow.


Former Member
0 Kudos

- Check if the program is taking long time while fetching or finalizing of the table.. Make some repair here.

- If the time is taking in call for alv_grid_display, then no further tuning would be required.

0 Kudos

ALV is easiest and effective way of producing reports to the users . Users are very much comfortable with ALV reports as it can be easily downloaded to Excel and its in tabulation. The time taken is more only in ALV call function.



0 Kudos


As Thomas said ALV is not designed to display such a huge data, any how you can limit the data in the selection screen. one more reason is if you display 5Lak records in one ALV list then if you download them to excel sheet, you can download upto 65000 records only. So limit the display not more than 60000 for a better performance.