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.
cancel
Showing results for 
Search instead for 
Did you mean: 

Display records from database table

Former Member
0 Kudos

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

7 REPLIES 7

Former Member
0 Kudos

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

0 Kudos

Hi venkatesh,

I tried but, my version is ABAP 4.0B so it doesnot have many feature like ALV display options.

Moreover when I tried to run in background it said

"Immed. printing in background not poss. for printer LP01 (access method F)"

Regards,

DNP

0 Kudos

I think you might have to create a small utitlity program to download your data to server first and than read them back to your local drive.

In the way suggested by Venktesh, you will have the repetative headers after your page end. E.g. if you select 65_X_132, than you will have header after each 65 rows, and for 500K odd records those will be so many.

Regards,

Naimesh Patel

0 Kudos

Thanks for that suggestion it worked I was able to create a session. But the job cancelled due to process termination

Regards,

DNP

0 Kudos

I did it by writing a code to download the data in .txt

Regards,

DNP

0 Kudos

try to define the xls file....rather than txt file

Former Member
0 Kudos

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