Skip to Content
avatar image
Former Member

Display records from database table

My database table has 495K records i want to display them all in se11 tcode and than download into excel ...but because of huge records it timeout.

Do I need to write a program for this?

Or is there any other smarter way.

Regards,

DNP

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 15, 2008 at 04:06 PM

    Hi,

    Please follow the steps below:

    1. Go to the selection screen of SE11 and provide your selection criteria (if required).

    2. Click on Settings menu->User parameters->ALV Grid display.

    3. Now click on Program menu->Execute in background->Provide output device name as LP01 or LOCAL or any valid printer parameters->Click continue->Click Immediate button->Click Save.

    4. You can see the background job for this in SM37.

    5. Once the background job is completed, it will appear in gleen color.

    6. Click on the completed job and then click on Spool button.

    7. Once the output is displayed in spool you can now easily download it to excel by clicking on System menu->List->Save->Local File.

    Hope this will help you.

    Regards,

    Venkat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2008 at 04:38 PM

    Hi,

    Its not mandatory to user ALV grid, you can use simple SE16 view. you can use any acceptable printer parameters. press F4 on the output devices input box and select any printer name.

    Regards,

    Venkat

    Add comment
    10|10000 characters needed characters exceeded