Lookups

[Former Member]

What is LookUp's in XI

[prateek · Accepted solution]

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

Search facility on sdn ll be good for this option

Regards,

Prateek

[Former Member]

Hi Mahesh,

Please go through this thread.

Ranjeet singh.

[Former Member]

Hi,

Within an XI mapping it is a common requirement to be able to perform data lookups on-the-fly. In particular, there may be a need to look up some data that is maintained in an R/3 application.

In the error handling topic we have seen the different validations which need to be performed on file. This can be done through Lookup.

Some use cases:

• Look up material number from table MARA.

• Look up cost center budget.

• Look up employee information.

• Look up unit-of-measure (UOM) information from table t006a.

• Lookup for raising an alert.

The purpose of the lookup may be:

• To perform application-level validation of the data, before sending it to the backend.

• To populate fields of the XML document with some additional data found in the backend application.

This is a form of value transformation.

The "value mappings" offered by XI are not adequate in this case, since the data would have to be manually entered in the Integration Directory.

There are two ways in which we can do lookup:

• Call lookup method from GUI mapping.

• Call lookup method from XSLT mapping.

Lookup method from GUI mapping can be called using any of the following ways.

• RFC lookup using JCO (without communication channel)

/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups

• RFC lookup with communication channel.

/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

• Lookup using JDBC adapter.

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

/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi

• CSV file lookup.

/people/sundararamaprasad.subbaraman/blog/2005/12/09/making-csv-file-lookup-possible-in-sap-xi

thnx

Chirag

[turmoll]

Hi,

Have you checked sdn.sap.com, help.sap.com and google.com before asking the question?

Suppose not ...

Many people have already asked that question and received an answer.

Regards,

Jakub

[Former Member]

Lookup...

When you need to retrive some data to another system, ex. if you need to convert a information send to the A system in another for the B system, like the Unite of measure, you can use a lookup.

We have 2 differnt type of lookup: RFC or JDBC.

JDBC lookup: you can read a table using a standard SQL string and the parameter in a JDBC channel in a UDF

RFC lookup: you can call a SAP RFC in a UDF using the JCO.