Article Search Case Sensitivity on Article Codes

[former_member382975]

Hi,

The article search is case sensitive which makes searching harder than it needs to be from a customer perspective.

For example I have an Article code of

10444/G

The user might search for 10444/g

CCO client will not find the article.

This problem used to also exist with Article descriptions but I see that has been resolved, however the Article Code case sensitivity issue still persists.

If there are customers out there who have the same characters for an Article code but in different cases perhaps an additional setting could be added to the article search dialog screen whereby a field can be set to case sensitive or not.

Would be interested to hear feedback on this.

Thanks.

Martin.

[former_member578974 · Accepted solution]

Hi Martin,
yes, you are right, let me summarize the situation in order to make this answer available and clear for the community.

I have analyzed this issue further and in the search the "Article ID" is case sensitive.

In the example you have provided, the "Article ID" master data was created as "10444/G" with the letter "G" in capital letter, so, if you search by "10444/g" with letter "g" in small letter, the search will not reach it.

On the other hand, the "Article description" is not case sensitive, so, it does not matter if you search in capital or small letters, both will bring the same result.

Let's see how it goes in the SAP Customer Checkout Customer Influence channel.

Other partners and customers may have the same question, so, I hope the content above helps to to clarify the situation. Feel free to select this answer as “Right Answer” in order to help others to follow and easily locate the content.

Regards,
Mateus

[former_member578974]

Hi Martin,
you can find the answer for your query via KBA 2592023. Basically this depends on the database system you are using for the SAP Customer Checkout Manager.

• If the database of your Customer Checkout Manager is on SAP HANA the search is always case sensitive
• If the database of your Customer Checkout Manager is on Microsoft SQL then the search depends on your Server Collation settings:
  - if a CI (Case Insensitive) Server Collation has been set the search will be case insensitive, e.g. Latin1_General_CI_AS
  - if a CS (Case Sensitive) Server Collation has been set the search will be case sensitive, e.g. SQL_Latin1_General_CP850_BIN2
  - the recommendation for Microsoft SQL is collation SQL_Latin1_General_CP1_CI_AS (as per the SAP Customer Checkout manager Guide)
  

If your question in answered, kindly select the answer as “Right Answer”. This helps others to follow and easily locate answers.

Best Regards,
Mateus

[former_member382975]

Hi Mateus,

No, that does not answer my question.

The Article search within Article description is not case sensitive regardless of the database system in use, whereas the Article code is.

What I'm asking is whether this could be changed so that it works the same for Article codes as it does for Article descriptions, or if there are any plans to do so. This is based on feedback I'm receiving from customers.

Thanks.

Martin.

[former_member382975]

Requirement is added to ideas to vote on:

https://influence.sap.com/sap/ino/#/idea/228347