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

Focused View

ascoro | Beratung & Training von SAP-Spezialisten

1:08:56

131 View

1. Introduction

1. How do you automate the SAP data entry process with Microsoft Excel.mp4

05:00

2.1 SAP launchpad.html

2. How is the course content structured.mp4

01:32

2. Settings

1.1 SAP Launchpad.html

1. How do you install the SAP GUI Scripting component.mp4

04:07

2. What user settings are relevant for SAP GUI Scripting.mp4

03:16

3. What parameters are relevant for SAP GUI Scripting.mp4

04:42

4. How do you activate the SAP GUI Scripting API in Microsoft Excel.mp4

05:41

3. Recording

1. How do you record your first SAP GUI script.mp4

10:31

4. Integration

1.1 sap gui scripting - template.zip

1. How do you integrate your SAP GUI script into Microsoft Excel.mp4

11:40

5. Application

1. How do you execute your SAP GUI script.mp4

05:06

2. What do you do in case of errors.mp4

06:41

6. Conclusion

1. What are the pros and cons of SAP GUI Scripting.mp4

08:05

2. What do your next steps look like.mp4

02:35

Description

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.

Who is this for?

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

What You Need to Know?

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.

More details

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.

User Reviews

Rating

average 0

Total votes0

Focused display

ascoro is a leading provider of professional training services. We provide e-learning based end to end training. End-users who attended these trainings quickly realised that the offerings not only reflect their daily operational procedures but covers topics that challenges those boundaries and goes miles beyond to meet the highest quality standards.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.