Problem with FTP_R3_TO_SERVER function module while downloading excel sheet in background

[pbabitha]

Hi All,

I have created a zreport to download equipment details into excel sheet while running background.I have used the following function modules to download excel file into FTP path

HTTP_SCRAMBLE

FTP_CONNECT

FTP_R3_TO_SERVER

FTP_DISCONNECT

RFC_CONNECTION_CLOSE

But it is downloading internal table row into single cell and also when i try to download multiple rows it is not downloading correct data. I have passed blob_length as 122 * 30 and blob as internal table.

Please help me out to solve this issue as it is an urgent requirement.

Thanks & Regards,

Babitha

[Tomas_Buryanek]

1) I think you are not creating "Excel sheet" but simple text file? Is it tab delimited, or CSV, or...?

2) I recommend to use FTP_R3_TO_SERVER in its binary (default) mode. I.E. work with binary data. And every time you work with binary data in internal table (BLOB), you need to know its size (fill it into BLOB_LENGTH parameter).

[pbabitha]

Thanks Tomas,

I have made it as tab delimited file and it got successfully downloaded into text file and i am working on excel file download following your points.

Regards,

Babitha

[srikanthnalluri]

Check the standard program - RSFTP007, it may help you.