a month ago
Hi,
I am trying to combine VBRK and VBRP tables for billing in a calculation view.
Bellow is the diagram:
I want to have both fields: net value in document currency and in statistical currency. So I created a calculated column "NETWR_S" in the join node with just a reference "= NETWR".
The original column NETWR has the Decimal shift turned on, so that the values for currency HUF appear correctly (multiplied by 100).
In the Semantic layer, I set this new column NETWR_S as Amount with Currency.
For this new column, I have the Decimal shift and Conversion on.
The result of the Raw data shows, that the NETWR is taking the decimal shift into account when displaying the result. The NETWR_S hower was converted but the decimal shift did not occur prior to the conversion.
So instead of 0,18 EUR I would expect 18,81 EUR.
Any ideas on what I am doing wrong?
Thank you!
Check if the currency-customising in your BW system is correct (TCUR... tables)
and if the data has been loaded correctly from the source
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
did you try to let HANA create the target with "Generate result currency column" ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
perhaps a double decimal shift is not necessary
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.