Extract Raw Table Data into Excel format

[Former Member]

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

DV

[Former Member]

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

[Former Member]

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....