HHow to execute SAP BAPIs, manipulate transactions and manage an SFTP server with UiPath?

Help Studio
1

Hello,

I have several questions regarding the integration of SAP and SFTP with UiPath Studio:

:small_blue_diamond: 1. SAP Integration with UiPath

How do I integrate SAP Logon with UiPath Studio to execute BAPIs?
How do I retrieve the outputs of an SAP transaction (e.g., ETA)?
How do I populate an SAP transaction in the background, i.e., without opening SAP Logon?
What is the best approach for manipulating SAP with UiPath without UI Automation, i.e., via a technical connection or RFC?
Is it possible to use SQL queries with SAP from UiPath? If so, how?

:small_blue_diamond: 2. Connecting UiPath to the SFTP Server

How do I establish an SFTP connection from UiPath Studio?
How do I access a specific directory on the server?
How do I upload a file to this directory via UiPath?
And finally, how do I execute a file stored on the SFTP server (if that’s even possible)?

Thank you in advance for your help!

2

Hi @aya_lajili3

SAP:

  • Use UiPath SAP Activities + Invoke BAPI for background execution
  • Get outputs from BAPI/RFC output parameters
  • Transactions (T-codes) cannot run without SAP GUI
  • Best non-UI options: BAPI, RFC, OData, IDocs
  • SQL on SAP only via approved DB access or custom RFC

SFTP:

  • Use SFTP Scope from UiPath.System.Activities
  • Set RemotePath to access folders
  • Upload files using Upload Files activity
  • Files on SFTP cannot be executed directly
3

@aya_lajili3

Please check below

SAP

SFTP - Execute on sftp directly is no possible, but all other operations can be achieved

cheers

4
  • UiPath supports executing SAP BAPIs via the SAP BAPI connector and Execute BAPI activity, including retrieving inputs/outputs dynamically as the documentation shows.
  • SAP BAPI authentication setup steps are detailed in UiPath docs.
  • Automating SAP BAPIs with UiPath Studio
  • Other forum threads show how BAPI names and parameters are mapped in Studio for real SAP objects.
  • For SFTP, UiPath has SFTP activities that allow connecting to servers and file transfer, although remote execution would typically require separate capabilities (e.g., shell/SSH).