3 Replies Latest reply: Sep 13, 2012 12:36 PM by max bianchi RSS

Connect a third-party application (MS Excel) with SAP R/3

Daniel Magana
Currently Being Moderated

Hey guys,

 

I've seen this question few times here, but all of them are out-of-date or barely answered. I also asked this task on another platform. So far, I have achieve a couple of interesting things:

 

Loggin from Excel to SAP successfully

Read a table (only the ones which my User is authorized for)

Saving that table to a sheet.

 

Unfortunately, I'm not able to do any ABAP coding because all the ABAP development is centralized in a foreign country. So, I can only use VBA code.

 

My objective in this challenge is to run a transaction ( the TCODE I'm looking for is LM02, a bin to bin transaction for warehouse) via a VBA Macro, upload some date extracted from a MS Excel file and Execute the transaction.

 

Some of the useful question links I've found are these:

 

http://scn.sap.com/thread/188433

http://scn.sap.com/thread/73856

http://scn.sap.com/thread/50275

http://scn.sap.com/thread/667687

http://scn.sap.com/thread/3161657

http://scn.sap.com/thread/116877

 

More INFO: I'm a "normal" user in SAP (without developer access to ABAP transactions SE37, SE38, etc), I can't use LSMW neither. Working with MS Excel 2007 and Windows 7.

 

Thank you guys.

  • Re: Connect a third-party application (MS Excel) with SAP R/3
    max bianchi
    Currently Being Moderated

    Hi

     

    The problem is you can't enter directly into SAP from third-party application, you need to use a "door".

     

    In SAP many "door" are definied and every one can do a single action: they are called RFC (Remote Function Call), probably you know them.

     

    A typicall RFC is the BAPI

     

    Now you need to check if there's a standard BAPI or RFC simulate transaction LM02 (I don't know it): if there's you can create a VBA macro in order to upload the data in SAP, else you should create a custom RFC (but I suppose you can't because you are not a developer).

     

    Max

    • Re: Connect a third-party application (MS Excel) with SAP R/3
      Daniel Magana
      Currently Being Moderated

      Thank you Max,

       

      Do you think that is necessary the SAP IT support help for achieve my task ? Or it can be done by own.

      • Re: Connect a third-party application (MS Excel) with SAP R/3
        max bianchi
        Currently Being Moderated

        Hi

         

         

        Yes I think a support from SAP IT should be necessary:

         

         

        The step one is to understand if there' s a RFC or BAPI for your transaction, but you don't have the permission for ABAP transactions, so I don't know how you can find out it.

         

         

        Theorically you can try to looking for it in WEB or in SAP documentation, but then (if it exists) you need to check the interface where the the import/export parameters are defined.....so you should have the authorization for SE37.

         

         

        The next step depends on if you can or can't find out a RFC function for LM02:

        if there's a function, you need to understand how to run it

        if there isn't a function. you need to understand if you or an abaper can develop a custom one.

         

        Max

Actions