Which is the better way in SAP Automation?

Hello Folks,

I need to enter the data into the SAP Application(tabular format cell by cell) from an excel table. Which is the most suitable and fast method in the following,

  1. Using SAP BAPI(If so please explain the reason)
  2. Enabling SAP Script and performing UI Automation.
  3. Using the built in SAP scripting to record the actions that will help to replicate the
    steps into the UiPath workflow.

Thanks.

@LevKushnir
Could you give me a suggestion?

Definitely BAPI is the fastest and reliable method since you are making changes to SAP fields/tables through API requests.

1 Like

Hey @Benone.Samuel.India

Could you please explain how it can be done, helps if you upload any sample. Is it a free API?, if so how can i pass the excel data like an argument to API.

Thanks.

hi @GouthamVijay

1 BAPI Automation

In case we are speaking about huge amount (100, 1000, 10000) of data, I would suggest to use SAP BAPI, check this documentation https://docs.uipath.com/activities/docs/about-the-sap-bapi-activities-pack

To make the life of user easier, my colleague @Akihiro_Nishimoto with his team developed so called UiPath reusable components for SAP, check this page: https://connect.uipath.com/community/profile/akihiro-nishimoto-1ddfdb/components

There are a lot of predefined and prebuild templates and workflows which will help you to work with huge amount of data. SAP ECC and SAP S/4 HANA are covered

2 UI Automation
In case you have an excel list just with a few lines or BAPI is not available for your use case. SAP WinGUI automation is a great way how to read the data from Excel and enter them into SAP. You have to enable SAP GUI scripting https://docs.uipath.com/studio/v2020.4/docs/sap-configuration-steps

3 Third option - is not just bad :slight_smile: there are no reasons to combine SAP built-in scripts with UiPath.
The whole flow can be done with UiPath only.
The less tools you are using for automation, the less maintenance issues you have. Just stick to UiPath Studio, which is covering all use cases. See above Point 1 and Point 2.

Best regards, Lev

1 Like

Great @LevKushnir

Data to fill in SAP Application is less, i have used UiAutomation before by enabling the script on Server. This time I am planning to make the data filling process inside SAP through background , so i posted this question to get a gist.

Thanks for your detailed explanation, helps a lot to my project.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.