Skip to Content
avatar image
Balajisha T V

SAP <----> Excel (RFC)

Nov 27, 2017 at 08:39 AM | 76 Views

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 .

ABAP Development
logging of RFC and Web services
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Mike Pokraka
    Nov 27, 2017 at 08:56 AM

    It is probably possible, but almost certainly more effort than just building a new form in SAP.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Balajisha T V
    Nov 27, 2017 at 09:10 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Mike Pokraka
      Nov 27, 2017 at 01:39 PM

      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.

  • avatar image
    Jörgen Lindqvist
    Nov 27, 2017 at 07:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded