Connecting SAP to Sharepoint through BDC --> Working example

Question

 

Hi all,

 

i want to show you a easy example how you can connect SAP to Sharepoint through BDC.

The example should show a SAP table in Sharepoint.

 

1. Create a remote-enable function module (i. e. ZWEBSERVICE).

- Attributes: enable remote-enabled fm

- Tables: aufk like aufk

 

The code should look like this:

FUNCTION ZWEBSERVICE2.

*"----------------------------------------------------------------------

*"*"Local Interface:

*" TABLES

*" AUFK STRUCTURE AUFK

*"----------------------------------------------------------------------

select * from aufk

into aufk.

append aufk.

endselect.

ENDFUNCTION.

 

2. Go to the menu: Utilities --> More Utiliities --> Create WebService --> From The Function Module

- Service definiton: i. e. ZWebservice

- Short text: i. e. ZWebservice

- Check mapping the names

- Basic Authentification

- Check Release Service for Runtime

 

3. Go to the webservice

- move to the input-parameters --> Aufk

- uncheck exposed -> on the right side

 

4. Go to transaction wsconfig:

- service definition = ZWebservice

- Variant: select the variant --> only one is available

- go to ICF details

- go to logon tab and specify a SAP user to get access to the SAP system

 

5. Go to transaction wsadmin:

- select your webservice

- push WSDL button (Crtl + F1) --> get WSDL (if no http port is specify go to transaction smicm create one)

- save the WSDL-file

 

6. Go to the Business Data Catalog Definition Editor (included in the MOSS SDK 2007)

- create lob system

- add web service

- go to instances --> add a finder instance --> test the instance

- export the application file

 

7. Go to the Sharepoint Central Administration

- SharedServices1

- Import Application Definiton

 

8. Go to the portal and create the web part business data list

- specify your entity

 

 

Now the data should be successfully displayed in a table.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Answer 1

Hi wobauer1,
  when I click on Connect in the BDC Definition Editor to connect to a SAP Webservice it gives me an error alert
"The HTML document does not contain the Web Service Discovery Information" . I can access the webservice url from the browser though.
Any clues? Did you encounter this?
Thanks a lot
Aditi

Answer 2

Hi,

What I have done is point to the WSDL file (example: "c:\wsdl\sap.wsdl")
I can't get the security to work properly though but maybe the above helps you (after 2 years :P)

gr,
Robin