Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Currency in JPY format

Former Member
0 Likes
3,163

Hi,

I have a requirement which I need to display the amount in JPY format in webdynpro AVL output

i.e. If my amount is 15,00 it should be displayed as 1500 without any decimal places.

Please let me know how to do this.

Thanks,

Neethu.

Hi,

I have a requirement which I need to display the amount in JPY format in webdynpro AVL output

i.e. If my amount is 15,00 it should be displayed as 1500 without any decimal places.

Please let me know how to do this.

Thanks,

Neethu.

4 REPLIES 4
Read only

Former Member
0 Likes
2,096

Dear Neetu,

For certain currencies , the value in the database table and and the actual value may differ.

This is because In the R/3 System tables, currency fields are stored as decimal figures with a variable number

of decimal places. Each currency field refers to a currency key field to interpret the correct positioning of the decimal

point and arrive at the correct value.

Now these decimal positions are rarely changed in a Production system.So either you can

incorporate the multiplication in your code15.00 * 2 = 1500 for 'JPY' or fecth the no of decimals from the table TCURX for 'JPY'

and do accordingly.Do have a word with your fuctional consulatnt also.

Regards,

Rijuraj

Read only

jitendra_it
Active Contributor
0 Likes
2,096

Hi,

Use "Currency" option of write ..to... statetment to format the the amount.

Eg:

Write <amount> to <amount1> Currency 'JPY'.

For more help. Press F1 on write statement & check.

Many Thanks,

Jitendra Soni

Read only

Former Member
0 Likes
2,096

This is a common feature in BI/BW reporting. Didn't kknow it happens in WebDynpro reporting too. Anyways, if you search in the forums, with the keywords you used in title, Im sure you'll find lots of solutions.

pk

Read only

Harsh_Bansal
Contributor
0 Likes
2,096

Hi,

Use this for your requirement -

BAPI_CURRENCY_CONV_TO_EXTERNAL

Regards,

Harsh Bansal