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

[Former Member]

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]

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]

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

[Clemenss]

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

Regards,

Clemens