Exporting Data from SAP using GUI scripting
This course follows our SAP GUI Scripting course and looks at a particular use case when data is extracted from SAP via SE16. You will use scripting to execute a table content list in SE16, extract the data and automatically load it into Excel. Contains heavy use of Excel and Visual Basic, beginner VB knowledge is useful.
7 Reviews 4.1 of 5.0
Course Goal
- Learn how to automate loading SAP report data to Excel through GUI scripting
- Learn how to record and script a simple export process using SE16
- Review the visual basic code created through GUI scripting
Audience
- Consultants
- End users
- IT/Business analysts
- Project Managers
Exam/Certificate
- Certificate of Completion (more certification info)
Lesson Plan
| # | Description | |
|---|---|---|
| Introduction | ||
| 1 | Meet your Instructor | Preview |
| 2 | Course Overview | |
| 3 | GUI Scripting Prerequisites | |
| Scripting and Excel Coding | ||
| 4 | Create a basic recording for data export | |
| 5 | Importing data to Excel | |
| 6 | Scripting using the selection screen | |
| Summary and Appendix | ||
| 7 | Summary | |
| 8 | Appendix - Excel files zipped for download | |
| 9 | Disclaimer | |
Instructor
4.4 Average Rating
37 Reviews
130 Students
5 Courses
CRM Consultant
I am an SAP consultant from Budapest, Hungary with more than 16 years of work experience in the SAP world, including 10 years in CRM and ERP, I specialize in design and implementation projects in CRM as well as strategy and business consulting in the CRM field. I have a good technical understanding and working knowledge of various development languages and database systems. I have extensive experience working with many multi-national companies all over Europe.
More Courses by Csongor Varga:
No more using SE16 for data hunting! Learn how to create simple reports with SAP Queries by linking SAP tables togeth...
SAP GUI scripting can be used for small migration exercises, for automating testing, or end user tasks, including exe...
This course builds on knowledge gained from earlier GUI scripting courses. Learn how to debug your script, and explor...
Student Feedback
4.1
Average Rating
Reviews |
Training 5 or more people?
Unlimited access for your entire SAP team including admin platform and premium reporting.SAP Training for Businesses
| Language: | English |
| Level: | Intermediate |
| Duration: | 0.5 hours |
| Type: | Instructor-led |
| Release: |
BI 7.x ECC 6.0 SAP CRM 7 |
| Category: | SAP Basis, HANA & Winshuttle Tools |
