cancel
Showing results for 
Search instead for 
Did you mean: 

XI Lookups..

Former Member
0 Kudos

Hi,

Let me know the use of the XI Lookups.

Why we are going for lookups in JDBC connections?

In which situation we have to use this lookups?

In what all are the adapters are we using this lookups?

How we have to create the lookups?

Thanks in Advance.

Jane.

Accepted Solutions (0)

Answers (4)

Answers (4)

agasthuri_doss
Active Contributor
0 Kudos

Hi,

This will help you

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

Regards

Agasthuri Doss

Former Member
0 Kudos

HI,

XI lookups : When you want some data from R3 or DB into mapping , then you need to use some kind of user exit like Lookup, it will stop the execution process and goto respective database and get the data and back to mapping , this kind of machanism.

We will use DB lookups for any other database like DB,Oracle,SQL, MS Access..etc.

We will use RFC lookup for SAP R3 .

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

/people/sravya.talanki2/blog

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

Regards

Chilla

Former Member
0 Kudos

Jane,

Mapping programs (message, Java, and XSLT mappings) are executed on the Integration Server, where they can access the global value-mapping table (see Executing Value Mappings) and mapping runtime constants. In addition, calls to other application systems are sometimes necessary to meet the following requirements:

● To get read access to application system data in the mapping program

● To call existing mapping routines in the application system

<b><i>In what all are the adapters are we using this lookups?</i></b>

The API for mapping lookups supports access using the RFC, JDBC, and SOAP adapters

<i><b>How we have to create the lookups?</b></i>

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

---Satish

Former Member
0 Kudos

Hi Jane,

see HowTo Guide:

How to Perform DBLook-ups from XI Utilizing J2EE JDBC:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/9aedca11-0d01-0010-3b90-9ea...

Regards Mario