How one-many elements mapping is possible

[Former Member]

Hi

I had a scenario of one element on source side being mapped to more than 1 elements on destination side -- In Value Mapping.

VALUE MAPPING TABLE

SOURCE SIDE DESTINATION SIDE

1 2

1 3

4 4

4 6

For above Scenario, how can proceed i.e through Value Mapping Table, if so, for each input comming to Value Mapping table has to lead me 2 outputs, How can I get two outputs for 1 output.How can i handle these Scenario. Can any one help me out.

Thanks

Shailaja

[Former Member]

Hi Shailaja,

N:1 relationships are possible with Value Mapping. Instead of editing pairs of input and output values, you should edit the <b>value mapping group</b>. There it's possible to enter duplicates.

Best regards

Joachim

[bhavesh_kantilal]

Hi Shailaja,

if you are using SP14, then you can use a Global variable to map the corresponding elments. Check this blog for the same,

/people/sap.user72/blog/2005/10/01/xi-new-features-in-sp14

If your mapping is going to have complex logic associated with it you can always choose between Java mapping and XSLT mapping. Check these links on the same,

http://help.sap.com/saphelp_nw04/helpdata/en/73/f61eea1741453eb8f794e150067930/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/e2/e13fcd80fe47768df001a558ed10b6/content.htm

Hope this helps,

Regards,

Bhavesh

[former_member189324]

Hi Shailaja,

There are various options to resolve your scenario.

1. Value Mapping: Try Value Mapping Replication for Mass Data

2. Message Mapping: You can use a DBlook up via a user defined fuunction in the Message Mapping program. In this case you will make a DB look up call at the mapping step itself. But you have to maintain the table separately.

Thanks

Prasad