Skip to Content
Jul 15, 2019 at 03:34 PM

CDS View currency conversion problem

2005 Views Last edit Jul 15, 2019 at 05:20 PM 2 rev

Hi guys how are you?

I am writing a set of CDS Views and I am faccing a problem with currency fields.

When I display the results via SE16N, the view works fine and show the values correctlty, but when I export the data into a CSV file and thats is the goal of this development, the field appears with a wrong format.

I'm using this annotation in my currency field

        @Semantics.amount.currencyCode: '_posicion.waerk'

In SE16N we can see:

But in excel is not Ok:

Is it normal?, I mean, Have I to do some ABAP workarround to get the right currency format?

Just for clarification pourpuse, Im not working whith a HANA database, Im working with Oracle.

I appreciate any help.

Best regards,

Ronaldo S. Vieira


se16n.png (1.5 kB)
exvel.png (1.8 kB)