12-04-2007 11:21 AM
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
12-04-2007 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
12-04-2007 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