Best way to build SAP-connected web appication?
I've been asked to build a "system" where users fill specific Excel formatted documents, which are then processed by a macro, which executes a SAP script that saves the SAP-user from retyping all this stuff again to continue with the transaction.

I really don't like how this is going. I don't think that handling each user a macro-enabled Excel file is the right or best way to do this, and all this workbook-to-workbook copy and pasting stuff is really annoying and time consuming.

I proposed changing the whole scheme of the project to a web application that users could access in the company's intranet. Info would be processed by the server, where the SAP transactions would also be executed as needed.

I've been searching but can't find what would be the easiest and best way to do this. The project is really simple and I think I can do it all by myself, I only need guidance in which technologies to use. I've been reading about SAP NetWeaver Development System, sapui5 SDK and other related stuff, but I'm sure there must be an easier and more convenient way for my needs, as the project doesn't really need a big implementation.

Any help, ideas, tips?

Thanks
Best way to build SAP-connected web appication?
===

I've been asked to build a "system" where users fill specific Excel formatted documents, which are then processed by a macro, which executes a SAP script that saves the SAP-user from retyping all this stuff again to continue with the transaction.

I really don't like how this is going. I don't think that handling each user a macro-enabled Excel file is the right or best way to do this, and all this workbook-to-workbook copy and pasting stuff is really annoying and time consuming.

I proposed changing the whole scheme of the project to a web application that users could access in the company's intranet. Info would be processed by the server, where the SAP transactions would also be executed as needed.

I've been searching but can't find what would be the easiest and best way to do this. The project is really simple and I think I can do it all by myself, I only need guidance in which technologies to use. I've been reading about SAP NetWeaver Development System, sapui5 SDK and other related stuff, but I'm sure there must be an easier and more convenient way for my needs, as the project doesn't really need a big implementation.

Any help, ideas, tips?

Thanks