topic Re: Export an ALV into .CSV in Application Development and Automation Discussions

Export an ALV into .CSV

Former Member — Wed, 23 May 2012 09:06:01 GMT

Hi Expert,

I have a specific program that generate an ALV

I have to basic SAP functionality to export the data in this program

My question is how can I export the data directly to .CSV format ? (without passing through any new developpment)

Is their any customizing possible to change the export parameters ?

Thanks in advance

Re: Export an ALV into .CSV

former_member282968 — Wed, 23 May 2012 13:37:08 GMT

Dear Nazim,

In the ALV report use (ctrl+shift+f9)->it will ask "In which format should the list
be saved ?" ---> select spread sheet and give the filename with the extenstion as CSV. When generate-> It will generate the CSV file in the directory mentioned.

With regards,

Re: Export an ALV into .CSV

Former Member — Wed, 23 May 2012 14:47:00 GMT

Hi Naveen

The CSV file is "comma separated" which doesn't correspond to the extraction to spreadsheet (even if you change the extension to .csv).

In fact, the CSV file is a .txt file with ";" separator

when you extract the ALV in SAP in .txt, it put the "|" separtor which does'nt correspond to .csv

Regards