×

[PR]この広告は3ヶ月以上更新がないため表示されています。
ホームページを更新後24時間以内に表示されなくなります。




Sapass

 Simplify SAP R/3 development with Excel VBA/VB RFC  
Home> Sap_Active_X



Index

VBA/VB ActiveX and SAP RFC

We check the syntax for calling SAP RFC function module from VBA/VB.

17-Sep-2005


Log on by Function Control

Most simple way to logon to SAP is to go with ActiveX object. This utilizes the ActiveX module in :...SAP/FrontEnd/Controls/wdtfuncs.OCX.

Move to 'Log on by Function Control'


Log on by Logon Control

Same as to go with Function, you can logon with Logon object. But some of the methods are only available in the Function object so it's better to go along with Function object. This utilize the ActiveX module in ...SAP/FrontEnd/Controls/wdtlog.OCX. This actually nothing different from the one in Function object.

Move to 'Log on by Logon Control'


Create Structure 1

There are several ways to create SAP structure. Here, we will be checking how we can obtain table structure information from SAP and create structure on Excel VBA/VB. Use CreateStructure method.

Move to 'Create Structure 1'


Create Structure 2

This is an alternative for creating structure. We will use Table factory method here.

Move to 'Create Structure 2'


Create Table

Same as NewStructure method, Table can be created by the NewTable method of TableFactory control. This utilize the ActiveX module in ...SAP/FrontEnd/Controls/WDTAOCX.OCX.

Move to 'Create Table'


Call SAP RFC Function 1

Here we will check how we can call SAP RFC enabled function module from VBA/VB. This utilize the ActiveX module in ...SAP/FrontEnd/Controls/wdtfuncs.ocx.

Move to 'Call SAP RFC Function 1'


Call SAP RFC Function 2 (Dynamic)

Alternate syntax for calling SAP RFC Function from VBA/VB. We will see different syntax for calling.

Move to 'Call SAP RFC Function 2 (Dynamic)'