SAP Knowledge Base Article - Public

2618065 - Hash or Pound sign (#) not recognized as filter option


  • You create an extension field as an ID field in the Opportunity Facet and enter the Value #.
  • You are searching the opportunity that has an extension field with Hash or Pound sign. It is not possible to find it using the search bar in the Work Center Sales under the Facet Opportunity.
  • You create an Odata query on the object for opportunities, using the extension field as filter with the Hash or Pound sign (#).
  • The query does not find the opportunities either.


SAP Hybris Cloud for Customer Sales / Service

Reproducing the Issue

  1. Go to the Sales Work Center.
  2. Select the Opportunity Facet.
  3. Select All Opportunities.
  4. Using the Search Field, search for the Hash or Pound sign (#).


The Hash or Pound sign '#' is one of the token separator for the text indexing. Token separators are erased during the search.


For any extension field you can use field types such as "text" and subtype as "SHORT TEXT" whose maximum length is 40.
To enable the hash or pound sign '#', you can use "MEDIUM TEXT" whose maximum length is 80 and "LONG TEXT" whose maximum length is 120 as well.


hash filter, Token separator, extension field, Opportunity, #, Hashtag, Pound sign, OData, ID field , KBA , such feld , BC-DWB-REP-EXT , Extensibility , HAN-DB-SCR , SAP HANA SQL Script , Problem


SAP Cloud for Customer all versions