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