topic Re: Display records from database table in Application Development and Automation Discussions

Display records from database table

Former Member — Mon, 15 Sep 2008 15:52:29 GMT

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

Re: Display records from database table

Former Member — Mon, 15 Sep 2008 16:06:18 GMT

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

Re: Display records from database table

Former Member — Mon, 15 Sep 2008 16:27:12 GMT

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

Re: Display records from database table

Former Member — Mon, 15 Sep 2008 16:38:24 GMT

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

Re: Display records from database table

naimesh_patel — Mon, 15 Sep 2008 16:51:42 GMT

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

Re: Display records from database table

Former Member — Mon, 15 Sep 2008 17:18:03 GMT

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

Regards,

DNP

Re: Display records from database table

Former Member — Fri, 26 Sep 2008 18:48:25 GMT

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

Regards,

DNP

Re: Display records from database table

BH2408 — Fri, 26 Sep 2008 18:50:17 GMT

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