Question

AA Bot to read Excel cell, assign to a variable, then map variable to SAP field path?

  • 18 May 2022
  • 1 reply
  • 11 views

Hi,

 

I have a requirement for an SAP transaction (VK11) that prompts the user with various radio buttons, each corresponding to an SAP field path. For each radio button in SAP, I would like to assign text in excel. The user will then populate the text in the cell and AA would translate this to a variable linked to the SAP field path of the radio button.

 

In example, the user would enter "A670" in an excel cell. The bot will read the excel value, "A670", based on a variable set up, it will know "A670" is SAP field path XYZ. The bot will populate the SAP field path per the select radio button SAP action.

 

I'm looking for feedback on if this is 1) possible 2) if there's a better way to achieve this 3)any other feedback.

 

Thank you.


1 reply

Userlevel 4
Badge +8

Hello,

 

yes, you can achieve this, please use the same variable in 'HTML InnerText' and pass the value from excel cell.

 

If you have any questions please let me know.

 

Thank you,

Prabhakar Jha

Reply