SAP Excel Integration

Real Time SAP Excel Reporting using simple VBA Programming
4.0 (34 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.
372 students enrolled
Instructed by SAP Buddy IT & Software / Other
62% off
Take This Course
  • Lectures 19
  • Length 3.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


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.

About This Course

Published 8/2014 English

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

What are the requirements?

  • Basic knowledge in SAP
  • Basic knowledge in Microsoft Excel

What am I going to get from this course?

  • Low cost development
  • Alter the report live

Who is the target audience?

  • SAP User
  • SAP Consultant / Project Manager
  • Business Owner CIO,CFO.etc

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
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
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

SAP Buddy, 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.

Ready to start learning?
Take This Course