Skip to Content
avatar image
Former Member

DB Look up usage

Hi All,

I want to know the exact usage of DB Look ups in Mapping.

Is it suited for selecting Data from DB rather than doing small look ups, i.e In Many cases BPM can be avoided if we used Look up. But is the Look up API suited for selceting cosiderable records from DB. Is it the standard way of doing.

Has it got any limitations compared to the standard JDBC Adapter Scenario.

Please share your real time experiences with look ups.

I Posted a similar thread.

Third Party WebService call: SOAP Lookup vs SOAP Adapter Scenario.

Thanks in advance.

Regards,

Sudharshan N A

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 07, 2008 at 06:39 AM

    Lookup in mapping is the feature provided by SAP to lookup the data in the target R/3 or DB systems with the API provided.

    You need to write UDF in order to implement the API's provided by SAP.Consider the below example

    VendorNumber -UDF --CURR

    The scenario is legacy to SAP. The legacy system doesn't provide the currency details. But the target field need's to be populated with currency value.

    "The business rules says there are values maintained in SAP Table where if you pass VendorNumber it will return thr currency to you"

    So what you can do? You can write UDF implementing SAP Provided API's and do a lookup in the SAP System and get back the currency value and populate them in CURR field.

    I hope it clears a bit.

    Please find the below blogs

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2008 at 06:24 AM

    Hi,

    Have alook at this, this may help you

    To Perform or to validate the data comparing with the Oracle database

    /people/shabarish.vijayakumar/blog/2006/02/13/unable-to-open-iresrid-xipipi-71-updated-for-pi-71-support

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 07, 2008 at 06:38 AM

    All about lookups

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

    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

    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

    Check this weblogs with some screenshots on how to achieve this:

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

    /people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups

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

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

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

    Add comment
    10|10000 characters needed characters exceeded