cancel
Showing results for 
Search instead for 
Did you mean: 

SAP MDM DISPLAY FIELD AND UNIQUE FIELD DIFFERENCE

Former Member
0 Kudos

Hi All

I am new in MDM, can any body please help me understand...

What is the difference between display field and unique field?

Besides to consider one field to be a key in a lookup table, how should we declare that field in the table, as a display field or as an unique field?

It would be helpful if someone kindly explain this to me.

Thanks in advance.

Santanu Ghosh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Santanu,

To explain you the difference in Display field and Unique filed as in MDM in a prescise manner:

Display field:

Every field you create under your main table ie Product atbel will be a displayed field in MDM data manger irrespective of you making it as display or not in Console.

It means two things

1) That this field will be visible in MDM data manger.

2) This field will be visible in Import Manager for Mapping.

But in case of lookup field you need to make the fields as dispaly or not,if you wish to see them in import manger.

If you do not make the fields in a lookup table as dsipaly then even though you can see them in MDM data manger you will not be able to see them in Import amnger as a result not be able to map them.

Unique Field:

When you make any field as unique it maens taht MDM will not allow you to add two values under this field with the same value.

Eg:You acnnot add two materials with material no 100.

Hope it helped

Kindly reward points if found useful

Thanks

Simona

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks to every body for your reply.

It has solved the issue.

Former Member
0 Kudos

Hi Santanu,

A If you have a field as unique, then you can't have two records in the same table, with same value in that field. That field will act as your key for that table.

In case of display field, it is only for displaying the fields in main table. Say you have countries table. in that table you have Name and Key as two fields. You have one field Country in the main table, which looks into countries table.

Now suppose you have name as your display field in countries table. then, when you go for filling a value in main table's country field, you will see country names in the drop down. if you have name and key both as display fields in countries table, then for Country (Main table), u will see name and key (separeted by a delimiter as per delimiter selected by u in configuration options) in drop down.

Display field has nothing to do with a unique field. If u have key as a unique field in Countries table then it will not allow u to have two countries with same key. There is no such scenario for display field.

Hope this is clear to u.

Regards,

Dheeraj.

Former Member
0 Kudos

Hi,

Unique field -> If any field is declared as Unique then it wont allow you to insert same value i.e. no repeatition

Display field -> if say there exists 3 fields in the lookup table and two fields are declared as Display fields then in the main table when you look into the lookup table you will find the value as the combination of both the display fields.

Reward if useful

Regards,

Jitesh Talreja