Sending data in excel file from SAP to a shared folder of Virtual machine

[NaikMuddassir]

Hi,

I have a requirement where I need to send the data in excel to a shared folder of virtual machine and  RFC Connection to external system is also established but I’m unable to send the excel to that folder of virtual machine.

please help me if you have any solution for this. Thanks in advance.

Best Regards,                                                                  Naik

[Ryan-Crosby]

What have you tried thus far and what problems are you running into?

[NaikMuddassir]

I have tried to send using http_client interface methods and getting '405' http status code and method not allowed in response. Below is my code. let me know anything I can work on.

DATA: lt_binary_data TYPE TABLE OF x255,
lv_string TYPE string,
lv_len TYPE i.
DATA: lv_sjson TYPE string.
DATA: lr_data TYPE REF TO data.

CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'
EXPORTING
buffer = lv_content
IMPORTING
output_length = lv_length
TABLES
binary_tab = lt_binary_tab.

DATA(lv_json) = /ui2/cl_json=>serialize( data = lv_content
pretty_name = abap_true ).

DATA(rfc_mulesoft_dest) = 'RFC_Name'.
DATA : class_http_client TYPE REF TO if_http_client.

cl_http_client=>create_by_destination(
EXPORTING
destination = rfc_mulesoft_dest
IMPORTING
client = class_http_client
EXCEPTIONS
argument_not_found = 1
destination_not_found = 2
destination_no_authority = 3
plugin_not_active = 4
internal_error = 5
OTHERS = 6 ) .
IF sy-subrc <> 0.
ENDIF.
* Set HTTP request method and headers
DATA(value) = 'VMFolderName/' && lv_filename.
class_http_client->request->set_method( 'POST' ).
class_http_client->request->set_header_field( name = 'Content-Type' value = 'application/octet-stream' ).
class_http_client->request->set_header_field( name = 'File-Path' value = value ).

lv_sjson = lv_json.
class_http_client->request->set_cdata( lv_sjson ).

*--> Send the request
CALL METHOD class_http_client->send
EXPORTING
timeout = if_http_client=>co_timeout_infinite
EXCEPTIONS
http_communication_failure = 1
http_invalid_state = 2
http_processing_failed = 3
http_invalid_timeout = 4
OTHERS = 5.
IF sy-subrc <> 0.
ENDIF.

*--> Get the response back
CALL METHOD class_http_client->receive
EXCEPTIONS
http_communication_failure = 1
http_invalid_state = 2
http_processing_failed = 3
OTHERS = 4.
IF sy-subrc NE 0.
http_status = class_http_client->response->get_header_field( '~status_code' ).
http_response = class_http_client->response->get_header_field( '~status_reason' ).
ENDIF.

[NaikMuddassir]

Please help me on this.

[Ryan-Crosby]

HTTP 405 means the server is not accepting a POST method call.

[NaikMuddassir]

Any Alternate solution to transfer the excel file from sap other than POST method?

[Ryan-Crosby]

You would need to check on the setup with whomever manages the destination set to receive the content, which based on the information you supplied would be folks that handle Mulesoft.

[kerawill1122]

To send data in an Excel file from SAP to a shared folder on a virtual machine, you can try the following approach:

1. Ensure Network Accessibility: First, make sure that the virtual machine’s shared folder is accessible from the SAP system. Check network connectivity and permissions.

2. Use SAP Function Modules for File Handling: You can use SAP function modules like GUI_UPLOAD or OPEN_DATA to handle Excel file data, but to write to a shared network location, consider using a different approach.

3. Use the FTP or SMB Protocol: If the virtual machine is configured to allow FTP or SMB (Windows file sharing), you can use function modules like FTP_CONNECT, FTP_COMMAND to send the file. Ensure the destination folder is accessible with the correct credentials.

4. Check User Permissions: Make sure the SAP system has the required access rights to write files to the shared folder. This may involve setting up proper credentials for SAP to access the virtual machine.

5. Background Job or Process: For automation, you can set up a background job in SAP to periodically export the Excel file and move it to the shared folder using FTP or network paths.

6. Verify the RFC Connection: Since you already have an RFC connection established, ensure it is functioning properly. Sometimes, issues with network settings or misconfigured parameters can block file transfers.