Click here to Skip to main content
Click here to Skip to main content
Go to top

Connection to SAP from Visual Studio 2008 with SAP.NET Connector 2.0

, 24 Apr 2009
Rate this:
Please Sign up or sign in to vote.
This article explains how to connect to SAP from Visual Studio 2008 with SAP.NET Connector 2.0

Introduction

SAP is an inalienable system for large enterprise firms. We have to connect to this system if we need some data that belongs to SAP. The platforms can be Visual Studio 2008, Visual Studio 2005, Eclipse, or any other development tool.

But, there is a problem when connecting to SAP with Visual Studio 2008. The problem is SAP does not have a connector for Visual Studio 2005 and Visual Studio 2008. Up to Visual Studio .NET 2003 platform, there were no problems about connections to SAP.

As I mentioned in my other articles, the reason there is no connector for Visual Studio 2005 and Visual Studio 2008 is primarily marketing strategies. Let's not think why SAP did not make available an add-on for Visual Studio 2008, but think how can we solve this problem with available technologies.

Prerequisite Technologies

  • Visual Studio .NET 2003
  • Visual Studio 2008
  • SAP.NET Connector 2.0
  • Any SAP Application Server

Before reading this article, I suggest reading this article.

Using the Code

As I mentioned above, we will first use Visual Studio .NET 2003. Our purpose is to connect to SAP with Visual Studio 2003. While operating, we will create a class library project. Then, we will give a reference to this application to Visual Studio 2008. Thus, the problem about connection to SAP with Visual Studio 2008 will be solved. Meanwhile, this solution is recommended by SAP.

Let's start creating a class library project first.

sap_conn_vis2008_1.jpg

After creating the class library project, we will need to create a SAP Connector Proxy item as shown below.

sap_conn_vis2008_2.jpg

Because we will make a connection to SAP, we have to look at the SAP Servers under the Server Explorer section. We will use one of the BAPIs of SAP’s user information. This is the general view of the BOR objects:.

sap_conn_vis2008_3.jpg

We will use the ‘GetDetail’ method of the USER object. Drag and drop this method onto the SAPProxy1.sapwsdl file. Later on, there is no need for another class in our project. I am deleting the Class1.cs file.

sap_conn_vis2008_5.jpg

We have now completed the operations in the Visual Studio .NET 2003 side. You should now build your project. The output ‘SAPUserDetailComponent.dll’ will be a required file while connecting to SAP in Visual Studio 2008.

Now, we will create a Windows project under Visual Studio 2008.

sap_conn_vis2008_6.jpg

Before adding the DLL file of the previous project, we should add two more DLLs to our project. First, copy ‘SAPUserDetailComponent.dll’ to your project folder. Then, go to “..\Program Files\SAP\SAP .NET Connector 2.0″ and copy “SAP.Connector.dll” and “SAP.Connector.Rfc.dll” to your project folder.

sap_conn_vis2008_7.jpg

sap_conn_vis2008_9.jpg

We should pay attention to another point. The SAP Proxy is based on the SOAP protocol. So, we need to add the “System.Web.Services” DLL to our references.

sap_conn_vis2008_10.jpg

I have only added simple controls into Form1. The logic is simple, a SAP username will be taken, and the profiles authorization of this user will be printed into a table to show. Form1 will look as shown below.

sap_conn_vis2008_11.jpg

First, I inform the Visual Studio builder about the usage of the SAPUserDetailComponent assembly file:

using SAPUserDetailComponent;

Then, I write the code for the GetProfiles button’s Click event.

SAPProxy1 proxy = new SAPProxy1();

The SAPProxy1 class is referenced in our SAPUserDetail component reference.

BAPIADDR3 address = new BAPIADDR3();
BAPIUSCOMP companyName = new BAPIUSCOMP();
BAPIDEFAUL defaults = new BAPIDEFAUL();
BAPILOGOND logonData = new BAPILOGOND();
BAPISNCU snc = new BAPISNCU();
BAPIAGRTable activeGroups = new BAPIAGRTable();
BAPICOMREMTable addcomrem = new BAPICOMREMTable();
BAPIADFAXTable addfax = new BAPIADFAXTable();
BAPIADPAGTable addpag = new BAPIADPAGTable();
BAPIADPRTTable addprt = new BAPIADPRTTable();
BAPIADRFCTable addrfc = new BAPIADRFCTable();
BAPIADRMLTable addrml = new BAPIADRMLTable();
BAPIADSMTPTable addsmtp = new BAPIADSMTPTable();
BAPIADSSFTable addssf = new BAPIADSSFTable();
BAPIADTELTable addtel = new BAPIADTELTable();
BAPIADTLXTable addtlx = new BAPIADTLXTable();
BAPIADTTXTable addttx = new BAPIADTTXTable();
BAPIADURITable adduri = new BAPIADURITable();
BAPIADX400Table addx400 = new BAPIADX400Table();
BAPIPARAMTable parameter = new BAPIPARAMTable();
BAPIPROFTable profiles = new BAPIPROFTable();
BAPIRET2Table return0 = new BAPIRET2Table();

