Lookup value mapping table through message mapping.

[Former Member]

Hello All,

I am working on a graphical mapping (message mapping). When trying to map the source message to the target message, I need to find out it a particular <b>key</b> exists in the <b>value mapping table</b>. Depending on the result, I need to map different source fields to the target field.

Is there any inbuilt function which will allow me to do a lookup on a value mapping table, or is it possible to lookup a value mapping table from a UDF?

Please help!

Warm Regards,

Keerti

[Former Member]

Hi,

Please see the below links for Value mapping ..

Value mapping /people/sukumar.natarajan/blog/2006/10/23/accessing-value-mapping-defined-in-directory-using-java-functions

Value mapping in XSLT /people/sreekanth.babu2/blog/2005/01/05/design-time-value-mappings-in-xslt

Value Mapping replication - /people/sreekanth.babu2/blog/2005/02/23/value-mapping-replication

Also see

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=value%20mapping%20in%20xi&cat=sdn_weblog

/people/community.user/blog/2007/01/08/valuemapping-using-the-graphical-mapping-tool

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

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=value%20mapping%20in%20xi&cat=sdn_weblog

Regards

Pradeep N

[Former Member]

Where do you maintain the value mapping table?

R/3 or a db or with in XI (Integration Directory)?

If R/3 you need to use RFC lookup api

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a03e7b02-eea4-2910-089f-8214c6d1...

Db - JDBC Lookup

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

Value Mapping

/people/community.user/blog/2007/01/08/valuemapping-using-the-graphical-mapping-tool

Regards,

Jai Shankar