Call Function Module from SAP with Excel VBA [english]

Поділитися
Вставка
  • Опубліковано 7 жов 2023
  • In today's video I will show you how to use Excel VBA to call a remote enabled function module in SAP and download and display the data in Excel.
    #sap #excel #vba #functionmodule
    ✅ Book, I am currently reading: amzn.to/43Zat2C
    ▬▬ Literature 📚 ▬▬▬▬▬▬▬▬▬▬▬▬▬
    ▶ ABAP: An Introduction 2020 amzn.to/45CLTqk
    ▶ Complete ABAP 2023 amzn.to/45D5UNM
    ▶ ABAP to the Future 2022 amzn.to/42cgWGs
    ▶ Clean ABAP 2022 amzn.to/3KAqmow
    ▬▬ My Hardware 💻 ▬▬▬▬▬▬▬▬▬▬▬▬▬
    ▶ Microphone: amzn.to/3zj2UIz
    ▶ Headphone: amzn.to/3GUBRFg
    ▬▬ My Software (free) 💾 ▬▬▬▬▬▬▬▬▬▬▬
    ▶ Video Recorder: bit.ly/678fgh6
    ▶ Video Editor: bit.ly/38Rj9lb
    ▶ Thumbnail: bit.ly/CustAndCodeThumbnail
    ▶ Gamma AI: bit.ly/3nsdvgr
    ▬▬ Further Links 🔗 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    ⭐Become my subscriber: bit.ly/CustAndCodeSub
    🎬All videos in English: bit.ly/CustAndCodeENG
    ☕Buy me a Coffee 😀: bit.ly/3dih2cl
    *The links are affiliate links. There are no additional costs.
    📍Attribution:
    Icons from: icon-icons.com
    UA-cam Subscribe Animations: pixabay.com/videos/search/sub...
    SAP® and SAP GUI Scripting are registered trademarks of SAP AG.

КОМЕНТАРІ • 9

  • @zelalemtadesse
    @zelalemtadesse 15 днів тому

    It is interesting, Can we call report data from excel? Thank you sharing cool programs. Greatly appreciated. The quality is excellent, it worth spending time watching and learning new ways of working with SAP ABAP.

  • @mithatcan4894
    @mithatcan4894 9 місяців тому

    Very good , perfect.... Friend thanks

    • @CustAndCode
      @CustAndCode  9 місяців тому +1

      Thank you very much for your comment! 🤗😀

  • @user-lq5cw2yp2j
    @user-lq5cw2yp2j 5 місяців тому

    Is there any documentation or tutorial to how create an RFC connection in SAP specifically to connect a VBA application?

    • @CustAndCode
      @CustAndCode  5 місяців тому

      Unfortunately I don't know. I haven't used this. I had never had this requirement before. But If you know how to do this I would like to know it too 😉🤗

  • @user-kq2gd1hj9y
    @user-kq2gd1hj9y 9 місяців тому

    very interesting topic very well explained. Unfortunately with my SAPGUI 800 64 bit I get the 'Class not registered' error, even though I have referenced wdtfuncs.ocx and the SAPGUI scripting API. Do you have an idea what the reason could be?

    • @CustAndCode
      @CustAndCode  9 місяців тому

      Es kann sein dass du hier was nachinstallieren musst damit das Ganze mit 64bit funktioniert. Siehe dazu diesen Hinweis: me.sap.com/notes/2724656
      🤗

    • @user-kq2gd1hj9y
      @user-kq2gd1hj9y 9 місяців тому

      Danke fuer das schnelle Feedback. Ich werde mal schauen, ob ich die 64Bit RFC Controls zum Laufen bekommen.

    • @CustAndCode
      @CustAndCode  5 місяців тому

      Hat das eigentlich noch geklappt? 🤗