Sign in
Microsoft.com
 
SharePoint Products TechCenter
 
 
 
SharePoint Products TechCenter > SharePoint Products and Technologies Forums > SharePoint - Business Data Catalog > Connecting SAP to Sharepoint through BDC --> Working example
Ask a questionAsk a question
Search Forums:
 

QuestionConnecting SAP to Sharepoint through BDC --> Working example

  • Thursday, October 11, 2007 11:05 AMwobauer1 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    2
    Sign In to Vote

     

    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.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    • Edited byMike Walsh MVPMVP, ModeratorFriday, November 13, 2009 8:31 AM!!! removed from Title. Never use exclamtion marks in Title. Also in future don't post unsolicited answers wait for a suitable question
    •  
     

All Replies

  • Wednesday, December 12, 2007 10:46 AMAditiS Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    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
     
  • Tuesday, November 03, 2009 10:52 AMRobin Boer Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    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