Skip to Content
avatar image
Former Member

lookup

hi friends,

what is a lookup?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 03, 2007 at 08:01 AM

    Database lookup in XI

    /people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

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

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

    Mudit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2007 at 08:06 AM

    1)what is lookups

    Lookups are used to identify / request the data from mapping , i mean interupting the process and looking for data which was stored in some where and get that data and comback to process and continue with that data.

    2.why we can use for lookups.

    We will use these type of lookups in Message mapping for refering DB Lookup for data base which is not SAP, RFC lookups for SAP data

    3.what is rfc lookup.

    RFC Lookup is for accessing the SAP Data from mapping

    4.what r the steps in lookups.

    see the below links

    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

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

    Also read thru this to get more idea on lookups -

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0

    LookupÂ’s in XI made simpler - /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

    How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    /people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

    Lookups - /people/morten.wittrock/blog/2006/03/30/wrapping-your-mapping-lookup-api-code-in-easy-to-use-java-classes

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

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

    http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

    /people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

    Lookups with XSLT - https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8e7daa90-0201-0010-9499-cd347ffbbf72

    /people/sravya.talanki2/blog

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/05a3d62e-0a01-0010-14bc-adc8efd4ee14

    5.where we can use lookups.

    in mapping

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2007 at 08:07 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Let us say you are sending Material Information from File1 to File 2 Using XI.

      File1 contains the following information

      Material Number Unit of measure

      001M1 CM

      002M2 ME

      003M3 FT

      File2 wants the Unit of Measure to be presented in a different format. For example they want CM as Centimeter, ME is meter, FT as Feet .............

      The conversion information will be stored in a Database table

      Conversion Table

      F1UOM F2UOM

      CM Centimeter

      ME MEtere

      FT Feet

      ......................

      So Inside your XI, once you read a record from the file1, you have to convert the UOM to the File2 requirement, so you will read the DAtabase table to find the appropriate value for the File2 and then you will send that information to File2.

      The above process is called Lookup or cross reference.

      If the lookup table is very very small, say less than 20 entries, you can maintain that information in value mapping inside XI, if you have a large lookup information then its better to maintain that outside XI.