Skip to Content
0
May 29, 2013 at 06:40 AM

How to read the excel data from ftp through abap Program

642 Views

Dear All,

How to read the excel data which is present in FTP server through ABAP program. I followed few methods but its not happening pls help me.

Here i'm putting the data what i followed.

1) using FM "FTP_SERVER_TO_R3" passing data and file name i'm passing as aba.xls , then it is showing in alpha-numeric characters (Ï#ࡱ#á################>###þÿ##################,#########) if the table format is text and if change the table format also coming same.

2) If suppose i'm downloading the data from SAP byusing the below structure

Ex :

BEGIN OF ST_CUS,

LEDGERKEY(50) TYPE C, "LedgerKey

WRK_DELIM1 TYPE X ,

NAME1(80) TYPE C, "AccountName

WRK_DELIM2 TYPE X ,

KUNNR(50) TYPE C, "AccountReference

WRK_DELIM3 TYPE X ,

end of xxx.

and same data i'm uploading that time it is taking. but if i'm giving external excel file then why its not taking.

which file format it will support. i'm not finding the documentation of the FM & definition of method also.

Regards,

Krishna