Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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!!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
This section describe
1. Target Audience
2. Why to learn SAP & VBA
3. Goals and Objective of this course
|Section 2: Technology|
This section gives overview of underlined technology used in to interface Microsoft Excel with SAP. The compatibility of VBA program to connect other Microsoft Products is discussed in this section.
|Section 3: Prerequisite|
This section give you details of library files and active X file which is required from Excel to SAP integration.
|Section 4: Introduction to SAP System & Landscape|
This gives very simple overview for SAP system and landscape in order to understand the SAP system for the new user of SAP.
|Section 5: Using Microsoft Excel and VBA|
How to start Microsoft Visual Basic Application from Microsoft Excel, how to execute the programs are explained by creating simple VAB program, to add two numbers. This section is very useful for beginners in VBA.
|Section 6: Logging into SAP System from Microsoft Excel|
The part of training explains how to get the system details from SAPGUI and login to SAP system from Microsoft Excel. During the training section we will also learn how to include validation to verify weather user is able to login to SAP system successfully
|Section 7: Calling Function from Excel to SAP System|
This section explains SAP Function Module and function module which is used to generate report during the entire course. This section is divided in two parts. Part one describes how to view the data with in SAP. Part two explains how the same data can be extracted using function module.
07.1 Function Module and Table Part 2
Using the Microsoft Excel VBA called specific function module from SAP system is explained in this training section.
|Section 8: Integrate data in Excel|
08.1 Logon Information Integration
08.2 SAP Table to Excel
08.3 SAP Table to Excel with Input
|Section 9: Nested RFC function|
09 Nested RFC function
|Section 10: VBA and Control Button|
10 Link VBA Program to Control Button
|Section 11: Alternative logon|
11 Alternative logon
|Section 12: Secure Network Communications - SNC|
12 Secure Network Communications - SNC
|Section 13: Troubleshooting|
|Section 14: SAP VAB Tools Review|
14 SAP VAB Tools Review
|Section 15: Microsoft Excel Sample VBA Code|
15 Microsoft Excel Sample VBA Code
SAPBuddy is promoted by set of highly experienced SAP consultant in SAP industry from various technical and functional backgrounds. Experts in different SAP Module SAP Basis, SAP Security, ABAP, Solution Manager, XI/PI, BW, CRM, SD, PS, CS, PM, HR etc.
All product names are trademarks of their respective companies. SAPBuddy is in no way affiliated with any software companies.