File export problem

[Former Member]

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

[Former Member]

Hi

Check the

<b>CG3Y and

CG3Z</b>

transaction codes

Regards

Anji

[Former Member]

hI,

Try gui_upload and gui_download FMs

[Former Member]

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

[Former Member]

Hi

Solved myself. It can be done.

Regards

Vijai

[Former Member]

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.