Bex Query is showing all values perfectly and balance amounts with its proper currency key, but higher management and reporting user wants balance
amounts/Key figures with its currency symbol for all the Bex queries.
The Query output with default setting for currency ;
Sample query:
Currency key is appearing after values of amount key figure.
Reporting user wants query output with currency sign before values of amount key figure as shown in below image:
Execute SPRO transaction code in BW system, this transaction code is mainly used to configure the setting as per your client requirement by using the
standard setting present in the system and also used for making necessary customizing in the system for the Key data structure and Configurations.
SPRO -> SAP Reference IMG -> SAP NetWeaver -> Business Intelligence->Settings for Reporting and Analysis.
Settings for Reporting and Analysis
Settings for Reporting and Analysis -> General Settings for Reporting and Analysis -> Set Alternative Currency Display
Click on to set Alternative Currency Display; it will pop up a caution message.
Caution: The table is cross-client; this message serves to warn you that each change you make will have an effect on all other clients in the system. Click on
"continue".
Click on “New Entries” tab and maintain Currency symbol against currency key as shown in below image and then click save button .
1. Currency: enter currency keys.
2. Alt. text (Alternative text): enter currency symbol for its relevant currency key.
3. Before/After Value: option decides how currency symbol (alternative text) will appear with value in Bex query.
e.g. If Currency key is EUR then value outputs for
Before value: € 1000 (€ displayed in front of the numeric value)
After value: 1000 € (€ displayed after the numeric value)
Note: SAP Standard settings:
1. All currencies are displayed in accordance with the ISO norm by default, and appear after the numeric value,
Except
2. DEM is displayed as DM,
3. USD is displayed as $ in front of the numeric value,
4. GBP is displayed as £ in front of the numeric value.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
8 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |