cancel
Showing results for 
Search instead for 
Did you mean: 

PI 7.1 Lookup Concepts

Former Member
0 Kudos

Hi Experts,

What is the concept of lookup?

Where we used Lookup and how many types of Lookup?

What is the major difference between Lookup in PI 7.0 and PI 7.1 ?

Sri

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

>> What is the concept of lookup?

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.

>> Where we used Lookup and how many types 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);

>> What is the major difference between Lookup in PI 7.0 and PI 7.1 ?

In PI 7.1 you need not to write UDF for lookup while in PI 7.0 UDF is required in mapping

Abid Mazhar

Answers (3)

Answers (3)

jyothi_anagani
Active Contributor
0 Kudos

Hi,

You can search in SDN before posting the question.

Read this blog. You will understand why lookup is needed.

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

Thanks.

former_member556412
Active Participant
0 Kudos

Hi,

Please refer to the following link.

Regards,

Bhanu

former_member181962
Active Contributor
0 Kudos

Hi ,

Please search the forum before posting your queries.

For your question you will get a lot of helpful links

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20befc9a-aa72-2b10-ae9b-b0988791...

REgards,

Ravi