Look up's in SAP XI

[Former Member]

Hi,

What is Lookup's In SAP XI. Please let me know ASAP.

[aashish_sinha]

Hi,

You can refer to these links.

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

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

For Java APIs and also here you can map that how many types of lookups are possible in XI.

http://help.sap.com/javadocs/NW04/current/pi/com/sap/aii/mapping/lookup/package-summary.html

Regards

Aashish Sinha

PS : reward points if helpful

[Former Member]

Hi,

when evr you are working based on a condition for example.

You want to place a PO to the existing Vendors .

For this purpose first of all you have to look and check whether this particular Vendor is registered vendor or not .

For this purpose the data of all existing Vendors is maintained in the data base or the flat file .

Once the message has come in it will be validated against the available vendor list.

I think now you got the clear picture of Look up.

__Simply speaking .__

Forget XI and see this.

When you are trying to see a word file.

You will see a small window on the right side.

There you can find the look up, which shows the list of all similar names available in the word file.

If not clarified give reply,

else dont forget to give points

[Former Member]

Hi,

What is Lookup and why we need:

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

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

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

Please reward points if it helps:

Thnx

Chirag

[Former Member]

Before posting the question do a search on the topic.

I strongly suggest you read the Rules of Engagement before posting any further question.

Regards,

Jai Shankar

[Former Member]

Yes Shankar,

I will agree with you, but i am a fresher in SAP XI, So i am not getting, please let me know the Lookup's in Own words.

[Former Member]

Hi Raj,

in simple words...

by using graphical mapping in Xi u can look for values in R/3 side...

u use JCOs for this purpose....

There are three types of look ups u can do

RFC look up

SOAP look up

JDBC look up

rfc

Use this crazy piece for any RFC Mapping Lookups!

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

SAP XI Lookup API

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

Lookup’s in XI made simpler

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

U can get some more links in SDN

Reward points if useful....