topic Re: JPY Correct Format in Application Development and Automation Discussions

JPY Correct Format

Former Member — Fri, 25 Sep 2009 15:44:06 GMT

Hi,

I have a report that displays the net price in foreign and local currency

The processing happens in an internal table where the field containing the suppose to be price in local currency is like ekpo-netwr with 'JPK' as the currency key. On the internal table processing the value placed in the internal table -netwr field is correct, but when the value is displayed in the report with the use of REUSE_ALV_LIST_DISPLAY function, the conversion of the value is displayed incorrectly.

e.g. in the internal table the value for the local price is 25,742.67 but upon display using the REUSE_ALV_LIST_DISPLAY, the value turns into 2,574,267.

This is the same case when using "WRITE value INTO field CURRENCY 'JPK'. It turns the data to 2,574,267. Can anyone tell me what is wrong in this process and how could i get 25,743 value in the display?

Thanks in advance,

Re: JPY Correct Format

Former Member — Fri, 25 Sep 2009 15:49:09 GMT

Hi,

Thats because the Japanese currency Yen (JPY) does not have decimal notation as in other currencies. Thats why its multiplied by a factor of 100 to avoid decimals which is done internally by the SAP. If you have to display with rounded value, divide the value by 100 and use TRUNC to get the rounded value

Eg,



data: var_jpy type p decimals 2,
         var type type p decimals 2.

var_jpy = 234,564.
var = var_jpy / 100.
var = trunc( var ).

write: var.

Regards,

Vikranth

Re: JPY Correct Format

Former Member — Fri, 25 Sep 2009 15:50:40 GMT

I don't think there is anything wrong with the display. SAP stores all the amounts with two decimals. Then based on the cofiguration of your currency key, it displays the amount with the appropriate number of decimals. Since Japanese Yen currency do not have decimals, it is showing all that. Similarly the same value would have been 25,742.67, if the currency was USD and it would have been 257.4267 if you have configured a currency USD4 with 4 decimals. Look at table TCURX for the number of decimals configured for each currency.

Re: JPY Correct Format

Clemenss — Fri, 25 Sep 2009 23:05:15 GMT

Hi Dennis,

if your ALV structure is not a dictionary structure including the currency amount field linked to a currency key field, you must do this in the field catalog.

For the amount field, you can set the fieldcatalog field CURRENCY to JPK (the hard way).

Or, better, you use the field catalog field CFIELDNAME to set the currency reference field, i.e. 'WAERS'. WAERS should be a column in ALV display that carries the currency key (JPK) at runtime.

The advantage of the currency key field is that totals and subtotals are calculated on each currency displayed.

Kind regards,

Clemens