Hi friends, pls explain What is DB lookups in xi

[Former Member]

1)pls explain What is DB lookups in xi. how many types ?

[Former Member]

Simple, I have Source messag and Target message, now I want to map some information in the target message..that is not coming from the sender, but I want this information from external systesm(say Database, RFC, Webservice)

So to get this in your mapping programme, have to use the concept of Lookup API. so in the mapping programe you can achive it..

Thanks

Farooq

[Former Member]

Hi,

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

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

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

Regards,

Priyanka.

[Former Member]

Hi Ganga,

With the Lookup API you can also call remote application systems via adapters during the execution of a mapping program. You can use the Lookup API to read data from the application system or to execute an existing mapping on the application system. The call to the application system is synchronous. Lookups are possible via the central adapter engine. The Lookup API supports the RFC, JDBC, and SOAP adapter.

If you want to use an adapter of a third party vender, then the adapter must fulfil the following preconditions:

The adapter must support synchronous calls.

The adapter must not use information of a Receiver Agreement.

Also refer the following link for External DB lookups overview:

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

Regards,

Shibani

• Reward with points if helpful**

[Former Member]

Hi ganga,

Db lookups are those tables which are constant, this tables will also give reference to Dynamic tables ...........so these tables are also called Static tables............Generally XI DB lookup is done in the ABAP Table(which is created the Data Dictionary Transaction code "Se11") ..........You can go and check for Lookuptables in Se11 ..........................

Reward with points if helpful

Regards

Sai Ganesh

[GabrielSagaya]

Lookup in XI is used to call the target data storage system and get data from there to your mapping programme.

In XI you can do Lookup in Message Mapping, Java Mapping and in XSLT Mapping. Previously Lookup in XI was system dependent. But now what ever the system are i.e. SAP system or non-sap system(Oracle,MS SQL etc) lookup API are same.

Overview of Lookup

- Lookups are used to identify/request the data from mapping program.

- It interrupt the process and looking for data which was stored in target system.

- It get that data and comeback to process and continue with that data.

Types of Lookups in XI

- JDBC Lookup: JDBC lookup is used for accessing data from database (non SAP).

- RFC Lookup: RFC lookup is used for accessing the SAP Data.

- SOAP Lookup: SOAP lookup is used for accessing data from Webservice

Steps to perform Lookup in Mapping

Import package com.sap.aii.mapping.lookup.*;

Create connection to the target Database system.

// Determine communication channel created in ID

Channel channel = null;

channel = LookupService.getChannel("DB-SYSTEM-NAME","DB-CHANNEL-NAME");

// Get system accessor for the channel.

DataBaseAccessor accessor = null;

accessor = LookupService.getDataBaseAccessor(channel);

Build the Query String.

Getting Result

// Execute Query and get the values.

DataBaseResult resultSet = null;

resultSet = accessor.execute(Query);

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

[Former Member]

check this blog

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