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

[ad0601]

ivan.mirisola yes sure.

I am getting data from an excel sheet to create PR as below:

I am getting data in returnedValues (output parameter)

After this I want to run a FOR EACH loop around returedValues and fill up BAPI table data Table_PR:

Now, I am hard coding the values since it is not able to find FOR EACH loop current member. So my excel returnedValues is of no use.

My table structure is:

capture2.png

I want to do:

For each (returnedValues)

append current member to Table_PR one by one.

This is not working.

So, how can i fill up the Table_PR?

Thanks in advance,

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