cancel
Showing results for 
Search instead for 
Did you mean: 

Delete entire branch Hierarchy Table

Former Member
0 Kudos

Hi all,

I´m trying to delete all data from a hierarchy table, but, from the record view in the sap MDM Data Manager I can´t accomplish because when I select all records and clic in the delete button I got the message: "Error removing record parent". So I go to the Hierarchy View and try to delete one entire branch(parent node) the button is disable, because you only delete one record(leaf node) per time.

Thanks for your support!

Accepted Solutions (1)

Accepted Solutions (1)

Erdal_Şimşek
Participant
0 Kudos

Hi,

in a hierarchical tree in MDM (e.g. Lookup[Hierarchy]) nodes can only be deleted if there is no child node element left. Please start from the lowest level - delete all those nodes then go one level up and so on until you reach the highest level (root).

Did you add the Level information into your hierarchy model design? If yes, then it is even faster!

Regards,

Erdal

Former Member
0 Kudos

Hi Erdal,

Thanks for your reply, and a really good answer, but I didn´t add the Level in the Hierarchy Table, so I have to delete one by one in the Hierarchy View.

I am new in this and I am still learning, thanks for your advice!

Erdal_Şimşek
Participant
0 Kudos

Hi,

how many nodes do you have in the hierarchy table? If there are too many so that this would take hours for you to do there is another faster way. But please consider a few things:

NOTE: ONLY perform following steps if you are on a NON-PROD system!

  • is any of the nodes mapped to a main table record (e.g. material)? If no, good! If yes - please extract the main table record - PH assignment from data manager so that this info doesn't get lost.
  • Please archive your repository for backup purposes (in case anything goes wrong in the following steps)
  • Export the repository schema via Console -> right-click on repository -> Transport->Export Repository Schema
  • Delete the hierarchy lookup table physically in the Console (PLEASE MAKE SURE YOU HAVE FOLLOWED ALL THE STEPS ABOVE FIRST!!!)
  • After deletion, import the Repository Schema that you have previously exported. Note: repository has to be unloaded for this.
  • Check->Repair repository
  • Load->Update Indices
  • That's it!

Hope this helps.

Regards,

Erdal

Answers (0)