lookup

[Former Member]

hi friends,

what is a lookup?

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

hello,

can you give definition

[Former Member]

Hi,

LookUp's can be done on RFC's, JDBC and SOAP.

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

regards

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

[Former Member]

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

/people/sravya.talanki2/blog

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

5.where we can use lookups.

in mapping