Skip to Content
The blogs describes how to make a backend connection to the r/3 from the Portal .The reason for writing this blog was to clearly mention the steps needed to make a conncetion.

  • Navigate To System Administration –> System Configuration–>System Landscape–>Portal Content.
  • Create a Folder There Say Sap_Sytems.
  • Right Click on the Folder and Go to New , Select System from Template.

image

           The screen shows names of the system to which the connection are supposed to be made, I am showing how to make the backend connection to an R/3.

  • Choose SAP system using dedicated application server(if you are using the Load balancing you need to give certain extra parameters while you make the connection such as the group).
  • Fill in the Name and the id for the system, click on finish .
  •          Choose open object for editing.(even though you miss this out it can be selected by clicking on the Sytem Name.).

  • From the Property Editor , Select Connector.
  • image

    Following Fields are mandatory , Application Host ( Name of The application server to which the connection is supposed to be made).

    • Gateway Host
    • Gateway Service
    • Logical System Name
    • Sap Client
    • SID
    • SAP System Number
    • Server Port
    • System type (In My Case iam choosing it as R/3).

    • Once this has been done Navigate to User Management in the Property editor

    image
    Select The user mapping as shown in the Figure.
    If you have choosen SAP_BW in the Starting instead of SAP_R.3 you need have to perform an extra step.

    • Navigate to web application server (WAS) available in the property editor.
    • image

    • In the web as host name you have to enter the path of the server and port number. The Port number can be obtained by logging to the BW server and running the transaction “SMICM”.
    • Click on this icon imageto know the port number.
    • The next step is to define the system alias for the system which we have created. Navigate to Object and select system alias for the system.
    • Once the system alias is defined we need to map the user to that particular system. Navigate to User Management„³Identity Management (This is in EP 7 ) Find the user and define the login credentials for the system which has been defined. The last step is to test whether the connection which we have made is working fine or not . Navigate till the position where you have defined the System .Select Connection test from the Object , and press test.If the connection is working fine it will display the success message else go through the message as it clearly displays the error.

To report this post you need to login first.

