2007 Nov 28 5:52 AM
hi guys,
I am creating an idoc where i have to send amounts in doc currency and loacal currency.
whenever the doc currency is JPY the amount send is wrong cause if the amount entered in the document is 1000 then its stored as 10.00 in the BSEG table.
i am not sure if this rule applies to any other currencies as well.
is there a FM that i can use to convert the amount to actual figure.
thanx and regards,
Tarun Bahal
2007 Nov 28 6:03 AM
Hi Tarun,
You might be knowing, Yen doesn't contain decimal values. If you pass 1000 yen, it will save it as 10.00. This happens only with japanese currency.
You can use WRITE .... CURRENCY JPY.
This will work fine.
Let me know if you find any problem.
Hi Tarun,
You might be knowing, Yen doesn't contain decimal values. If you pass 1000 yen, it will save it as 10.00. This happens only with japanese currency.
You can use WRITE .... CURRENCY JPY.
This will work fine.
Let me know if you find any problem.
2007 Nov 28 6:03 AM
Hi Tarun,
You might be knowing, Yen doesn't contain decimal values. If you pass 1000 yen, it will save it as 10.00. This happens only with japanese currency.
You can use WRITE .... CURRENCY JPY.
This will work fine.
Let me know if you find any problem.
2007 Nov 28 11:42 AM
2007 Nov 28 6:20 AM
2007 Nov 28 1:09 PM
Hi,
Please use below fm to convert currency.
CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY_N'
EXPORTING
client = sy-mandt
date = p_ep_bldat "Posting date
foreign_amount = p_ep_hwbas "Amount
foreign_currency = c_eur "JPY
local_currency = currency "To currency
RATE = 0
type_of_rate = 'M'
READ_TCURR = 'X'
IMPORTING
EXCHANGE_RATE =
FOREIGN_FACTOR =
local_amount = p_ep_hwbas "After converting value
LOCAL_FACTOR =
EXCHANGE_RATEX =
FIXED_RATE =
DERIVED_RATE_TYPE =
EXCEPTIONS
no_rate_found = 1
overflow = 2
no_factors_found = 3
no_spread_found = 4
derived_2_times = 5
OTHERS = 6 .
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.
If usefull please reward .
Thanks
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |