Thursday, November 11, 2010

Guide with screen shots on configuring RFC in BI7 for connecting to ECC6 Server.

1.T-code SM59
2.Use SAP standard connection for RFC under ABAP:
3.Go to T90CLNT090 which is standard RFC connection and exists both in BI7 as well as in ECC6 IDES.
4.Double click to edit settings for this RFC connection. You need to specify the IP for the ECC6 server and create a password for the default USER “Connector” for both ECC6 server and in BI7 server. Usually, in ECC6 server, the user “Connector” is already created by default and is locked. You need to unlock it and give it the same password as given in BI7. Enter the description, Target host, System number. Press Enter to confirm your entries and save.
5.Go to Logon and Security Tab and enter a password for user “Connector”. Remember to enter the same password in ECC6 server for user “Connector” under T-code SU01 (and unlock the user “Connector” in ECC6 server also, if locked). Let’s say you have entered “sap12345” as password in the screen below for user “Connector”.
6.Save your settings in this BI7 server, logon to your ECC6 server and enter T-code SU01. First make sure that the user “Connector” is unlocked.
7.Enter the same password as selected in previous screen 5 “sap12345” using the “change password” button on the top of screen below.
8.Save and exit from ECC6 server. Return to your BI7 server screen where you left it previously i.e. at the RFC destination screen in step 5. Press button “Connection Test” to test your connection settings.
9.You will see following screen if your connection settings are successful.
10.Press Back button. Now test if user “Connector” can logon to ECC6 server for data extraction. Click on “Remote Logon” button on top of the RFC connection screen.
11.If your settings are correct, you should be able to logon to your ECC6 server from this screen directly.
12.You have successfully logged on to SAP ECC6 server from SAP BI7 using User “Connector”. The two systems are now connected successfully.

Create RFC connection in SM59 in both the systems.

Create a logical client with the naming convention CLNT and give this format in the RFC connection.

After its all done, go to RSA1 in BW system and go to source system in the left side. click that..

you would get the options in the screen. Select SAP and right click to that.. Click Create and select the RFC connection which was created respective to the ECC system.

And give the userid credentials in the popup. ie., background user in source system ie., ECC and the back ground user in BW system.

Both the back ground user should be system user with SAP_ALL and SAP_NEW access. The password should be CAPS.

Create one more dialog user with SAP_ALL and SAP_NEW access in the ECC. because when you are creating source system connection in RSA1, it would navigate to ECC system, that time you have to login to the ECC server with the administrator id.

Check the RFC connection and come back to RSA1, replicate the mata data there. Then the source connection would be established.


  1. hi i was looking for conection between BI and CRM. crm is in vmware(virtual desktop) how can i get rfc connection between both vmnet8 vmnet1 bilan sap subnetmask

    no default gateway crm subnetmask ths is my mail id..pls mail the solution pls

  2. Hello Brother,

    Could you please send the documentation, I am student, i am doing thesis on SAP BW, i need it desperately...


    Thanks a lot brother...

    Thanks and Regards
    Bharath Kumar