Currency Conversion.

[Former Member]

Hi All,

I need to build a report where currency is always displayed in USD, If it is in some other unit , I need to convert the same into USD as per the exchange rate,

The rule to calculate the same is as follows:

The u2018Moving Priceu2019 and u2018Standard Priceu2019 attributes used to calculate the average cost per material can be stored in different currencies in the MBEW table. All costs must be calculated in USD.

First determine the Company Code for the Plant (T001W-VKORG). Next, determine the currency for the company code (T001-WAERS). If Currency is NOT EQUAL to USD, the cost attribute must be converted to USD.

u2022 First, determine when the cost attribute was calculated to ensure the correct exchange rate is utilized to convert the currency to USD. Utilize Plant/Material combination to find costing date (KEKO-CPUDT).

u2022 Determine conversion factor (TCURR-UKURS) using the following values:

o Exchange Rate Type (TCURR-KURST) = u201CUSDXu201D

o From Currency (TCURR-FCURR) = Currency of material cost at plant determined above (T001-WAERS)

o To Currency (TCURR-TCURR) = u201CUSDu201D

Thanks,

Debrup.

[Former Member]

Hi

Try to use the fm CONVERT_TO_LOCAL_CURRENCY

Max

[Former Member]

u can use "BAPI_EXCHANGE_RATE_GETDETAIL" to convert the currency....

Hope this helps..

Regards

Ravish