Value Mapping or Lookup Table

[former_member193466]

Hi,

There is a requirement that we would need to dump a table data of ECC into XI wherein XI can make use of the data.

Here the data from ECC will be changed so frquently that we need to update the data in XI also.

So please suggest me if we can go for Value mapping or Lookup Table in XI-Abap stack.
1. incase of Value mapping, i think we cannot update value mapping, here please suggest me how can I delete and insert the new data in the same time.

very helpful if any link has steps of this.

2. If XI-ABAP stack lookup tabel is best, will there be any issues I should take care?

[former_member184720]

Hi - In terms of performance, Value mapping has got an advantage over UKMS,RFC or DB lookups.

Here the data from ECC will be changed so frquently that we need to update the data in XI also

If there is already a table in ECC where the values are being maintained and incase you would like to avoid this additional maintainance in PI - then you can go for RFC lookup.

[Former Member]

Hi

Yes you can go for value mapping replication because it will give better performance rather than DB look ups.

There is one more thing which is called UKMS ( unified key mapping service ) you can try. You will get the information of UKMS in the below links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0d09911-ebb2-2b10-959d-8bd91f556...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50120693-f1a9-2c10-cd8c-91967e6b7...

[Former Member]

More about VMR (Search SDN u will find lots of articles on the same):

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e07dd2ae-f783-2c10-9aa6-ca69f67dd...

Edited - Try with this kind of Message format for updating messages (Delete old value and then insert new one)

<ns0:ValueMappingReplication xmlns:ns0="http://sap.com/xi/XI/System">

<Item>

<Operation>Delete</Operation>

<GroupID>0ec543a0bb2311dbceb90016e6905679</GroupID>

<Context>http://sap.com/xi/XI</Context>

<Identifier scheme="Source1" agency="Source">4100058403</Identifier>

</Item>

<Item>

<Operation> Delete </Operation>

<GroupID>0ec543a0bb2311dbceb90016e6905679</GroupID>

<Context>http://sap.com/xi/XI</Context>

<Identifier scheme="Target1" agency="Target">rcjv</Identifier>

</Item>

<Item>

<Operation>Insert</Operation>

<GroupID>0ec543a0bb2311dbceb90016e6905679</GroupID>

<Context>http://sap.com/xi/XI</Context>

<Identifier scheme="Source1" agency="Source">4100058404</Identifier>

</Item>

<Item>

<Operation> Insert </Operation>

<GroupID>0ec543a0bb2311dbceb90016e6905679</GroupID>

<Context>http://sap.com/xi/XI</Context>

<Identifier scheme="Target1" agency="Target">rcjv1</Identifier>

</Item>

</ns0:ValueMappingReplication>

Check Appendix section:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00ee347e-aabb-2a10-b298-d15a1ebf4...

Thanks

Amit Srivastava

[Former Member]

Hello,

I would suggest u to go for Value mapping replication.

So, in VMR values will be stored in java runtime cache of XI system which is better in terms of performance.

Thanks

Amit Srivastava