Skip to Content
author's profile photo Former Member
Former Member

Key mapping

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 23, 2013 at 09:27 AM

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

    Please post us if you have further queries.

    Kind Regards,

    Thamizharasi N

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 23, 2013 at 10:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2013 at 05:16 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.