Skip to Content

SAP BODS – SAP ECC Connection Setup & Datastore Creation in Data Services

February 20, 2013 | 11,893 Views |
 bodibodsdata integratordata servicesdata services 4.0data services 4.1
Follow

Hi Friends

The below content explains step by step procedure of establishing connection between SAP ECC and SAP Data Services.

followed by creating datastore from SAP Dataservices which connects SAP ECC.

Steps to Connect BODS and SAP:

Go to the below directory in the Dataservices Application Server.

D:\Program Files (x86)\Business Objects\BusinessObjects Data Services\Admin\R3_Functions\transport

(We require the below files to get connected to SAP ECC and view the metadata of SAP ECC from SAP Dataservices)

copy K900086.R63(co-file) and paste in D:\usr\sap\trans\cofiles

Copy R900086.R63(data-file) in the same directory and paste in D:\usr\sap\trans\data

Logon to SAP ECC :

Go to transaction STMS.

Press F5 or click on Truck icon under Transport management system.


Under Queue, double click on our system name. for example EH4.

     Go to Extras in the toolbar—>other requests—>Add.

    You will see a popup window as Add Transport Request to Import Queue.

     Press F4.

     You will see popup window with a single tab Restrictions, under this tab you should notice our co-file R63K900086.

     Click on Tick mark

     Click Yes.

     Select Queue tab then select Start Import at upper left corner or simply press Ctrl+F9.


    Enter target client 800, and select radio button Immediate.

    Click on continue(Tick) mark.

Observe tick mark under St(status)


Goto /nSE37.


   Press F4. 

   Press Enter.

Click on Test/Execute or press F8.


Again click F8.


Click on (Save)Continue or press Enter.


You will notice a screen Test Function Module: Result Screen.


In BODS Environment


Logon to BODS and login to Designer

Creation of SAP Application Datastore

Go to Designer and create new Data store .

You will see Create New Data Store window.

there, fill the following details:

                                    Data Store Name: SAP_DS (some meaning full name)

                                    Data Store Type: SAP Applications

                                    Application Server: XXXXX (ECC app server details, we should get from basis/customer)

                                    User name: XXXXX  (we should get from basis/customer)

                                    Password: XXXX  (we should get from basis/customer)

Click on Advanced>> tab and fill the following details.

                                    ABAP Execution option: Generate and execute (this detail depends upon the box which we are using)

                                    Client No:800

                                    System No:15

                                    Data Transfer method: Shared Directory

                                    Working directory on SAP server: D:\usr\sap\<XXXXX>\work\BODS Data (we should get from basis/customer)

                                    Application path to the shared directory: D:\usr\sap\<XXXXX>\work\BODS Data (we should get from basis/customer)

                     

     Click Apply.

     Click Ok

    Note that the Data store (SAP_DS) name in  Local object library, under  datastores.


We have successfully established connection between BODS and SAP ECC and now we can get SAP table data.

I would like to thank my friend Bala Krishna who assisted me a lot in creating this document.

Hope this will be useful for you…please get back to me if you have questions/clarifications..  

Thanks

Narayana Murthy

To report this post you need to login first.

14 Comments

You must be Logged on to comment or reply to a post.

  5. Trevor Cowan

    Hi,

    when I follow the steps above and leave the program name blank the function module returns the exception PROGRAM_DOES_NOT_EXIST.

    The ABAP in the FM raises the exception when no entry is found in table D010SINF.

    Please advise.

    Regards,

    Trevor.

    (0) 
    1. Former Member

      Hi Trevor,

      Hope you are doing good.

      I am facing the same issue now, could you please suggest how to trouble shoot this issue?

      Thanks,

      Abhinav

      (0) 
  6. Former Member

    Hi Narayana,

    These steps are needed when SAP ECC is source for BODS?

    – Do we need any RFC connections(SM59)

    – Any transport import has to performed at source SAP ECC system as well?

    Awaiting for your inputs and Thanks in advance !!

    Best Regards,

    MIshra

    (0) 
    1. Former Member

      Hi Aks,

      in the above example, as data transfer method is shared directory, RFC connection is not required . RFA is among one of the data transfer method, if this is used then RFC connection has to be established at SAP server(SM59) and BODS(management console).

      Hope that helps

      Thanks

      Shashi

      (0) 

Leave a Reply