Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Download classical report output to an excel file

Hi all,

I want to download the output of classical report to an excel file. I have used the following function:

CONCATENATE 'e:\' 'sap.txt' INTO fna.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = fna

FILETYPE = 'ASC'

tables

data_tab = it_final.

IF sy-subrc = 0.

  • MESSAGE s005 with fna.

ENDIF.

now this function is coverting the output into a normal text file in a notepad.. When I give the file type as 'XLS', it gives an error saying that the value of parameter filetype is not correct.

please tell me about what can be the possible method for fulfilling my requirement

Regards,

Nikita

Tags:
replied

HI,

Give the file name as SAP.xls not SAP.txt.

Give FILETYPE = 'ASC'.

Regards

Sumit Agarwal

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question