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!!
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.
This gives very simple overview for SAP system and landscape in order to understand the SAP system for the new user of SAP.
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.
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
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.
Using the Microsoft Excel VBA called specific function module from SAP system is explained in this training section.
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.