How To Fix SETHIER000 - Sets with same name exist in another hierarchy

SAP Error Message - Details

• Message type: E = Error

• Message class: SETHIER - Set hierarchy generation programs (PSM-FM BCS)

• Message number: 000

• Message text: Sets with same name exist in another hierarchy

What causes this issue?

One or more <DS:GLOS.3526BA3DAFAB52B9E10000009B38F974>sets</> that you
want to create already exist in the database (same name, same class),
and are located in hierarchies other than the one being created.
A set hierarchy is identified by the name and class of the uppermost set
record. You can only override a conflicting set hierarchy by defining a
set hierarchy with the same uppermost set record.

System Response

The requested set hierarchy is not created, and the conflicting sets
already in the database are not modified.

How to fix this error?

Use transaction SE16 to identify the conflicting set elements in table
SETHEADER, using one of the following two options:
If a set is no longer needed, you should delete it, for example, using a
report to delete the entire set hierarchy in all relevant tables, so
that no "orphaned" sets remain. Then run the report again to create the
set hierarchy.
You can decide not to override the conflicting sets, but instead to
change the name of the sets being created by modifying the prefix in the
selection screen. This will however only work for a "General Set
Hierarchy", not for a "Group Set Hierarchy".

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.