How To Fix R5528 - Postal code &1 in country &2 is assigned to nonexistent city number &3

SAP Error Message - Details

• Message type: E = Error

• Message class: R5 - Regional structure

• Message number: 528

• Message text: Postal code &1 in country &2 is assigned to nonexistent city number &3

What causes this issue?

There is a record in the table ADRPCDCITY for the postal code. However
there is no record in the table ADRCITY for the city number entered
there (i.e. the city does not exist) -> data inconsistency.

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.

Smart SAP Assistant

• What is the cause and solution for SAP error message R5528 - Postal code &1 in country &2 is assigned to nonexistent city number &3 ?

  The SAP error message R5528 indicates that there is an issue with the postal code and city assignment in the system. Specifically, it means that the postal code you are trying to use is associated with a city that does not exist in the SAP database. Here’s a breakdown of the cause, solution, and related information for this error:
  Cause:
  
  Missing City Data: The city number associated with the postal code is not defined in the SAP system. This could happen if the city data has not been maintained or has been deleted.
  Incorrect Configuration: The postal code may have been incorrectly assigned to a city that does not exist, possibly due to data entry errors or incorrect configuration settings.
  Data Migration Issues: If data was migrated from another system, there may have been issues during the migration process that resulted in missing or incorrect city data.
  
  Solution:
  
  
  Check City Master Data:
  
  Go to the transaction code OVK1 (for maintaining postal codes) or OVK2 (for maintaining city data).
  Verify that the city number associated with the postal code exists in the system. If it does not, you will need to create the city entry.
  
  
  
  Maintain Postal Code Data:
  
  If the city does exist, ensure that the postal code is correctly assigned to the city. You can do this by checking the postal code configuration in the relevant transaction.
  
  
  
  Create Missing City:
  
  If the city does not exist, you can create it using the transaction code OVK1 or OVK2. Make sure to enter all required information, including the city name, postal code, and any other relevant details.
  
  
  
  Data Consistency Check:
  
  After making changes, perform a consistency check to ensure that all postal codes and city assignments are correct. This can help prevent similar issues in the future.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or help resources for more detailed instructions on maintaining postal codes and city data.
  
  
  
  Related Information:
  
  Transaction Codes:
  
  OVK1: Maintain Postal Codes
  OVK2: Maintain City Data
  OVK3: Display Postal Codes
  
  
  SAP Notes: Check for any relevant SAP Notes that may address known issues or provide additional guidance on this error.
  User Authorization: Ensure that you have the necessary authorizations to make changes to postal code and city data in the SAP system.
  
  By following these steps, you should be able to resolve the R5528 error and ensure that postal codes and city assignments are correctly configured in your SAP system.