Skip to Content
avatar image
Former Member

Excel download from SE16 - titles every 60,000 rows

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 17, 2015 at 09:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded