topic Convert Internal table to Excel in Application Development and Automation Discussions

Convert Internal table to Excel

Former Member — Wed, 11 Apr 2012 15:29:52 GMT

Hi All ,

I have 28,44000 records in internal table . i want to download these number of records in excel .

I tried using the standard way in ALV downloading the list in spreadsheet but it is giving a dump "TSV_TNEW_BLOCKS_NO_ROLL_MEMORY" . I also tried using GUI_download FM but it is not downloading all the records in Excel .

I changed this rdisp/max_wprun_time parameter in RZ11 because the report was giving a dump of TSV_page_alloc_failed .

I think it can be possible by parallel processing but i am not sure how to do it .

Thanks ,

Nee.

Re: Convert Internal table to Excel

hugo_amo — Wed, 11 Apr 2012 15:41:47 GMT

Hi Nee,

The dump TSV_TNEW_BLOCKS_NO_ROLL_MEMORY usually means that the roll buffer has been exhausted.

Please check the usage of roll buffer with the following steps:

ST02 -> detail analysis menu -> history/buffer statistics -> Roll & page area

If the roll buffer has been exhausted, you can increase the size with parameter rdisp/ROLL_MAXFS, however make sure there are sufficient disk space to handle the additional size of this buffer if it writes to disk.

Please refer the following recommendation:

- to increase the parameters rdisp/PG_MAXFS it is described step by step in more detail by the note

#133909 maximum value for PG_MAXFS, PG_SHM, ROLL_MAXFS, ROLL_SHM

you could also increase your abap/heap_area_dia, abap/heap_area_nondia and ztta/roll_extension to 4GB abap/heap_area_total should be total of abap/heap_area_dia + abap/heap_area_nondia

Hope the information helps you.

Regards,

Hugo

Re: Convert Internal table to Excel

former_member585060 — Wed, 11 Apr 2012 15:42:29 GMT

Try to split the internal table content and send as an email excel attachment.

Re: Convert Internal table to Excel

former_member585060 — Wed, 11 Apr 2012 15:49:44 GMT

Before that try the below way.

from ALV output, Menu List>Export>Spreadsheet , select Excel MHTML format, from drop down first try with 2007 format, then with Excel (MHTML).

Re: Convert Internal table to Excel

Former Member — Wed, 11 Apr 2012 15:55:38 GMT

Why would anyone want to put that many records into a little desktop system like MS Office/Excel? Are you trying to transfer data to another system? If so, store a condensed, tab-delimited file on the Apps server and FTP it. Any system worth buying will import/export tab-delimited files. If you're really planning on doing analysis in Excel with that file, a sort might take a while...could start it on Monday morning and come back to it Tuesday afternoon?

Seriously, there are limits to the amount of data that can be transferred in one pass with GUI Download...I think it's around 32Mb, and there are limits, as you have seen, in how big tables and ther user context can grow in SAP. If you have to get this into that little desktop tool, store it as a condensed, tab-delimited file on the Apps server. FTP that .txt file to a network file where you have enough space to actually store it (maybe not), and where you can reach with the PC. Import the file into Excel, specifiying a tab-delimited file and wait....

Re: Convert Internal table to Excel

Former Member — Wed, 11 Apr 2012 16:14:56 GMT

Can you please tell me how to split the internal table and how can merge that in one Excel?

Re: Convert Internal table to Excel

former_member585060 — Thu, 12 Apr 2012 12:18:57 GMT

Hi,

Instead of downloading from ALV output, try once send as excel attachment and see. Check if you have the Class CL_SALV_TABLE available in your system. If available, it has a method TO_XML which can be used to convert the internal table data to XML format which can be used to create excel attachment.

Even for online display it might have taking time to display, better you execute in background and send the contents as excel attachment.

Add a check in program to count the table contents, if they are more than some specified limit convert to excel and send as email and display pop up with "Table contents more so sending as excel attachment". If the table contents are list display in on screen with ALV display.

Attaching a temp program.

Thanks & Regards

Bala Krishna

Re: Convert Internal table to Excel

Former Member — Thu, 12 Apr 2012 14:00:10 GMT

Hi David,

Thanks for the reply but can you please tell me how can i convert my file in tab delimited text files with UTF 8 or UTF 16 encoding? is there any Function module?

Regards,

Nee