How To Fix R5060 - Database inconsistency city &1, notify system administrator

R5060 - Overview

• Message type: E = Error

• Message class: R5 - Regional structure

• Message number: 060

• Message text: Database inconsistency city &1, notify system administrator

What causes this issue?

There are already city - postal code assignments (ADRPCITY records) for
the specified city number &V1&, although the city does not yet exist
(should be created now).

System Response

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

How to fix this error?

Error message extract from SAP system. Copyright SAP SE.

R5060 - Details

• The SAP error message R5060 indicates a database inconsistency related to a city entry in the system. This error typically arises when there is a mismatch or corruption in the data stored in the database, particularly in the address or location-related tables.
  
  Cause:
  
  Data Corruption: The data for the city entry may have been corrupted due to various reasons, such as system crashes, improper data imports, or manual data entry errors.
  Inconsistent Data: There may be inconsistencies between different tables that reference the city data, leading to conflicts.
  Custom Developments: If there are custom programs or enhancements that manipulate address data, they might inadvertently cause inconsistencies.
  Transport Issues: If data was transported from one system to another (e.g., from development to production), it might not have been transported correctly.
  
  
  Solution:
  
  Notify System Administrator: As the error message suggests, the first step is to notify your system administrator or SAP Basis team. They will have the necessary access