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

[@hichamsabir1156]

hi thnak you for the tutorial

[@davidnatera8923]

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

[@JoelTing]

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.

[@assitantrevenueofficerjawa4052]

You are awesome I am your your big 🎉

[@JoelTing]

Thank you! :)

[@alejandrodelrio6621]

Hi Joel. Is there any way to reach you out? I am having issues to pull some fix excel cells into sap. Thank you.

[@JoelTing]

Hi there. What issue that you are having? You can reach me via my email: [e-mail]

[@amitprasad5496]

Very valuable video, appreciate you sharing this. Question? Can this be done with SAP business ByDesign as well?

[@JoelTing]

I'm not too familiar with SAP Business ByDesign. Is that web based? If it is, then SAP GUI Script will not work (SAP GUI Script only works for SAP GUI) but the general approach can still be applied using Power Query. For web-based systems, you can automate the extraction process using Selenium. Once you have the output file's path, you can replace it the parameter with the latest output file path, allowing the process to be automated in a similar manner.

[@Sumanth1601]

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..

[@JoelTing]

Hello! You can get the file for reference using the link below: www.dropbox.com/scl/fi/94a84nivqyeehtvv5fb7q/FAGLL03Extract.xlsb?rlkey=d8mlg4mrc62kbwrjuxy1x0gkn&st=onekagzv&dl=0

[@PauloDoutel]

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]

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?

[@BulentOner]

But, many of the productive systems are not allowed scripting. Unfortunately

[@JoelTing]

Based on my experience, many companies are open to SAP GUI Scripting in production systems when there's a clear business need, especially for data extraction purposes. Typically, IT departments are willing to assist with such requests. They often provide scripting access to specific users or create dedicated robotic SAP IDs for this purpose.

[@alejandrodelrio6621]

I am trying to upload information from excel to sap, transaction FB01. I’ve sent some information by email, hopefully you have a chance to read it. Thank you.