Look Ups

[Former Member]

Can any one explain me the Concept of Database LookUps...i would prefer a general example instead of the Links

Thx..

Prasad

[Former Member · Accepted solution]

Hi,

You can do RFC Lookup withinh UDF.

suppose you want search for Mateial number in MATNR table...

and assign corresponding values based upon lookup value to the target field.

You can also use Jco to connect to r/3.

But it will take a lot of memory.

Regards,

Akshay.

• Dont forget to reward points.

[Former Member]

check this

LOOKUPS:

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

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

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

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

How we have to create the lookups?

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

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

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

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