topic Re: Excel download functionality in Table maintenance generator in Application Development and Automation Discussions

Excel download functionality in Table maintenance generator

Former Member — Tue, 13 May 2008 03:02:56 GMT

Hi Friends,

I have a requirement.

I have to create a custom table and should have a table maintenance for that.

I can do this via table maintenance generator.

But after creating this, in the maintenance screen, i should have a button. On clicking the button, a popup should ask for excel file name and after specifying the file name all the data in the maintenance screen has to get downloaded to a excel file.

So, my idea to implement is, change the code generated by table maintenance generator, to accomplish this.

In the menu painter, create a button. and have a ok code for that.

In the screen painter, design a screen with filename field and have a ok button. Accept the filename input and close the screen and then for that ok code in the PAI module, use GUI_DOWNLOAD function to download the excel file to the specified location.

Please review this and please let me know if there is any alternative solution for this requirement.

Thanks,

Jaffer Ali.S

Re: Excel download functionality in Table maintenance generator

Former Member — Tue, 13 May 2008 04:01:26 GMT

Hi,

After maintaining table maintenence generator maintain one push button in pai of the table program .

in that when 'download'.

call function module f4_filename it will ask file name enter that value.

after using gui_download you can down load to excel file.

To download from SAP to Excel:

Transaction SE16N allows you to access any sap table and download result to Excel

no other alternative for this.

*reward points if usefull

Re: Excel download functionality in Table maintenance generator

Former Member — Tue, 13 May 2008 04:15:03 GMT

Hi,

In se11----~~> TMG~~--

>double click on screen

A module pool pgm is open for that screen.

in that in PAI event, create one module and write the code.

create push button for that,

or else write code under POV,

call FM : f4_filename.

use fm ": gui_download.

Rgds

Umakanth