Stop wasting time on tedious, monotonous tasks in SAP.

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

Overview

Section 1: Introduction

Lecture 1 How do you automate the SAP data entry process with Microsoft Excel?

Lecture 2 How is the course content structured?

Section 2: Settings

Lecture 3 How do you install the SAP GUI Scripting component?

Lecture 4 What user settings are relevant for SAP GUI Scripting?

Lecture 5 What parameters are relevant for SAP GUI Scripting?

Lecture 6 How do you activate the SAP GUI Scripting API in Microsoft Excel?

Section 3: Recording

Lecture 7 How do you record your first SAP GUI script?

Section 4: Integration

Lecture 8 How do you integrate your SAP GUI script into Microsoft Excel?

Section 5: Application

Lecture 9 How do you execute your SAP GUI script?

Lecture 10 What do you do in case of errors?

Section 6: Conclusion

Lecture 11 What are the pros and cons of SAP GUI Scripting?

Lecture 12 What do your next steps look like?

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