没有合适的资源?快使用搜索试试~ 我知道了~
首页excel 调用SAP 函数
This paper describes how to extract data from R/3 and present the results in MS Excel. The paper demonstrates by means of a code sample how easy it is to use VBA as the underlying technology for logon and data extraction. The example allows one to define R/3 systems and to retrieve/present all user locks + types from one individual system
资源详情
资源评论
资源推荐
How to connect to SAP R/3 and call BAPI from MS Excel VBA
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2007 SAP AG 1
How to connect to SAP R/3 and call BAPI from MS Excel VBA
Summary
This paper describes how to extract data from R/3 and present the results in MS Excel. The paper
demonstrates by means of a code sample how easy it is to use VBA as the underlying technology for logon
and data extraction. The example allows one to define R/3 systems and to retrieve/present all user locks +
types from one individual system.
Author(s): Danny De Roovere
Company: SAP Belgium Luxemburg
Created on: 21 January 2007
Author Bio
Danny De Roovere is a senior SAP Netweaver consultant employed at SAP Belgium-
Luxemburg. Danny started as a SAP basis consultant (in particular EDI-ALE), and
immediately added a new dimension to his career when SAP released it’s NetWeaver
platform. Today, his main focus is SAP’s business-driven software architecture (eSOA),
including SAP Enterprise Portal, SAP Exchange Infrastructure and Duet.
How to connect to SAP R/3 and call BAPI from MS Excel VBA
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2007 SAP AG 2
Table of Contents
Excel sheet ...................................................................................................................................... 3
System Definition and Logon....................................................................................................... 3
Lock Overview.............................................................................................................................. 4
Macro............................................................................................................................................... 6
GetUserList .................................................................................................................................. 6
Related Content............................................................................................................................. 10
Disclaimer and Liability Notice....................................................................................................... 11
How to connect to SAP R/3 and call BAPI from MS Excel VBA
SAP DEVELOPER NETWORK | sdn.sap.com BUSINESS PROCESS EXPERT COMMUNITY | bpx.sap.com
© 2007 SAP AG 3
Excel sheet
The example is based on the usage of 3 sheets:
• Logon Data: allows one to select the system of interest and click on the submit button to retrieve the
system’s user locks
• Lock Overview: automatically launched after having clicked the submit button: It is the result of the
BAPI calls
• System Definition: contains all system details. Data is copied to the 1
st
sheet. This sheet can be
protected as it contains userids and passwords.
Obviously, you can create your own look-and-feel (change columns and rows) to identify your systems, but
be aware that you’ll need to modify the sample VBA code in that case. This example is a quick how-to guide
that demonstrates the power of VBA. The goal was not to make the winning ultimate UI.
System Definition and Logon
First of all, you need to declare the systems you want to retrieve data from. To do so, start MS Excel and
create the following sheet:
Note that I created a separate Tab for ‘System Definition’, because I don’t want the CPIC user passwords to
be visible in the ‘Logon Data’ Tab in the spreadsheet. In fact I’ve hidden the rows (4 and 5) that are
referenced in the ‘Logon Data’ sheet (see below).
剩余10页未读,继续阅读
ynyangbo
- 粉丝: 0
- 资源: 10
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- zigbee-cluster-library-specification
- JSBSim Reference Manual
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0