Excel download from SE16 - titles every 60,000 rows

[former_member185167]

Greetings!

I am trying to download tens of thousands of rows from SE16 to a spreadsheet

via SAP GUI. It works great but on system ABC it inserts titles every 60,000

rows while on another system (DEF) it only has titles at the top.

Ideally I would like to have system ABC work as DEF does - only titles at the top

This is because I want to manipulate that data and I have to keep going through and removing

all the titles.

I was wondering if there is a setting for this somewhere, specifying titles every 60,000 row.

It could also be because the two SAP systems are different. ABC has SAP_BASIS 700 0017 while

DEF has SAP_BASIS 731 0009. I'm using the same SAP GUI and Excel in both cases.

Apologies if this has been asked before (I searched SCN and SAP Notes) or it's in the wrong

space (let me know) or if more information is needed.

Thanks!

Rick

[naimesh_patel]

ALV download has some specific logic for line number gt 59995.

See program LKKBLF98:

*<<<Y6DK061575
       if sy-linno > 59995 and sy-linct eq 0.
         g_top_of_page_by_60000 = abap_true.
       endif.
 *>>>Y6DK061575

This note should be able to help you

1017586 - ALV export: New TOP-OF-PAGE displayed after 60,000 lines

Regards,
Naimesh Patel

[former_member185167]

Thanks Naimesh, that looks promising. Pity that number is apparently hardcoded in!

I'll have a look.

regards

Rick