Currency difference can't be summarized

[former_member844813]

Hi Experts!

in WRBTR field come out values with different currency which as u can see it's separated. is there a way to make the value with USD convert it to IDR so it can be summarized ?

Thank you.

[yogananda]

demaauliansyah

Yes, it is possible to convert the WRBTR field values with different currency to IDR. You can use the function CURRENCY_CONVERSION which performs a currency conversion for the value passed to the formal parameter amount. The result has the data type CURR with the same technical attributes as the actual parameter passed to amount. The value passed is rounded to two decimal places before it is converted¹.

Here is an example code snippet that you can use:

DATA: l_wrbtr TYPE wrbtr,
      l_idr   TYPE wrbtr.

l_wrbtr = 1000.00.
CALL FUNCTION 'CURRENCY_CONVERSION'
  EXPORTING
    amount         = l_wrbtr
    source_currency = 'USD'
    target_currency = 'IDR'
  IMPORTING
    converted_amount = l_idr.

Copy

I hope this helps! Let me know if you have any other questions.

[former_member844813]

is the l_wrbtr used to change that specific value ?

[xiswanto]

simply put, you need to change the data in your itab and convert them into the currency you wanted ( in this case USD -> IDR ) using function module such as above ( providing the import export parameter), or coding the conversion logic by yourself.

[VXLozano]

I think the new SQL (or via CDS) allow currency conversion. But if your system doesn't, or you don't know how to call those things, or you don't want to (or cannot to), then, before the ALV calling thing, convert your field to IDR (as yogananda.muthaiah suggested).

You can do with something like:

loop at itab assigning field-symbol(<line>).
  <line>-wrtbr = your_class=>convert_to_idr( <line>-wrtbr ). "if you are using a local class, you can PERFORM CHANGING it
endloop.