on 06-21-2008 4:42 AM
What is 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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Lookups are used to identify / request the data from mapping , i mean interupting the process and looking for data which was stored in some where and get that data and comback to process and continueWe will use these type of lookups in Message mapping for refering DB Lookup for data base which is not SAP, RFC lookups for SAP data with that data.
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
Lookupu2019s 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
cheers
Edited by: vemuganti naga phalguna on Jun 25, 2008 1:29 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Cross referencing or Look Up at its simplest is the process of taking a source data value, comparing that source value to a list of values on an external data source (normally a relational datastore), retrieving the corresponding target value, and applying that target value to the outgoing data stream to allow proper identification in the recipient system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
what is lookup
Lookups are used to identify / request the data from mapping , i mean interupting the process and looking for data which was stored in some where and get that data and comback to process and continue with that data.
why we can use for lookups.
We will use these type of lookups in Message mapping for refering DB Lookup for data base which is not SAP, RFC lookups for SAP data
Let us say you are sending Material Information from File1 to File 2 Using XI.
File1 contains the following information
Material Number Unit of measure
001M1 CM
002M2 ME
003M3 FT
File2 wants the Unit of Measure to be presented in a different format. For example they want CM as Centimeter, ME is meter, FT as Feet .............
The conversion information will be stored in a Database table
Conversion Table
F1UOM F2UOM
CM Centimeter
ME MEtere
FT Feet
......................
So Inside your XI, once you read a record from the file1, you have to convert the UOM to the File2 requirement, so you will read the DAtabase table to find the appropriate value for the File2 and then you will send that information to File2.
The above process is called Lookup or cross reference.
If the lookup table is very very small, say less than 20 entries, you can maintain that information in value mapping inside XI, if you have a large lookup information then its better to maintain that outside XI.
Also read thru this to get more idea on lookups -
http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0
Lookups 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
Thanks,
Vijaya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi krishna Prasad,
what is lookups
Lookups are used to identify / request the data from mapping , i mean interrupting the process and looking for data which was stored in some where and get that data and comeback to process and continue with that data.
2.why we can use for lookups.
We will use these type of lookups in Message mapping for refering DB Lookup for data base which is not SAP, RFC lookups for SAP data
3.what is rfc lookup.
RFC Lookup is for accessing the SAP Data from mapping
4.what r the steps in lookups.
see the below 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
Lookupu2019s 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
LookUp's can be done on RFC's, JDBC and SOAP.
Please go through the following links.
http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/frameset.htm LOOK UP
/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler DB LOOK UP
/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi DB LOOK UP
/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups RFC LOOK UP
/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups RFC lookup using JCO (without communication channel)
/people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer RFC lookup with communication channel.
XI system is to be configured as mentioned in the post installation steps.
You need to use a RFC receiver communication channel and just mention the XI server hostname with appropriate user (having autorizations for RFC call).
Just one more thing.We had to transport these changes to QA and prod systems hence we preferred using Business Service rather than Business System .While transporting, the name of the business system changes while in the lookup API code we have to hardcode the service name.Hece we used Business service so the transported code would work fine in all systems.
refer
Mapping Lookups a RFC API
use RFC lookups https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-code-samples...
/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups
Type 3 ABAP Connection :
ex 1) If we want to execute any function module from one SAP system in another , we need type 3.
We define an RFC destination say ECC6CLNT100 with required parameters.
and to test it go to SE37, select any common sap function module and when you execute that it will ask
for RFC destination. you provide this destination and the function module will be executed in the target
system.
ex2) when you create a partner profile, you need to create a port and for creating a port, we need to
specify an RFC destination. here also we use type 3.
Type H.
ex1) when we need to send xml messages from an SAP system to any other system, we need this.
For example when we send messages using proxy from SAP system to the integration engine of XI, we
need type H.
Type T.
ex1) To we make an RFC call from R/3 to XI , we use sender RFC adapter in XI.
In R/3 system we need to create an RFC destination of type T.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
With the Lookup API you can 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.
1)what is lookups
Lookups are used to identify / request the data from mapping , i mean interupting the process and looking for data which was stored in some where and get that data and comback to process and continue with that data.
2.why we can use for lookups.
We will use these type of lookups in Message mapping for refering DB Lookup for data base which is not SAP, RFC lookups for SAP data
3.what is rfc lookup.
RFC Lookup is for accessing the SAP Data from mapping
4.what r the steps in lookups.
see the below 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
Lookups 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
5.where we can use lookups.
in mapping
Thanks
Vikranth
Edited by: Khimavath Vikranth on Jun 21, 2008 6:55 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Krishna,
1)what is lookups
Lookups are used to identify / request the data from mapping , i mean interupting the process and looking for data which was stored in some where and get that data and comback to process and continue with that data.
2.why we can use for lookups.
We will use these type of lookups in Message mapping for refering DB Lookup for data base which is not SAP, RFC lookups for SAP data
3.what is rfc lookup.
RFC Lookup is for accessing the SAP Data from mapping
4.what r the steps in lookups.
see the below 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
Lookups 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
LookUp's can be done on RFC's, JDBC and SOAP.
Thanks,
Radhika.
Please reward points if it is helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.