Getting data from SAP to excel and refreshing the data with a button in excel

[Former Member]

Hi all, Im an intern at a company and i have been tasked with creating an excel sheet where employees can check off some parts and get a total price. The problem im having is that the prices of the parts change in SAP alot and therefore excel should pull the prices from SAP and the users should be able to refresh the prices directly in excel. i fairly new to SAP and therefore know very little about this. it should also be possible for them to enter an item no and then the price would show in excel. I hope this is possible and that someone can help me with my problem.

Sorry for the tag, i dont know which one applies

[stefan_schnell]

Hello Simon,

welcome in the SAP Community. To solve your problem you are here at the right place.

You can solve your problem via a SAP GUI Scripting solution. What does it means? Each of your parts has in the SAP system an uniqueue ID. So record your activities via SAP GUI Scripting recorder to get a price of a part via the ID. The ID is your variable. Save the script and put it in your Excel-VBA code. Link the code with your button event, and if the user press the button you get the actual price from the SAP system via SAP GUI Scripting, dependent on the ID of the part which is variable.

I hope this abstract description gives you a contour of the proceeding.

Cheers
Stefan

[Former Member]

Hello Stefan,

Thank you for the answer.

Your description have given me an idea of how to proceed. So now im just going to have to learn how to code VBA but im getting there.