Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel
Rating: 4.3 out of 5(136 ratings)
1,020 students

[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel

Stop wasting time on tedious, monotonous tasks in SAP.
Created byascoro | Beratung & Training von SAP-Spezialisten
Last updated 9/2022
English
English [Auto],

What you'll learn

  • You can automate processes via SAP GUI scripting.
  • You can name the advantages of SAP GUI Scripting in automation.
  • You can explain what SAP GUI Scripting is used for.
  • You can make the system settings required for SAP GUI Scripting.
  • You can integrate SAP GUI scripts into Microsoft Excel via VBA.
  • You learn how to start/stop SAP GUI scripts for automation.
  • You can explain what to do in case of a SAP GUI script error.
  • You can explain the advantages and disadvantages of SAP GUI Scripting.

Course content

6 sections • 12 lectures • 1h 8m total length

  • How do you automate the SAP data entry process with Microsoft Excel?5:00

    Automate SAP data entry by recording scripts with the SAP script recorder and running them from Microsoft Excel, a fast, low-code solution that improves data quality and requires no licenses.

  • How is the course content structured?1:32

    Explore how the course is structured across chapters, from setting up SAP and Excel for scripting to recording your first script, integrating with VBA, and running scripts in SAP.

Requirements

  • Technical requirements: SAP GUI Scripting is only available from version 6.20 of the SAP FrontEnd.
  • Personal requirements: No prior knowledge is required. The necessary knowledge is imparted in this course.

Description

SAP GUI Scripting is an automation interface that allows end users to automate repetitive tasks by recording and executing them through a macro-like script. It is a simple tool for robotic process automation (RPA). The interface has existed since SAP FrontEnd version 6.20 and comes standard at no additional cost. SAP GUI Scripting uses the methods and properties of individual objects in the SAP GUI to perform actions and/or read data. All tasks that a user can perform manually can be automated with SAP GUI Scripting. SAP GUI Scripting is an example of the integration between SAP and Microsoft Office.


This course teaches you how to integrate your SAP GUI script with Microsoft Excel using Visual Basic for Applications (VBA). For this integration you will need a free Microsoft Excel add-in (SAP GUI Scripting API). Automation via SAP GUI Scripting is fairly simple, inexpensive and straightforward. Therefore, there are almost no corporate hurdles in introducing this technology. This is one core advantage over other solutions (ABAP program, LSMW, etc.).


SAP GUI Scripting can save a considerable amount of time for many business processes. The time saved can then be used for more demanding tasks. The errors avoided by automation save follow-up costs and remediation time.

Who this course is for:

  • The contents of this course are aimed at: SAP users, SAP key users and SAP consultants.

Report abuse