Skip to Content
Author's profile photo Former Member

How to Set up the Customizing Currency Display in Query Output

Recently I saw some customers raised incidents about the currency display in the query output. It’s not very often to request the customizing currency display, but BW indeed provides the functionality to set the alternative currency display.

Scenario 1: you want the currency key displayed as what you want. For example, you hope to display currency key CNY as RMB.
Scenario 2: you are hoping to have the currency key be hidden in query output. 

Scenario 3: you want the currency key displayed before the key figure values, while the currency is shown after the value in normal way.


The above requirement can be achieved by the “Set Alternative Currency Display” setting in transaction code SPRO.

Set Alternative Currency Display.png

The following three new entries will satisfy above requirement.

Set Alternative Currency Display 2.png

Actually this feature has been introduced in the following online help document.

SAP Library – XML: BW – OLAP

Cecilia Li

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Edward John
      Edward John

      Nice post. 🙂