09-15-2008 4:52 PM
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
09-15-2008 5: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
09-15-2008 5:27 PM
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
09-15-2008 5:51 PM
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
09-15-2008 6:18 PM
Thanks for that suggestion it worked I was able to create a session. But the job cancelled due to process termination
Regards,
DNP
09-26-2008 7:48 PM
I did it by writing a code to download the data in .txt
Regards,
DNP
09-26-2008 7:50 PM
09-15-2008 5: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