Value Mappings and Mapping lookups?

[Former Member]

Hi Experts,

I've came across a thread on SDN which is mention below.

can anyone explain me what is value mapping and fix mappings and why we need them and wht is mapping lookups?

plz refer some weblogs which can explains in detail about value mappings, fixed mappings and mapping lookups?

pts will b rewarded

thanks

Faisal

[Former Member · Accepted solution]

need more explanations

[former_member556603 · Accepted solution]

Hi,

Hope this information is useful to you..

Value Mapping Blogs.

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

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

Mapping look up API

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-code-samples...

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.

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

Look up tables

.

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

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

There are two ways in which we can do lookup:

• Call lookup method from GUI mapping.

• Call lookup method from XSLT mapping.

Some useful blogs...

/people/shabarish.vijayakumar/blog/2006/02/13/unable-to-open-iresrid-xipipi-71-updated-for-pi-71-support

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

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

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0

Lookup’s 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

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

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

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

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

/people/morten.wittrock/blog/2006/03/30/wrapping-your-mapping-lookup-api-code-in-easy-to-use-java-classes

Thanks,

Satya..

Reward points if it is useful..

[ambili_jose · Accepted solution]

Hi,

In simple words,

1. Fix Values & Value Mapping are a part of Graphical Mapping (Conversion functions).

2. Fix Values:- In the properties, we will provide a set of details - key and the corresponding values. Depending upon ur value in the Source field, target value will be triggered.

3. Value Mapping:- We'l provide the function in the graphical Mapping and the data is provided in the ID. This can store more values.

Note:- Since both these functions have limitations, for huge data storage we usually go for Value Mapping Replication.

Regards,

Ambili

[Former Member]

thanx

[Former Member]

Hi,

To do short...

Fix Value:

Standard fonction in graphical mapping that allow a simple convertion: A (source) --> Aaa (Target). it's like a hard coded which is defined for ONE target field.

Value mapping

it's like a "custo" table (almost!) which is defined into ID, which allow you to convert A --> Aaa. When the value mapping is defined into ID, you can use it several times into your graphical mappings. So your convert is not hard coded, but externalyze into your ID.

but there is some limitation with the convert A --> Aaa...

Note: only XI people can update this Value Mapping.

Look up table:

It's a method to read a SAP table (for instance). For instance you can apply it into your graphical mapping in order to have your convertion.

This solution offer the possibilty to have a SM30 on your SAP table, and so not only XI people can update the data.

With that I'm sure that you find more details about these 3 method of convertion.

hope this help you

Mickael

[pradeep_nellore]

Hi,

RFC Lookup.

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

SAP XI Lookup API: the Killer - /people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

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

Check this weblogs with some screenshots on how to achieve this:

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

/people/morten.wittrock/blog/2006/03/30/wrapping-your-mapping-lookup-api-code-in-easy-to-use-java-classes

/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

/people/sravya.talanki2/blog

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm

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

Lookups with XSLT - https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8e7daa90-0201-0010-9499-cd347ffb...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/05a3d62e-0a01-0010-14bc-adc8efd4...

Look up in simple terms means, when mapping runs the mapping program look into SAP database table for specific info depenidng on a condition.

Fixed mapping means source structure fields are converted into fixed values in target structure.This can be specified in Conversions-->Fixed values.

Thanks

--Pradeep

Reward points if helpful.

[Former Member]

Hi Abdul,

Value mapping

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

RFC Lookups

/people/michal.krawczyk2/blog/2005/09/15/xi-rfc-mapping-lookups-from-bc-to-xi

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

Regards

Seshagiri

[Former Member]

Hi Faisal,

ValueMapping you can acheive this by using the function "FixValues" or "VlaueMapping" from function category Conversions with in message mapping.

FixValues :You will create a local table to perform value mapping. You can enter your desire pair of values in FixValues and default value.

Ex: A - 1,B-2,C-3 and default value as 0

It means if you have the valus in source as A,B,C it will convert into target as 1,2,3 if other than A,B,C comes it will convert into as 0 in target strucutre.

ValueMapping :By using this function you can refer the values which were defined in Integration Directory with Schema & Aency.

ValueMapping Look UP's : if you need to refer the data which is exsiting inside R3, you can acheive this by using RFC lookup.You can create a RFC which is able to give the data as Response y taking the data as Request.

Cheers

Veera

[Former Member]

ValueMapping you can acheive this by using the function "FixValues" or "VlaueMapping" from function category Conversions with in message mapping.

plz explain it in detail. i didn't get you.

Thanks

Faisal

[Former Member]

Hi,

hope this helps:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/9202d890-0201-0010-1588-adb5e89a...

/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

http://help.sap.com/saphelp_nw04/helpdata/en/13/ba20dd7beb14438bc7b04b5b6ca300/frameset.htm

Regards

Patrick