topic File export problem in Application Development and Automation Discussions

File export problem

Former Member — Sun, 14 Oct 2007 10:16:09 GMT

Dear All

I need to export data to a file share location in XL format. I have the data in an internal table. This file share is on another location(network directory).

I also wish to import it when needed.

How can I do it. Please guide me.

Regards

Vijai

Re: File export problem

Former Member — Sun, 14 Oct 2007 10:47:27 GMT

Check the

<b>CG3Y and

CG3Z</b>

transaction codes

Regards

Anji

Re: File export problem

Former Member — Sun, 14 Oct 2007 12:13:03 GMT

hI,

Try gui_upload and gui_download FMs

Re: File export problem

Former Member — Sun, 14 Oct 2007 13:48:22 GMT

Hi Vijai,

In order to save the data on to some file onthe Application server(Network directory),use the keywords Open Dataset,Transfer and Close Dataset in your report which would transfer the data from the internal table to the file on the Application server.

Once the file has the data in the file n the T-code AL11(Application server),use the T-code CG3Y to transfer the data from the Application server to the Presentation server in the Excel format.

Use the T-code CG3Z to transfer the data from the Presentation server to the Application server.

In case you have any further clarifications,do let me know.

Regards,

Puneet Jhari.

Re: File export problem

Former Member — Mon, 15 Oct 2007 02:22:25 GMT

Can I download file using GUI_DOWNLOAD on a network location like
new_system\new_directory.

Re: File export problem

Former Member — Wed, 01 Oct 2008 06:30:47 GMT

Solved myself. It can be done.

Regards

Vijai