SAP Excel Integration
4.0 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
458 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP Excel Integration to your Wishlist.

Add to Wishlist

SAP Excel Integration

Real Time SAP Excel Reporting using simple VBA Programming
4.0 (48 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
458 students enrolled
Created by SAP Buddy
Last updated 9/2014
English
Current price: $12 Original price: $40 Discount: 70% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Low cost development
  • Alter the report live
View Curriculum
Requirements
  • Basic knowledge in SAP
  • Basic knowledge in Microsoft Excel
Description

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

Who is the target audience?
  • SAP User
  • SAP Consultant / Project Manager
  • Business Owner CIO,CFO.etc
Compare to Other Excel Courses
Curriculum For This Course
19 Lectures
03:20:04
+
Introduction
1 Lecture 09:53

This section describe

1. Target Audience

2. Why to learn SAP & VBA

3. Goals and Objective of this course

Preview 09:53
+
Technology
1 Lecture 05:33

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.

02.1 Technology
05:33
+
Prerequisite
1 Lecture 09:00

This section give you details of library files and active X file which is required from Excel to SAP integration.

Preview 09:00
+
Introduction to SAP System & Landscape
1 Lecture 08:17

This gives very simple overview for SAP system and landscape in order to understand the SAP system for the new user of SAP.

04 Introduction to SAP System and Landscape
08:17
+
Using Microsoft Excel and VBA
1 Lecture 11:19

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.

05 MS Excel VBA
11:19
+
Logging into SAP System from Microsoft Excel
1 Lecture 19:11

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

06 Connect to SAP System
19:11
+
Calling Function from Excel to SAP System
3 Lectures 27:14

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 1
08:40

07.1 Function Module and Table Part 2
06:51

Using the Microsoft Excel VBA called specific function module from SAP system is explained in this training section.

07.2 Calling Function Module from Microsoft Excel
11:43
+
Integrate data in Excel
3 Lectures 46:28
08.1 Logon Information Integration
09:50

08.2 SAP Table to Excel
15:56

08.3 SAP Table to Excel with Input
20:42
+
Nested RFC function
1 Lecture 10:43
09 Nested RFC function
10:43
+
VBA and Control Button
1 Lecture 08:17
10 Link VBA Program to Control Button
08:17
5 More Sections
About the Instructor
SAP  Buddy
3.6 Average rating
136 Reviews
1,050 Students
2 Courses
SAP Consultant, Trainer at SAPBuddy

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.