Extract and Transform SAP Data with ONE click! Automation with Excel VBA and Power Query

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 พ.ย. 2024

ความคิดเห็น • 7

  • @davidnatera8923
    @davidnatera8923 2 วันที่ผ่านมา

    Excelente video, con este metodo te evitas tener que escribir más lineas de codigo VBA

    • @JoelTing
      @JoelTing  2 วันที่ผ่านมา

      Yes, and it's much easier to maintain since not all users are familiar with VBA, while Power Query is quite user-friendly for everyday Excel users. I've worked on several projects and successfully handed over their maintenance to the team with little VBA knowledge.

  • @Sumanth1601
    @Sumanth1601 19 ชั่วโมงที่ผ่านมา

    Excellent content,.loved it 😊 I use power query for many of my workflows..but never managed to have it in conjunction with SAP, where can I find the copy of your vba script.. thanks again..

  • @assitantrevenueofficerjawa4052
    @assitantrevenueofficerjawa4052 3 วันที่ผ่านมา +2

    You are awesome I am your your big 🎉

    • @JoelTing
      @JoelTing  2 วันที่ผ่านมา

      Thank you! :)

  • @PauloDoutel
    @PauloDoutel 3 วันที่ผ่านมา

    Dear Sir,
    Thank you so much for sharing your extraordinary knowledge, which has been of great help to all of us. I would like to know if you could provide a practical example of how to upload preventive maintenance operations (010, 020,030...) directly from Excel to SAP using the IA-01 transaction.
    The goal would be to create a task list, including all associated operations, as well as simple comments, more detailed ones, and preventive maintenance periodicities (PM01)such as monthly, semi-annual, annual, etc.
    If you have an example or guidance on this process, I would be very grateful.
    Best regards,
    Paulo Doutel

    • @JoelTing
      @JoelTing  2 วันที่ผ่านมา

      Hello! I'm not too familiar with the processes around IA01. Maybe you can book a call with me and I can give you some ideas on how this could be set up?