Skip to Content

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

How to Modify Hierarchy Filed Values by using Import Manager

Hi All,

I have some lookup table values in my source file in 1st attempt I have updated successfully. But, after cross checks the same i found that hierarchy level are incorrect at the destination side.

Source Hierarchy lookup values

Item1

Item 2

Item 3

Item4

Destination Hierarchy lookup values

Item1

Item 2

Item 3

Item4

Note: After Adding the Source filed hierarchy structure by selecting the Add Branch as child opting in the value mapping area

I am getting unique constraint Violated error message while importing the values.

So, how can I update the Source Hierarchy fields structure to Destination Hierarchy Field structure?

Thanks in Advance.

Mahesh

Tags:
Former Member
Former Member replied

Hi Mahesh,

While importing the values if you get the error unique constraint Violated, that means that the same value has been mapped twice.

when you try to map the values of the hierarchy, NULL would have been automatically mapped.

When you select all the records and do add branch as child, the same NULL would have been added and mapped again.

If not with NULL, this could be the case with some other value.

Just check if some value is added and mapped twice in your value mapping.

This should solve your issue.

Try and let me know the result.

Regards,

Sravan

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