https://community.sap.com/t5/application-development-and-automation-discussions/ftp-sub-command-error-in-ftp-r3-to-server-in-program/m-p/12089723#M1971671 <P>Hello Experts,</P> <P>I am getting FTP Sub command Error while using FM : FTP_R3_TO_SERVER.</P> <P>I have also maintained table : SXPGCOSTAB and SAPFTP_SERVERS.</P> <P>Please suggest.</P> <P>Find below code :</P> <P>* get the hexa decimal password<BR /> CALL FUNCTION 'HTTP_SCRAMBLE'<BR /> EXPORTING<BR /> SOURCE = lv_pass<BR /> SOURCELEN = LV_PWD_LEN<BR /> KEY = LC_KEY<BR /> IMPORTING<BR /> DESTINATION = LV_PASS.</P> <P>* connect to FTP server<BR /> CALL FUNCTION 'FTP_CONNECT'<BR /> EXPORTING<BR /> USER = lv_uname<BR /> PASSWORD = LV_PASS<BR /> HOST = lv_IP<BR /> RFC_DESTINATION = LC_RFC_DEST<BR /> IMPORTING<BR /> HANDLE = LV_HANDLE.<BR /> <BR /> * passive On<BR /> CALL FUNCTION 'FTP_COMMAND'<BR /> EXPORTING<BR /> HANDLE = LV_HANDLE<BR /> COMMAND = 'set passive on'<BR /> TABLES<BR /> DATA = LI_RESULT<BR /> EXCEPTIONS<BR /> TCPIP_ERROR = 1<BR /> COMMAND_ERROR = 2<BR /> DATA_ERROR = 3.<BR /> <BR /> REFRESH LI_RESULT.</P> <P>CALL FUNCTION 'FTP_COMMAND'<BR /> EXPORTING<BR /> HANDLE = LV_HANDLE<BR /> * COMMAND = 'ascii'<BR /> COMMAND = 'dir'<BR /> TABLES<BR /> DATA = LI_RESULT<BR /> EXCEPTIONS<BR /> TCPIP_ERROR = 1<BR /> COMMAND_ERROR = 2<BR /> DATA_ERROR = 3.<BR /> <BR /> lv_date = sy-datum - 1.<BR /> CONCATENATE 'SalesOps_inventory_data_' lv_date(4) '_' lv_date+4(2) '_' lv_date+6(2) '.csv' into lv_filename.<BR /> * Transfer data in internal table li_data to FTP<BR /> <BR /> DATA: lv_blob_length TYPE i.<BR /> <BR /> lv_blob_length = '16384'.<BR /> <BR /> <BR /> CALL FUNCTION 'FTP_R3_TO_SERVER'<BR /> EXPORTING<BR /> HANDLE = LV_HANDLE<BR /> FNAME = lv_filename<BR /> blob_length = lv_blob_length<BR /> CHARACTER_MODE = 'X'<BR /> TABLES<BR /> TEXT = GT_FINAL_FTP<BR /> EXCEPTIONS<BR /> TCPIP_ERROR = 1<BR /> COMMAND_ERROR = 2<BR /> DATA_ERROR = 3<BR /> OTHERS = 4.<BR /> IF sy-SUBRC is not INITIAL.<BR /> MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno<BR /> WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.<BR /> ENDIF.<BR /> <BR /> * Disconnect the FTP connection<BR /> CALL FUNCTION 'FTP_DISCONNECT'<BR /> EXPORTING<BR /> HANDLE = LV_HANDLE.<BR /> <BR /> * Disconnect the RFC connection between SAP and FTP.<BR /> CALL FUNCTION 'RFC_CONNECTION_CLOSE'<BR /> EXPORTING<BR /> DESTINATION = LC_RFC_DEST<BR /> EXCEPTIONS<BR /> OTHERS = 1.</P> Wed, 06 Nov 2019 07:11:23 GMT toshitjawale 2019-11-06T07:11:23Z https://community.sap.com/t5/application-development-and-automation-discussions/ftp-sub-command-error-in-ftp-r3-to-server-in-program/m-p/12089723#M1971671 <P>Hello Experts,</P> <P>I am getting FTP Sub command Error while using FM : FTP_R3_TO_SERVER.</P> <P>I have also maintained table : SXPGCOSTAB and SAPFTP_SERVERS.</P> <P>Please suggest.</P> <P>Find below code :</P> <P>* get the hexa decimal password<BR /> CALL FUNCTION 'HTTP_SCRAMBLE'<BR /> EXPORTING<BR /> SOURCE = lv_pass<BR /> SOURCELEN = LV_PWD_LEN<BR /> KEY = LC_KEY<BR /> IMPORTING<BR /> DESTINATION = LV_PASS.</P> <P>* connect to FTP server<BR /> CALL FUNCTION 'FTP_CONNECT'<BR /> EXPORTING<BR /> USER = lv_uname<BR /> PASSWORD = LV_PASS<BR /> HOST = lv_IP<BR /> RFC_DESTINATION = LC_RFC_DEST<BR /> IMPORTING<BR /> HANDLE = LV_HANDLE.<BR /> <BR /> * passive On<BR /> CALL FUNCTION 'FTP_COMMAND'<BR /> EXPORTING<BR /> HANDLE = LV_HANDLE<BR /> COMMAND = 'set passive on'<BR /> TABLES<BR /> DATA = LI_RESULT<BR /> EXCEPTIONS<BR /> TCPIP_ERROR = 1<BR /> COMMAND_ERROR = 2<BR /> DATA_ERROR = 3.<BR /> <BR /> REFRESH LI_RESULT.</P> <P>CALL FUNCTION 'FTP_COMMAND'<BR /> EXPORTING<BR /> HANDLE = LV_HANDLE<BR /> * COMMAND = 'ascii'<BR /> COMMAND = 'dir'<BR /> TABLES<BR /> DATA = LI_RESULT<BR /> EXCEPTIONS<BR /> TCPIP_ERROR = 1<BR /> COMMAND_ERROR = 2<BR /> DATA_ERROR = 3.<BR /> <BR /> lv_date = sy-datum - 1.<BR /> CONCATENATE 'SalesOps_inventory_data_' lv_date(4) '_' lv_date+4(2) '_' lv_date+6(2) '.csv' into lv_filename.<BR /> * Transfer data in internal table li_data to FTP<BR /> <BR /> DATA: lv_blob_length TYPE i.<BR /> <BR /> lv_blob_length = '16384'.<BR /> <BR /> <BR /> CALL FUNCTION 'FTP_R3_TO_SERVER'<BR /> EXPORTING<BR /> HANDLE = LV_HANDLE<BR /> FNAME = lv_filename<BR /> blob_length = lv_blob_length<BR /> CHARACTER_MODE = 'X'<BR /> TABLES<BR /> TEXT = GT_FINAL_FTP<BR /> EXCEPTIONS<BR /> TCPIP_ERROR = 1<BR /> COMMAND_ERROR = 2<BR /> DATA_ERROR = 3<BR /> OTHERS = 4.<BR /> IF sy-SUBRC is not INITIAL.<BR /> MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno<BR /> WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.<BR /> ENDIF.<BR /> <BR /> * Disconnect the FTP connection<BR /> CALL FUNCTION 'FTP_DISCONNECT'<BR /> EXPORTING<BR /> HANDLE = LV_HANDLE.<BR /> <BR /> * Disconnect the RFC connection between SAP and FTP.<BR /> CALL FUNCTION 'RFC_CONNECTION_CLOSE'<BR /> EXPORTING<BR /> DESTINATION = LC_RFC_DEST<BR /> EXCEPTIONS<BR /> OTHERS = 1.</P> Wed, 06 Nov 2019 07:11:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ftp-sub-command-error-in-ftp-r3-to-server-in-program/m-p/12089723#M1971671 toshitjawale 2019-11-06T07:11:23Z https://community.sap.com/t5/application-development-and-automation-discussions/ftp-sub-command-error-in-ftp-r3-to-server-in-program/m-p/12089724#M1971672 <P>SY-SUBRC = 2? What message do you get?</P> Wed, 06 Nov 2019 08:10:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ftp-sub-command-error-in-ftp-r3-to-server-in-program/m-p/12089724#M1971672 Sandra_Rossi 2019-11-06T08:10:46Z https://community.sap.com/t5/application-development-and-automation-discussions/ftp-sub-command-error-in-ftp-r3-to-server-in-program/m-p/12089725#M1971673 <P>Yes , Sy-subrc = 2 .Which is</P><P>COMMAND_ERROR = 2</P> Wed, 06 Nov 2019 09:26:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/ftp-sub-command-error-in-ftp-r3-to-server-in-program/m-p/12089725#M1971673 toshitjawale 2019-11-06T09:26:20Z