FTP in background

[Former Member]

Hi freinds,

I have a requirement, where data needs to be download to an ftp server hourly basis. So i have written a programs and used to ftp the text file in to FTP server.

My issue the ftp programs is working fine in the foreground, but it is not working in background. What do I have to do. With here I am attaching the FTP part pf the program which I used.

Pls help on this, thanks in advance

Regards

Thanura

LINE(132) TYPE C,

END OF MTAB_DATA.

DATA: MC_PASSWORD(20) TYPE C,

MI_KEY TYPE I VALUE 26101957,

MI_PWD_LEN TYPE I,

MI_HANDLE TYPE I.

MC_PASSWORD = 'password'.

DESCRIBE FIELD MC_PASSWORD LENGTH MI_PWD_LEN IN CHARACTER MODE.

*-- FTP_CONNECT requires an encrypted password to work

CALL 'AB_RFC_X_SCRAMBLE_STRING'

ID 'SOURCE' FIELD MC_PASSWORD ID 'KEY' FIELD MI_KEY

ID 'SCR' FIELD 'X' ID 'DESTINATION' FIELD MC_PASSWORD

ID 'DSTLEN' FIELD MI_PWD_LEN.

CALL FUNCTION 'FTP_CONNECT'

EXPORTING

USER = 'thanura'

PASSWORD = MC_PASSWORD

HOST = <server ip>'

RFC_DESTINATION = 'SAPFTP'

IMPORTING

HANDLE = MI_HANDLE

EXCEPTIONS

NOT_CONNECTED = 1

OTHERS = 2.

CHECK SY-SUBRC = 0.

CALL FUNCTION 'FTP_COMMAND'

EXPORTING

HANDLE = MI_HANDLE

COMMAND = 'cd /usr/sap/dbi/'

TABLES

DATA = MTAB_DATA

EXCEPTIONS

TCPIP_ERROR = 1

COMMAND_ERROR = 2

DATA_ERROR = 3

OTHERS = 4.

CALL FUNCTION 'FTP_COMMAND'

EXPORTING

HANDLE = MI_HANDLE

COMMAND = <get the file>

TABLES

DATA = MTAB_DATA

EXCEPTIONS

TCPIP_ERROR = 1

COMMAND_ERROR = 2

DATA_ERROR = 3

OTHERS = 4.

CALL FUNCTION 'FTP_DISCONNECT'

EXPORTING

HANDLE = MI_HANDLE

EXCEPTIONS

OTHERS = 1.

[Former Member]

Hi freinds,

I have a requirement, where data needs to be download to an ftp server hourly basis. So i have written a programs and used to ftp the text file in to FTP server.

My issue the ftp programs is working fine in the foreground, but it is not working in background. What do I have to do. With here I am attaching the FTP part pf the program which I used.

Pls help on this, thanks in advance

Regards

Thanura

LINE(132) TYPE C,

END OF MTAB_DATA.

DATA: MC_PASSWORD(20) TYPE C,

MI_KEY TYPE I VALUE 26101957,

MI_PWD_LEN TYPE I,

MI_HANDLE TYPE I.

MC_PASSWORD = 'password'.

DESCRIBE FIELD MC_PASSWORD LENGTH MI_PWD_LEN IN CHARACTER MODE.

*-- FTP_CONNECT requires an encrypted password to work

CALL 'AB_RFC_X_SCRAMBLE_STRING'

ID 'SOURCE' FIELD MC_PASSWORD ID 'KEY' FIELD MI_KEY

ID 'SCR' FIELD 'X' ID 'DESTINATION' FIELD MC_PASSWORD

ID 'DSTLEN' FIELD MI_PWD_LEN.

CALL FUNCTION 'FTP_CONNECT'

EXPORTING

USER = 'thanura'

PASSWORD = MC_PASSWORD

HOST = <server ip>'

RFC_DESTINATION = 'SAPFTP'

IMPORTING

HANDLE = MI_HANDLE

EXCEPTIONS

NOT_CONNECTED = 1

OTHERS = 2.

CHECK SY-SUBRC = 0.

CALL FUNCTION 'FTP_COMMAND'

EXPORTING

HANDLE = MI_HANDLE

COMMAND = 'cd /usr/sap/dbi/'

TABLES

DATA = MTAB_DATA

EXCEPTIONS

TCPIP_ERROR = 1

COMMAND_ERROR = 2

DATA_ERROR = 3

OTHERS = 4.

CALL FUNCTION 'FTP_COMMAND'

EXPORTING

HANDLE = MI_HANDLE

COMMAND = <get the file>

TABLES

DATA = MTAB_DATA

EXCEPTIONS

TCPIP_ERROR = 1

COMMAND_ERROR = 2

DATA_ERROR = 3

OTHERS = 4.

CALL FUNCTION 'FTP_DISCONNECT'

EXPORTING

HANDLE = MI_HANDLE

EXCEPTIONS

OTHERS = 1.

[RaymondGiuseppi]

Use destination SAPFTPA

<i>SAPFTP utilizes ftp from the desptop gui and SAPFTPA uses ftp from the application server. Since your job is running in the background SAPFTP would not work as there is no connection of a background job to the desktop gui. If you were to run your program in the foreground then SAPFTP would work.</i>

Look at OSS <a href="https://service.sap.com/sap/support/notes/93042">Note 93042 - Problems with SAPFTP</a>

Regards

[amolnamjoshi_1]

Please give a solution to my foreground job working and I added in logic SAPFTA also but file not transferring background working but file not transfer to FileZilla FTP.

93042 - Problems with SAP FTP whether its will works if I implement SAP note 93042 for background job.

[Former Member]

For backgroud FTP we have SAPFTPA as RFC destination..

Use that..

Regards

Prax