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
- Go to the work center Customers, view Individual Customers.
- Open the customer in question, .e.g customer ID 12345
- The Phone and Mobile field contain special characters.
- Run the following Odata request: https://myxxxxxx.crm.ondemand.com/sap/c4codataapi/IndividualCustomerCollection?$filter=CustomerID eq '12345'
- 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
SAP Knowledge Base Article - Public