conerting US dollars to indian rupees in ALV

[Former Member]

hi

i have created a ALV for the excise department. The problem i face is that, for the goods to be exported the value comes in US$.The excise department needs the US$ to be displayed in indian rupees.i like to know how to convert US $ to indian rupees

[Former Member]

Hi,

If possible to change the program code then make the currency to INR using the FM 'CONVERT_TO_LOCAL_CURRENCY'.

Rgds,

Bujji

[Former Member]

Hi,

Convert the USD amount to INR by using FM CONVERT_TO_LOCAL_CURRENCY.

Thanks,

Sriram Ponna.

[Former Member]

is there any other option other than FM because i'll not only get USD but also EUR.

[Former Member]

Then just pass a variable with your currency to the function module!

[Former Member]

HI,

Then you have to pass the currency to a variable pass the variable.

Regards

Sandipan

[Former Member]

Hi,

try this code.

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
  EXPORTING
   client                  = sy-mandt
    date                   = sy-datum
    foreign_amount         = '1000.00'
    foreign_currency       = 'USD'
    local_currency         = 'INR'
*        RATE                    = 0
   type_of_rate            = 'M'
   read_tcurr              = 'X'
 IMPORTING
   local_amount             = lv_netwr
 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.

Regards

Sandipan