Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP MDM Hiearchy Concept in depth


I want to discuss the SAP MDM Hierarchy Table concept.

In Hierarchy we can add non-unique name to Internal nodes provided they are not child nodes.

It is wrriten Merging and Partition can be done in Hierarchy tables. But it possible to do Merging and Partition in Taxonomy table which is a type of hierarchy.

Partition can be done on any node by linked attribute if that attribute has multiple values. Merge can be done on a child node with a parent node which is not direct parent to the child.

This is also applied to Taxonomy table only.

Hierarchies can be imported by Import Manager but the destination table be Hierarchy and there should be a lookup Hiearchy field in main table corresponding to the Hierarchy table.

The Hierarchies from the source is usually added in value conversion and mapping step.

I didn't get the meaning of this line; "When a grid contains a hierarchy column, none of its columns are sortable. However, the hierarchy column is automatically treated as the sorted column for type-ahead seek purposes, allowing you to use type-ahead seek on it".

My understanding: Any Hierarchy column in main table is not sortable. I don't get the meaning of type-ahead-seek.


Kaushik Banerjee

Former Member
Former Member replied

Hi Kaushik,

In simple terms hierarchy is sorted automatically because when we create a hierarchy we only define the sorting of it.









Now the above hierarchy starts with Automobile as a Parent having 3 children. There must be some logic we have applied in sorting i.e. why we have kept the order Cars, Bikes and Trucks.

Thats why it is said that hierarchy is automatically treated as sortable.

In addtion say if hierarchy has only one Parent and three children as the above one and we can also create lookup instead of hierarchy but still we stick on hierarchy because we want to preserve an order of nodes.

Try to understand the concept and dont stress much on words.


Jitesh Talreja

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question