cancel
Showing results for 
Search instead for 
Did you mean: 

DB LookUps Step By Step procedure

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi Frnds,

Can any one explain the process of DB Look Ups, and why we go for DB Look Ups.

Because i am struggling to understood the concept,

Can any one share some good links,thats very use full to me.

Thanks,

Raj

Accepted Solutions (0)

Answers (3)

Answers (3)

rajasekhar_reddy14
Active Contributor
0 Kudos

THANKS

Former Member
0 Kudos

Hello,

Refer the blog :

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

Accessing data from an external database is the objective of DB lookup.

When it is used : -

The data required to be accessed from an external database residing on some other system.

How it is called:

Called from within the XI Mapping Program.

Introduction

Objective:

Data LookUp from an external database.

Proposed Solutions:

1) Import the data from the external system perform a value-based-transformation.

2) Execute a call to an external database with the purpose of accessing the desired data.

3) BPM can be used to perform Data Look Ups.

Business scenario

Simple Data lookup.

Source:

Inbound Document contains “EN”.

Target:

Outbound Document should reflect the value “ENGLISH” as an expansion for “EN”.

How?

The translation data or logic is contained in external database. Mapping program calls it through Data LookUp.

Hope this helps

*****Reward points,if found useful

Former Member
0 Kudos

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

Thanks,

Vijaya.

vijay_kumar133
Active Participant
0 Kudos

Hi,

Dblookup is very usefull. i will explain with an example.. in the sender sider side u have one filed but you need to map another filed which is not in the input structure.. that is filed is stored in a table. then we go for dblookup to pick that perticular value from database corresponds to the field in structure...

that if we have a table in which fields are A,B,C,D.

And in mapping part at sender side u have fields Z,Y,X,A and u need to send the value B to receiver side. then u make use of Lookup and pick the value of B coreesponding to Value A.

u can do it practically by using this blog.. if u get doubt keep posting ..

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

Ragards

Vijay