Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 20 Minute(s)
Language
English
Taught by
SAP Buddy
Rating
Course Overview
Real Time SAP Excel Reporting using simple VBA Programming
Microsoft Excel is extensively used in all business. There are many SAP Consultant or Business users not aware we can interface Microsoft Excel with simple VAB Code. Then we have an interesting question. If we use and SAP do we stop using Excel? The answer is NO.
As an SAP Consultant / Business owners you may have some report customized for your business requirement. There will be few reports which are used by one or two users. Now the next question, how much money we spend to develop this report. Quite often this report again downloaded and viewed in Microsoft Excel.
Can we get the report directly in Excel from SAP? Yes, it is possible and very simple. You can get the data from SAP directly in Excel. You can format the report as you like. You can create online dash board etc.
With this course who ever have little excel knowledge or SAP knowledge can create this SAP excel report generator program every easy.
Join our course, save cost and efforts and enjoy!!
Course Content
- 15 section(s)
- 19 lecture(s)
- Section 1 Introduction
- Section 2 Technology
- Section 3 Prerequisite
- Section 4 Introduction to SAP System & Landscape
- Section 5 Using Microsoft Excel and VBA
- Section 6 Logging into SAP System from Microsoft Excel
- Section 7 Calling Function from Excel to SAP System
- Section 8 Integrate data in Excel
- Section 9 Nested RFC function
- Section 10 VBA and Control Button
- Section 11 Alternative logon
- Section 12 Secure Network Communications - SNC
- Section 13 Troubleshooting
- Section 14 SAP VAB Tools Review
- Section 15 Microsoft Excel Sample VBA Code
What You’ll Learn
- Low cost development, Alter the report live
Skills covered in this course
Reviews
-
CCristina Duca
Interesting topic. Good explanation from zero but there are many topics to explore further
-
SShunmugam
Excellent explanation, Expected more on SSO/SNC and Tocde access. Happy to take more courses.
-
AAnand Sharma
Very nicely explained how we can login to SAP from excel. Different ways explained to login. Major disappointment starts when the course does not explain how I can download data from complex tables like VBAK or BKPF where data is huge. The course should have explained how I can input data from excel and extract data into particular fields in excel. The course only helps in explaining how to connect but not more than that....if course is not enhanced further then it is a waste of time.
-
AAnuj Sureshkumar
Very Good Starting Point. A concise course addressing my exact requirement but also letting you know that there are many other possibilities to achieve the same results.
