topic Re: .csv files from network path to SAP application server using FTP in Application Development and Automation Discussions

.csv files from network path to SAP application server using FTP

Former Member — Fri, 13 Nov 2009 11:44:00 GMT

Hi All,

Can Any one tell me how to get the .csv files from external location path and store it into the internal tables.

This should be run as a Background job.

I tried with creating RFC destination and read the file. But i need it with FTP.

I need to read the file from external system having shared folder. External system not in same network.

Is it possible to make with FTP and can u tell me the steps to achieve?

Former Member — Sun, 15 Nov 2009 19:27:43 GMT

Hello,

Of course this can be done with FTP.

Have a look at SE37 at the function modules that start with FTP_

Normally I use this sequence.

FTP_CONNECT

FTP_COMMAND (multiple times)

FTP_DISCONNECT

Use SE37 to see what parameters the different function modules use.

Once the file is on your application server you can use OPEN DATASET and READ DATASET statements to get the data in an internal table.

Success !

Wim

former_member156446 — Sun, 15 Nov 2009 21:59:08 GMT

Check this link>>[File/FTP Adapter|http://help.sap.com/saphelp_nw04/Helpdata/EN/0b/9a50465ccf84479e39a6d50c90fb3f/content.htm]

Clemenss — Sun, 29 Nov 2009 15:56:35 GMT

... But be aware that for ftp you need an ftp server. The rest ist easy done by a quick SEARCH.

Regards,

Clemens