topic Extract Raw Table Data into Excel format in Application Development and Automation Discussions

Extract Raw Table Data into Excel format

Former Member — Wed, 16 May 2012 18:04:55 GMT

Hello Gurus

I have a table with 107 fields that I need to extract data into excel sheet. There are around 7.2M records but it dumps due to memory issue for 15k records since everything is being run in the front end. In this process I need to do the extraction atleast couple of hundred times to get the 7.2M records. I know that this is not at all an ideal solution as I have to perform this task on a production system. I greatly appreciate if you guys could let me know the best possible way to extract the whole dump of the data from any SAP table in the back-end mode without running into the memory issue.

Thanks

Re: Extract Raw Table Data into Excel format

Former Member — Wed, 16 May 2012 18:19:37 GMT

7.2 million records - each with 107 fields.

Do you think Excel can handle this at one go?

Create a file on the application server and then process it (FTP or whatever).

Rob

Re: Extract Raw Table Data into Excel format

Former Member — Wed, 16 May 2012 18:25:21 GMT

Thanks Rob..thats what I even anticipated but I would appreciate if you could let me know the process to do that...since...I have to take care of this...even though I have support...it would be too late by the time I get the extracts....