SAP - XI Value Mapping : Mapping two values to a single value

[former_member190313]

Hi all

I am working on SAP -XI Value Mapping.

My question is :

I want to map two or more values from source to the same value at target, using value mapping.

for eg.

If source field "Country" has value "In" or " IND" it should map to a single vale "India" in target field "Country".

can any one suggest some solution for the above problem??

Thanks

Sheetal

[Former Member · Accepted solution]

Hi Sheetal ,

For your scenario you can attain this by writing a small UDF ( I dont think there is no need to use Value mapping here )

Source node Country will have "In" or "IND" as data so check for both cases using a java UDF. If any of these conditions are valid then just add result.addValue("India" ) and map this to the Target Country Node .

Please let me know if you have any more doubts.

Nanda

[Former Member · Accepted solution]

Hi,

For this, you have to create a value mapping group. In our ID, goto tools-> value mapping.

Select <b>Value mapping group selected by</b> -> <b>Representation</b>. Enter the agency, scheme and one of the source values. You will be taken to the Diplay value mapping group screen wherein you can edit the value mapping group and add more than one source values for a single target value.

Regards,

Divija.

[former_member190313 · Accepted solution]

hi all

thanks to all for such a quick reply

Divija can please elaborate more on your explanation

i am still not getting it completely

[deviprasad_pothireddy · Accepted solution]

Hi

also refer this weblog

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

Regards,

Deviprasad

[arunneerolil]

Hi,

Map any one of the source to the target.

You can check the existence before mapping.

Rgds

Chemmanz