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 ONE Support launchpad (Login required).

Search for additional results

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