SAP Knowledge Base Article - Public

3629867 - Special Characters in Normalized Phone Fields

Symptom

  • The Mobile Number and Phone Number fields on the Individual Customer record contain special characters such as * and # in some cases. For example, they may be entered by mistake.
  • These special characters should not appear in the "Normalized Phone Number" and "Normalized Mobile" fields when querying the individual customer via OData.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the work center Customers, view Individual Customers.
  2. Open the customer in question, .e.g customer ID 12345
  3. The Phone and Mobile field contain special characters.
  4. Run the following Odata request: https://myxxxxxx.crm.ondemand.com/sap/c4codataapi/IndividualCustomerCollection?$filter=CustomerID eq '12345'
  5. The "normalized" fields contain the special characters, while the expectation is that the "normalized" fields should remove those characters.

Cause

Most special characters will be truncated automatically when saving a number since they are not allowed, however # and * are an exception. This is because there are some special cases where such symbols have to be used in a mobile number.

Resolution

# and * are not recognized as special characters and will not be removed.

See Also

Refer to: SAP Cloud for Customer Documentation

Keywords

special characters, normalized phone fields, sap cloud for customer, mobile number, phone number, odata, truncation, expected behavior, #, *, symbols, individual customer record , KBA , LOD-CRM-ACC , Account , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions