SAP Knowledge Base Article - Preview

1988114 - How to Show Other Text than "Not assigned" for the Initial Value in a BW Query


  • When you run a BW query with the initial value for a characteristic (e.g. blank for type CHAR or 000 for type NUMC of length 3) in the query result, the value key is displayed as "#" and the text is displayed as "Not assigned".
  • The users are confused about what "Not assigned" means and you would like to show some other text instead of "Not assigned".
  • At query result you expect to see key-value "#" and text-value "Not Assigned", but the text is blank.



  • BW system
  • Release independent


SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP BW/4HANA 2021 ; SAP NetWeaver all versions


not assigned, # , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-ET , Enduser Technology , BW4-AE-CORE , Core Services , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.