The above variables will be used while calling the SAP function.

SAP.Connector.Destination destination = new SAP.Connector.Destination();

We need to create a destination object to connect SAP. Later on, we will set the properties of this destination object as I have shown below.

destination.AppServerHost = YOUR HOST NAME OR IP
destination.Client = YOUR CLIENT NUMBER
destination.Password = USER'S PASSWORD
destination.SystemNumber = SYSTEM NUMBER
destination.Username = USER'S NAME

Our destination object will be a parameter for the SAPConnection class.

SAP.Connector.SAPConnection connection = 
   new SAP.Connector.SAPConnection(destination);

And, our connection object will be assigned to the proxy object.

proxy.Connection = connection;

Now, we open the connection.

proxy.Connection.Open();

Call the SAP function:

proxy.Bapi_User_Get_Detail(tbUsername.Text.Trim(), out address, out companyName, 
   out defaults, out logonData, out snc, ref activeGroups, 
   ref addcomrem, ref addfax, ref addpag, ref addprt, ref addrfc, 
   ref addrml, ref addsmtp, ref addssf, ref addtel, ref addtlx, 
   ref addttx, ref adduri, ref addx400, 
   ref parameter, ref profiles, ref return0);

Then, close the connection.

proxy.Connection.Close();

And, I will convert the result table of this function to an ADO table as I have shown below:

DataTable dt = profiles.ToADODataTable();

The last operation is we give the data table as a source for the grid view.

dgProfiles.DataSource = dt; 

The result screen will be:

sap_conn_vis2008_12.jpg

You can also visit my technical blog site for my other articles.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

huseyinakturk
Software Developer (Senior)
Turkey Turkey
Huseyin Akturk was born in Ankara, Turkey. He holds BSc degree from Dokuz Eylul University, Izmir, Turkey Computer Engineering department since July 2005. He also holds MSc degree from Ege University, Izmir, Turkey Computer Engineering department since March 2008.
 
He has applied data mining technology and statistical operations on stock exchanges during BSc and MSc theses. The purpose of these theses is looking for similarity between stock exchanges and he has got successful results in these theses respect to the purpose and published essays.
 
He has worked with a responsibility of being computer engineer during professional and academic experience. He has assimilated the idea of being keen on newness in technology. He has been working as Senior SAP Business Intelligence Consultant, Senior SAP Technical Consultant and Senior Software Engineer for several firms since October 2005.

Comments and Discussions

 
Generalget data Pinmemberbymesut5-Jun-09 5:44 
GeneralRe: get data Pinmemberhuseyinakturk5-Jun-09 8:58 
GeneralMy vote of 2 PinmemberIzzet Kerem Kusmezer28-Apr-09 4:02 
GeneralRe: My vote of 2 Pinmemberhuseyinakturk29-Apr-09 9:44 
GeneralNice but absolute sample PinmemberIzzet Kerem Kusmezer27-Apr-09 23:01 
GeneralRe: Nice but absolute sample Pinmemberhuseyinakturk28-Apr-09 1:01 
GeneralRe: Nice but absolute sample PinmemberIzzet Kerem Kusmezer28-Apr-09 4:15 
GeneralRe: Nice but absolute sample Pinmemberhuseyinakturk29-Apr-09 9:38 
Hi again,
I don't want to discuss with a man who comments unfairly. But, in order to find out the truth, i will give answer.
 
Firstfull, thank you for interest to my article. My numbered answers for your numbered ideas:
1. SAPDbReader is a good solution but not a complete solution for connection to SAP with Visual Studio 2005 or with Visual Studio 2008. There is a dll and you are using that dll, and also let's try to use calling a function with this solution? You will see that this solution is valid with data read. But you can not use this solution update SAP table data. And there are bapis of SAP. Of course you can not use this solution calling this bapi. Please, examine the SAP.NET connector's mission. It is not only used reading data!
 
2. You mentioned that you can use softwise. Of course you can use another THIRD PARTY solutions to connect SAP. But, please focus that this solution with SAP.NET Connector. SAP.NET Connector is produced by SAP AG. And some developer's firms may not to use third party solutions.
 
3. Thank you for your stars.
 
4. Nobody said that you are deploying this solution with another machine. This is only for demo and shows the basic important points. But again, thank you for your contribution.
 
Yes SAP has a solution to this problem as my explanation. But this article has more explanation then that article. Also, an article in codeproject is doctorate thesis? Of course there will be smilar articles and nobody said there were no solution until I published this article. I only want to share my knowledge.
 
And, I see that one of codeproject member has a thank for my article. That is important for me. Other unfairly comments are not important for me. You can take help with this article or not. That is not important for me. I only want to help people.
 
I will not give answer like this comments. If you face with technical problem, I want to help you if I can.
 
Regards,
 
Huseyin Akturk
Generalthanks.. PinmemberJuraj Suchan24-Apr-09 20:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140926.1 | Last Updated 24 Apr 2009
Article Copyright 2009 by huseyinakturk
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid