topic Re: Export Abap Report to Excel .CSV Format in Application Development and Automation Discussions

Export Abap Report to Excel .CSV Format

Former Member — Mon, 26 Aug 2013 06:09:16 GMT

Dear All,

I have a requirement to download the SAP report to Excel .CSV Format . I am using FM 'SAP_CONVERT_TO_CSV_FORMAT' and FM '

GUI_DOWNLOAD' to download the file to .csv format. The problem i am facing is the file is downloaded to excel .csv format but all the values are present in single column . Eg. Field1 , Filed 2 ..... all are present in the A1 Cell i.e present in the single Column . I want the data to be displayed in separate columns . Eg. Field1 in a1 Cell , Field2 in B1 Cell ......etc.

Could anyone please show me a way around this.

Regards

Amba

Re: Export Abap Report to Excel .CSV Format

Former Member — Mon, 26 Aug 2013 08:15:13 GMT

Hi ,

If you use GUI_DOWNLOAD for downloading Excel .CSV Format, then pass

WRITE_FIELD_SEPARATOR = ' ' and FILETYPE = 'DBF' for leading with zero's.

Note : Suppose field1 = material number

if you use file type ='DBF' then material number download leading with zero's.

'000000000000001698' .

Regard's

Smruti

Re: Export Abap Report to Excel .CSV Format

Former Member — Mon, 26 Aug 2013 08:37:52 GMT

Hi Smruti,

Thank u for the answer ... My Problem resloved....I am getting the values to be displayed in each column ...

I am getting the column heading as F1,F2,F3......

How to change it my requirement heading as Date , Doc. No........

Could u please show me a way around this.

Regards

Amba

Re: Export Abap Report to Excel .CSV Format

SujeetMishra — Mon, 26 Aug 2013 08:49:43 GMT

Hi,

Re: Export Abap Report to Excel .CSV Format

Former Member — Mon, 26 Aug 2013 11:37:13 GMT

Now Pass WA_MAKT1 TO FIELDNAMES In GUI_DOWNLOAD FM.

Out_Put:

Regard's

Smruti

Re: Export Abap Report to Excel .CSV Format

Former Member — Thu, 05 Sep 2013 05:59:07 GMT

Hi Smruti,

Thank u very much ... The problem is resolved ... I did as per ur steps ....Once again thank u .

Regards ,

Amba