13 Comments

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

  1. Parag Jain
    it covers the exact steps that one is looking for when one comes across this scenario. One can always achieve this by looking at various sources of information(help pages, forums, etc.), but think of it as a compendium blog. I am sure many of us face this situation.

    To build upon what Vinnie mentions here – http://dealarchitect.typepad.com/deal_architect/2006/05/saps_sdn_wheres.html atleast each one of us is not spending client dollars (searching) everytime we come across this scenario.

    Pankaj: Another good source of information for this scenario is the SAP Best Practices document.
    http://help.sap.com/bp_epv170/EP_US/BBLibrary/documentation/N03_BB_InstallGuide_EN_US.doc

    I have a recommendation: SAP could “promote” some of the so called beginner blogs and include them in the Best Practices catalog to cover up for the gaps.

    (0) 
    1. Michael Nicholls
      I realise it’s aimed at beginners, but it doesn’t actually cover one of the most common questions, which is “Which template should I use”? This is fairly critical.

      Also it doesn’t talk about the ITS settings (or why they’re necessary) or the WAS settings, except in the case of a BW backend.

      In terms of inaccuracy, amongst other things it claims that the gateway properties and logical system name are mandatory.

      Regards

      (0) 
      1. Anonymous
        Hi Michael,

        Thanx for the suggestion, i do agree i missed on certain keys aspects in the Blog.

        For a note:-
        We need to use system template,The reason to configure WAS is to access a back-end BW application, and to be included it in the portal system landscape.

        ITS:-
        An integral component of SAP’s mySAP product group, the Internet Transaction Server (ITS) is the interface that enables efficient communication between an R/3 system of applications and the Internet. The ITS links an R/3 application server and a Web server, controlling the flow of data between them and enabling user access to Internet application components (IACs), which are Web-enabled business applications for the R/3 system. transactions are executed within the R/3 system. The ITS adds a presentation layer: it presents an HTML page for each transaction screen, and uses templates to incorporate changes.
        The ITS is made up of WGate and AGate. When a user, who may be located anywhere with Internet access, enters or clicks on a URL to request an ITS service (an Internet application based on an IAC), their Web browser passes the request to the Web server.

        Configuring ITS:-

        1)Right-click on the name of the SAP System which we have created to set up the ITS connection ,choose Open -> Object
        2)In the Property editor from the dropdown choose ITS.
        3)Then Enter The follwoing fields
        ITS Description–
        ITS Host Name(hostname:portnumber)
        ITS Path– generally (scripts/wgate).
        ITS Protocol– http or https(remeber the port number aslo changes if we use http/https).

        Thanks & Regards
        Pankaj

        (0) 
  2. sarasakumari balakrishnan
    Hi,

        The blog explains abt all the parameters like appln host, logical systems,port etc.. i need to know how to find and where to find the related information in r/3..

    thanks in advance
    sarasa

    (0) 
    1. Anonymous
      Hi Sarasa,

      Iam nt much into the abap side so wont be able to say the transaction but one thing for sure there are transaction which has all the data realted to ur query.

      Thanx
      Pankaj Prasoon

      (0) 
    2. Michael Nicholls
      There is a wiki page that deals with connectivity here that mentions some of the values you need and provides a link to a Java application that you can use to obtain the details.

      Cheers

      (0) 
  3. venugopal acharyulu
    Hi Pankaj,
    Thanks for throwing the light on the primitives how to connect to R/3 from Portal.  Currently I am using  EP7.0 version and back end ECC6.0.  I am using SAP Log On Ticket instead of UID/PW.  In this case, how to do the settings in the UME?
    Currently, I am using WebAS6.40..Is it essential to set ITS properties ?
    Pl give your comments.
    Regards
    (0) 
  4. Michael Nicholls
    How are they logging on? If you mean through SAPGUI for HTML, then you need to make sure your ITS settings point to a SAP Web Dispatcher. If it’s through Web Dynpro Java apps, then make sure your JCo destinations are set correctly.
    (0) 
  5. Tushar Shinde
    Hello Pankaj,
                  First of all, I appreciate your inputs and contribution in SAP Community, your inputs are really helpful.
                 We are able to configure Connection to Corporate LDAP Directory, but the Problem, we are facing is, Currently the LDAP username that are created contain more than 12-Chars for some Users and the problem is in SAP R/3 the username cannot be created with more than 12 chars, in that case are SSO that is configured is not working because if the user with having username more than 12 chars than he is not able see the Portal UWL items coming from R/3 and as well as the SSO is not working for JCo connections.
                   Also the requirement is to access Outlook via portal. Is there any solution for my problem, My client is not ready to change the existing UserIDs in LDAP to 12Chars citing the reason of communication overhead. The Client had added a Unique Attribute in ADS i.e Employee Id, but can I use it instead of using the Login ID.
    Please give me some inputs to configure the LDAP in our Landscape.

    Whether I can do the User Mapping without changing the UserName length in LDAP.

    I got few suggestions from SDN for using  REFERENCE_SYSTEM_USER, I tried below steps related to it,
    but I am not sure it is correct or not,

    1. Created a System in Portal SLD,
        I had a Question here, is there anything that I have to mention in User Management related Properties for User Mapping purpose.
    2. Changed the UME config file by adding the following code,
                   
                           
                                                       

                   

         Wherein, “Empolyee ID” is the Custom attribute that is present in ADS (LDAP). I hope this is the correct way.
    3. Changed the ume.usermapping.refsys.mapping.type property value to “attribute”.
        is it correct or some other value needs to be mentioned here.

    Please do let me know if anything more needs to be done.

    I guess User Mapping is the only solution for my Problem, but this is my First LDAP Exp and a bit confused with it.
    Do give some inputs or you can also mail your feedback on.

    tushar.shinde20@gmail.com

    Thanks a Ton and God Bless You.

    (0) 

Leave a Reply