CDQ Data Quality as Service

Dear CDQ Team,

I’d like to raise a concern regarding the lack of CDQ rules that validate consistency between a Business Partner’s Country ISO code and their City/Postal Code.

Problem Statement
Currently, requestors often misassign the Country ISO code when creating or updating a Business Partner record. This results in inconsistencies where the address details do not align with the selected country.

Real-Life Example
We recently had a case where a logistics service provider in New Jersey, USA (City: Newark, Postal Code: 07102) was mistakenly assigned the Country ISO code “DE” (Germany). Because “Newark” sounds similar to “Neuwark” in Germany, the system allowed the record to be saved without any validation error. This caused downstream issues:

• Invoicing systems attempted to apply German VAT rules.

• The shipment routing engine miscalculated lead times and cost.

• Regulatory reporting flagged the partner under the wrong jurisdiction.

Proposed Solution
We request CDQ to introduce a consistency rule that validates:

• Country ISO code vs. City + Postal Code combination.

• In case of a mismatch, the system should trigger an error message stating that the Country ISO code does not match the Business Partner address details.

Additional Note
As address formats differ across countries (some may not have postal codes), the rule should be flexible enough to accommodate these variations.

Please let me know if this enhancement can be considered for implementation.

Best regards,
Abhishek