Key mapping

[Former Member]

Hello experts,

I am new to SAP MDM. I want to know why we have options of key mapping at remote level and table level as well.

What is the use of this option at two different levels. Please provide an example.

[shanthi_kumar · Accepted solution]

HI Abhishek,

Welcome to MDM world. This is quite a repetitive question. If you search in SDN you will get a handful of threads for this. However you can refer to this one http://scn.sap.com/thread/1394047.

Also you can refer from page no. 521 through 528 in SAP MDM reference guide at guide

http://help.sap.com/saphelp_nwmdm71/helpdata/en/4b/72b8aaa42301bae10000000a42189b/MDMDataManager71.p...

Please post us if you have further queries.

Kind Regards,

Thamizharasi N

[Former Member]

Thanks for the reply..

But i want to know why we have two different options for key generation i.e while defining remote system and while defining table as well.

Since remote key is used to track record from different remote system, then why we have this option at table level as well.

[former_member193350]

Hi Abhishek,

Enabling key mapping at the table level helps gives below two benefits:-

1. When you enable key mapping at that particular table level , In Import manager you can able to see the additional field in destination pane a"remote key" with which you can map your source item field and Import.

2. While manully creating data in data manager, If you want to assign some key value for that particular record on the basis of remote system . You can achieve this only by enabling key mapping at table level. which helps later in syndictaion for that selected remote system

Hope this is clear.

Regards

Prateek

[shanthi_kumar]

Hi Abhishek,

As you rightly noted out 'Key Mapping' for tables are different from 'Key Generation' for Remote systems. As rightly pointed out by Prateek for Key Mapping,

     1. Whenever there happens a addition of values in Data Manager, Syndication or Import for a particular Remote system, in those cases the Key Value will be added,syndicated or Imported for that particular field according to the remote system.

Key Generation is totally different from Key Mapping values. Key Generation is used for generating a range of Key values according to a particular type/criteria. Key Generation is used for the purpose of automatic Generation of a value to an object. Key Generation has two methods, Range and Qualified Range. Please refer to the following link http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40155eaa-6437-2e10-afbc-de54b3132...

Get back to us if you have further queries. This document explains about Key Generation quite briefly.

Kind Regards,

Thamizharasi N

[Former Member]

Hi Abhishek,

Key Generation has different options so that it can meet the Business requirement.

Case 1 - suppose your business requirement to have fixed range of Material No say 100000-999999.

Here you can use Range option.

Case 2- Suppose your business requirement is to have 100000-600000 for Raw materials and 700000-999999 for Scrap material.This type of requirement can be met with qualified range setting in MDM.

Case 3- Meaningful Number generation based on logic or alpha numeric number generation can be done through other systems and imported in MDM.

Coming to 2nd part of your question,as you rightly said that remote key is to track records in different systems the next logical step would be to understand "what does this lookup value mean in that system?".So if a Title Mr means 0001 in SAP and 0008 in legacy system then it would have both the values in its remote key,one for SAP and one for Legacy system.This remote key will tell MDM that Mr means 0001 in SAP and 0008 in Legacy system.

Thanks,

Ravi

[former_member193350]

Hi Abhishek,

Remote System and Remote key are the two wonderful functionalities provided by MDM. They both used for identifying the culprit whose increasing the volume of records.... just kidding..

Through the remote system mechanism you can identify the source/destination  from which records are recieved/sent w.r.t MDM.

Remote key plays a vital role for identifying the records for that system

E.g:- Like you are maintaining the record book for all the cricket players Now you are taking data from 3 remote system having the name and initials as two fields . Suppose remote system A is maintaining the initials as S.R.T, while Remote system B maintains as S.T and Remote system C as Sachin for the player name as Sachin Ramesh Tendulkar.

Since name of the Player is Sachin Ramesh Tendulkar for all the systems, we will maintain only one record for  Sachin Ramesh Tendulkar  in MDM.But we need to keep track of the different formats and corresponding remote systems, so that we can syndicate the remote system specific data properly. Because if we syndicate initials as "SRT" to the second remote system, it will not accept this initial.

Now make that table's key mapping enabled as "yes". in console.

Now While Importing the data select first remote system and make a clone field for initials and now map this clone field to the remote key in the destination. and in matching fields select name field as there is only one Sachin Ramesh Tendulkar and we dont want any duplicates and Import similarly do for other two remote systems

After Import, Goto Data Manager select that record and show edit key mappings.System will show you all the key mappings for this record for respective remote systems.

Hope this helps.

Regards

Prateek