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