topic Re: Exporting to a local file using menu in Application Development and Automation Discussions

Exporting to a local file using menu

Former Member — Thu, 18 Sep 2008 04:55:08 GMT

Hi,

I have report that displays the data in an ALV so my client wants to export the output to local file using menu: List~~->Export~~-->Local File.

Currently i am using this FM to export directly to exel.

CALL FUNCTION 'WS_DOWNLOAD'

EXPORTING

bin_filesize = ' '

codepage = ' '

filename = 'C:\Shared.xls'

filetype = 'DAT'

TABLES

data_tab = i_tab.

Can anyone help me to export data to a local file using menu.

Regards,

Fred.

Re: Exporting to a local file using menu

Former Member — Thu, 18 Sep 2008 05:02:02 GMT

Hi Fred,

There is no need to use any function module for this requirement. As your report is a ALV report, you can use the standard toolbar of ALV for this purpose.

There is a Export button present on the toolbar.You can proceed this like this:

Export~~>Local File~~>spreadsheet(any from options)

So you can tell your client to use this export button in toolbar for downloading purpose.

Hope this solves yours problem.

Regards,

Brajvir

Re: Exporting to a local file using menu

Former Member — Thu, 18 Sep 2008 05:05:21 GMT

FM is not needed for downloading the report if you are using ALV report.

Check menu bar of ALV report. There is one button for downloading report.

Click that button -> Local file -> select 'spreadsheet' -> click 'Ok' -> Enter file name -> click 'Transfer'.

Regards,

Aparna Gaikwad

Re: Exporting to a local file using menu

Former Member — Thu, 18 Sep 2008 05:10:46 GMT

Hi Guys,

I have tried to use the buttons you suggested but it's giving me a dump: 'GETWA_NOT_ASSIGNED'. Is there something that i need to do again.

Regards,

Fred.

Re: Exporting to a local file using menu

Former Member — Thu, 18 Sep 2008 05:17:25 GMT

Hi,

Check the below link

[;

Regards,

Surinder