on 03-28-2008 8:06 AM
Hi friends,
Can anyone please explain detaily abt db lookup. I went thru some blogs but iam not getting any clear idea. So please friends help with clear steps. I am in a urgent need of it. Nice reward points will be awarded. If possible explain with the screenshot also
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.
For DB Look up check out this blog by Siva:
/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler
also check
/people/sap.user72/blog/2005/12/06/optimizing-lookups-in-xi
regards
krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Search the blog for the DBLookup using the JDBC connector service...that is very simple and more effective.
any doubts int that let me know
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi check the below link
https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/u
uid/5365aa90-0201-0010-5a9a-e231f40187db
note:reward points if solution found helpfull.....
regards
chandrakanth.k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
check the links below:
note:reward points if solution found helpfull.....
regards
chandrakanth.k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
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.