Gather data from SAP

Good morning,

I would like to import the result of a specific transaction in SAP in a sheet of an already existing excel-file.
To get this data the idea is to enter a product number in my excel-file, which triggers a query/transaction in SAP. After that the outcome of this query should be copied to an extra sheet in the same excel-file.

There are two possible ways in my head that may work:

1) Start an automated process via Power Automate etc., safe the result of the transaction as a text-file, convert it in an excel-file and then extract the needed data into my existing excel-sheet. While this might work, it seems quite complicated and very prone to errors.

2) Extract the data via macro directly from SAP (login to SAP with a popup in excel or safe the login data directly in the macro) and copy it to the needed excel-sheet. This is the more elegant way and I know, that this should be possible - but I`m completely lost to make this on my own...

I will try to post a sample sheet, but its quite difficult to do so, because every result of a transaction is different and no confidential data is allowed.

Thank you in advance for any help and best regards,

David

Hi Ali,

thanks for reaching out!
I tried to explain the problem via a sample sheet.
Please dont hesitate to ask if something needs a clarification.

And VBA sounds fine - but I guess I would need some help to do this.

Thank you and have a nice weekend,

David

Good morning,

due to the potential need of VBA, can someone may move this thread to the according sub?

I tried to work on a solution for my problem and found out, that it should be possible to make a script in SAP and then run this script via macro in Excel.
The transaction ZR11 is needed to enable the possibility to record the steps you need in SAP.
Afterwards a .vbs file is generate which can simply be copied to a VBA macro. Variables can be implemented to make the query dynamic.

The only problem I have with this solution is, that SAP is running in the foreground and the generated Excel-File is separate and not included in my actual Workbook.

Does anyone know a workaround for this?

Thank you in advance and best regards,

David