Skip to Content
1
Jul 01, 2020 at 08:31 AM

fill forms in S4/ HANA Cloud automatically based on data in an Excel Sheet using VBA

106 Views

Hi All,

I am trying to fill forms in S4/ HANA Cloud automatically based on data in an Excel Sheet using VBA.

On most website I would right click on a field or a button to identify the Field or Button ID and then either set the value for a field and then Click to submit the form for example.

The button I need to click on shows the following: id="YY1_XCGLTWLMNVK::sap.suite.ui.generic.template.ListReport.view.ListReport::YY1_GROUPACCOUNT--addEntry-content"

My VBA code should be:

.getElementById("YY1_XCGLTWLMNVK::sap.suite.ui.generic.template.ListReport.view.ListReport::YY1_GROUPACCOUNT--addEntry-content").Click

I tried

.getElementById("YY1_GROUPACCOUNT--addEntry-content").Click

One of the fields I need to fill shows:

id="YY1_XCGLTWLMNVK::sap.suite.ui.generic.template.ObjectPage.view.Details::YY1_GROUPACCOUNT--GROUPACCOUNTGeneralInformation::GroupID::Field-input-inner")

My VBA code should be:

.getElementById("YY1_XCGLTWLMNVK::sap.suite.ui.generic.template.ObjectPage.view.Details::YY1_GROUPACCOUNT--GROUPACCOUNTGeneralInformation::GroupID::Field-input-inner").Value = "GroupID"

Is there anywhere where I can find resources to help me script the way to fill in forms on S4 /HANA Cloud?

In older version of SAP Client I was able to record a Macro then adapt the code but I did not figure out how to do this in SAP S4/ HANA

Any help or pointing me to the right direction would be greatly appreciated.

Thanks