SAP <----> Excel (RFC)

[balajishahrsap]

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 .

[former_member502808]

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