Key Mapping for Flat lookup tables

[Former Member]

Hi,

How do we decide if we need to make Key Mapping "Yes" for flat look-up tables?

Can anyone plz explain with an eg on where to make key mapping yes or no for Flat Tables.

Thanks,

Ketan

[Former Member · Accepted solution]

Hi Ketan,

If you have a table such that you need different information to be maintained for different systems say you have a business requirements table with field values specific to business data coming from different systems then you enable key mapping so that you create a link to all systems .Tables which are common and not specific to any system might not be needed to do so like countries.

Thanks

Vinay

[Former Member]

Pls refer page#254 of Console guide for MDM 5.5:

"Main table records, subtable records, and text attributes may be flagged to store remote keys (Key Mapping=Yes) in the MDM

Console (for tables) or in Taxonomy Mode (for text attributes)."

[Former Member]

Hi,

I'm aware of how to enable key mapping and its use while merging.

My question is Key Mapping is enabled at a table level. How do we deciode if a Flat lookup table having configuration data should have key mapping yes or no.

My question is specific to Flat tables only.

Thanks,

Ketan

[Former Member]

Hi Ketan,

Just go through this lik it will help you understand the concept of remote keys in detail

[http://help.sap.com/saphelp_mdm550/helpdata/en/42/f3a76f620e32c3e10000000a1553f6/content.htm]

[http://help.sap.com/saphelp_mdm550/helpdata/en/42/f3aaa5620e32c3e10000000a1553f6/content.htm]

I hope I am able to solve your problem.

Regards

Dilmit Chadha

[Former Member]

Hi,

A remote system’s objects are mapped to master data objects within MDM using key mapping.

A key mapping maintains the relationship between the remote system’s identifier (or key) for an object and the

corresponding master data object in MDM.

If you select Repository in MDM console then click on any table on right pane of Repository detail.

here in the table detail pane you will see the option to find key mapping to "Yes" or "No" for the particular table.

I hope it will clarify you.

Regards,

RDN.

[Former Member]

Hi,

Can anyone plz explain with an eg on where to make key mapping yes or no for Flat Tables.

1. A remote system’s objects are mapped to master data objects within MDM using key mapping. A key mapping maintains the relationship between the remote system’s identifier (or key) for an object and the corresponding master data object in MDM.

2. in the data manger based upon some strategy, you found that 4 records are duplicate, and then you merged into single record.

the merged record is having 4 records inside it with respective remote keys.

if you want to edit those records, key mapping should be enabled for that particular table.

3. while harmonizing the records to the respective client systems, you can use edit key mapping functionality for merged records.

if you enabled key mapping functionality in the console for the particular table, then only you can aceess EDIT KEY MAPPINGS functionality in data manager & syndicator.

hope this may help you,

Regards,

Srinivas