cancel
Showing results for 
Search instead for 
Did you mean: 

DB Look up usage

Former Member
0 Kudos

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.

Thanks in advance.

Regards,

Sudharshan N A

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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-cd347ffb...

/people/sravya.talanki2/blog

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

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

Former Member
0 Kudos

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