How To Fix UGMD567 - Data loss in the records with the identical key &2 in table &1

SAP Error Message - Details

• Message type: E = Error

• Message class: UGMD - FIN Master Data: Messages

• Message number: 567

• Message text: Data loss in the records with the identical key &2 in table &1

What causes this issue?

The fiscal year variant conversion in database table &V1& created data
records with the same key: &V2&. The table key includes time references
(for example, the fiscal year and period in hierarchy tables).
Two or more data records with different fiscal years and/or periods were
converted with the same target time periods. One possibility may be that
the target fiscal year variant has less periods or less special periods
than the source fiscal year variant.

System Response

Only the first data record with the key &V2& will be saved in converted
form in the database table. Consequently, database table &V1& will have
a lower number of entries after the conversion.
No changes are saved when the conversion is run in simulation mode.
Only the first data record with the new key is saved. All others are
discarded. These cannot be saved because the table key needs to be
unique.

How to fix this error?

Check the data records to be discarded and, where applicable, change the
fiscal year variant settings. If you already expected this kind of
outcome from converting the fiscal year variants, execute the conversion
in operational/update mode.

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.