SAP iRPA Pass value runtime to BAPI function

[ad0601]

Hello everyone,

I am calling BAPI using the bot. The BAPI is working successful and producing desired result. I am hard-coding the values as custom data in BAPI-Table parameter.

However, I would like to fill up table by getting values from an excel sheet and then pass further to BAPI. When I use excel cloud link, I am getting the values and when I use activities like below it is not working,

For each <returnedvalues> <---- from excel sheet
    [ BAPI table ]

How to add values in BAPI table from excel sheet? is there any other solution?

Regards,

ADR

[Ivan-Mirisola]

Hi ad0601,

If you are using the Desktop Studio to design the automation, you may download the following package and use it as a reference for your development:

Simple Purchase Requisition Creation from Excel using BAPI (SAP S/4HANA On-Premise 1709) (48M)

If you are using the Cloud Studio, you can mix the following two packages to find a solution to your problem:

How to use BAPI - Learning

Excel Best Practices - Learning

You can import packages directly on your iRPA Cockpit via menu Store --> find a package --> On the project's details you will find a GET button. This will enable you to add this package to an environment for testing. You can also download files related the the package as sample xls files, backend configuration, etc.

On the first package you will find a ZIP file containing the Desktop Studio project will all required code.

Best regards,
Ivan

[ad0601]

Hi,

I am using Cloud Studio. I can get excel data and also I can post BAPI (CREATE PR). Both are working properly independently. But when I try to get record and try to fill up Table data of BAPI, It's not working. How can populate BAPI table data using fetched excel data?

[Ivan-Mirisola]

Hi ad0601,

Could you please be more specific on what is not working. Could you please give more details on which data is being retrieved and which data is being populated, etc.?

Best regards,
Ivan