Hi Team,
We have the requirement to convert an Excel form (with Macro's) to SAP.
The challenge here is we have about 400 unique Conditions when we compare all the macro's. So what we are trying to propose is to have this Exel in Server and from SAP we will pass the inputs to Excel sheet in server and get back the results from it.
Please advise if this is a feasible. And also the methods to call the Excel marcro's in SAP .
It is probably possible, but almost certainly more effort than just building a new form in SAP.
Hi Mike,
Thanks for your reply,
The reason why we are thinking in this direction is to avoid such combination of nested IF conditions in SAP.
if you could advise us on how to connect to Excel from SAP and get the derived results will be helpful in achieving this solution or else if there is any other opinion also please share with us.
You can do a lot of Excel interaction using OLE, please review the doco on this: link and there is also plenty of info on here.
I would still run very very far away from this solution. ABAP is more than capable of handling 400 IF statements, and it can almost definitely be simplified compared to what you're restricted to with Excel macros. Having business logic split in different platforms is also bad. The effort is probably the same. So all round I'd go for a Web Dynpro app or something like that.
I would also advice against relying on Excel to perform application logic on behalf of your SAP system.
If you haven't already, I think you should check out if this is something you want to implement in BRF+. It's a quite extensive framwork within your SAP system. I have on some occations used it mainly as a "technical configuration engine" (instead of implementing multiple complex z tables + program logic), but it is alot more to it than that. At least give it a look. It would definitely help you to "avoid such combination of nested IF conditions in SAP", while still having all the logic in one platform!
https://help.sap.com/erp_mdg_addon70/helpdata/en/9a/6b67ce7c26446483af079719edf679/frameset.htm