Skip to Content
author's profile photo Former Member
Former Member

look up

hi friends,

pls help on this topic,How many types of Lookup's techniques XI provides? what were they? explain steps in RFCLOOKUpAPI?


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 27, 2007 at 03:35 PM


    You can refer to these links.

    /people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer Absolute stealer.


    For Java APIs and also here you can map that how many types of lookups are possible in XI.


    Aashish Sinha

    PS : reward points if helpful

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 27, 2007 at 03:38 PM

    Hi Ravi,

    1) RFC Look up

    2) DB Look up

    For DB Look up check out this blog by Siva:


    For RFC Lookup check out this blog:




    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI Ravi,

      What is Lookup and why we need:

      Within an XI mapping it is a common requirement to be able to perform data lookups on-the-fly. In particular, there may be a need to look up some data that is maintained in an R/3 application.

      In the error handling topic we have seen the different validations which need to be performed on file. This can be done through Lookup.

      Some use cases:

      • Look up material number from table MARA.

      • Look up cost center budget.

      • Look up employee information.

      • Look up unit-of-measure (UOM) information from table t006a.

      • Lookup for raising an alert.

      The purpose of the lookup may be:

      • To perform application-level validation of the data, before sending it to the backend.

      • To populate fields of the XML document with some additional data found in the backend application.

      This is a form of value transformation.

      The "value mappings" offered by XI are not adequate in this case, since the data would have to be manually entered in the Integration Directory.

      There are two ways in which we can do lookup:

      • Call lookup method from GUI mapping.

      • Call lookup method from XSLT mapping.

      Lookup method from GUI mapping can be called using any of the following ways.

      • RFC lookup using JCO (without communication channel)


      • RFC lookup with communication channel.


      • Lookup using JDBC adapter.



      • CSV file lookup.


      Lookups with XSLT -


      DB lookup - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

      SOAP Lookup - /people/bhavesh.kantilal/blog/2006/11/20/webservice-calls-from-a-user-defined-function



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.