Skip to Content
author's profile photo Former Member
Former Member

FM for Currency..

for corrency like JPY has no decimal point. But if read directly from table where the field has decimal point, wrong value will be retrieved isk liye there is some FM can any one plz let me know??

thnx

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 04, 2007 at 11:24 AM

    Hi,

    use these fn modules,

    CONVERT_TO_FOREIGN_CURRENCY : It converts local currency to foreign currency.

    CONVERT_TO_LOCAL_CURRENCY : It converts from foreign currency to local currency

    reward if helpful

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 11:29 AM

    The field is stored in the database with the decimal places, and any internal table or work area in an ABAP program should also hold the data in the same format.

    You only need to consider the format when you output this value, either to a report, file or form.

    For a report use WRITE: wa_field CURRENCY wa_waers, which will format the field for the specified currency. You would use the same if you were passing the field to a file.

    For smartforms provided you have defined the relationship between these two fields smartforms will format this for you.

    Regards,

    Nick

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.