Skip to Content

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

Hierarchy Data Model query!

Dear Experts,

We have a scenario in which we have to model data hierarchy data as

leaf node Field1;Field2;Field3

Here we have the values for the above fields say

Field1 : 100

Field2 : ABC

Field3 : XYZ, asd, qwe, rty

So we are trying to provide 100:ABC;XYZ

100;ABC;asd and cont.

When I try to make the 3 field unique, system is not allowing me to create the second row as it is giving unique key contraint violated, so how can I make the combination of three fields unique.

One answer to model this can be to use Taxonomy table with attributes as field3, but somehow ( data is large), we want to avoid that.

so please help me on this.

Hope I make the requirement clear.

Former Member
Not what you were looking for? View more on this topic or Ask a question