Currency Conversion.

Former Member — Thu, 06 Nov 2008 15:20:31 GMT

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.

Re: Currency Conversion.

Former Member — Thu, 06 Nov 2008 15:24:52 GMT

Try to use the fm CONVERT_TO_LOCAL_CURRENCY

Max

Re: Currency Conversion.

Former Member — Thu, 06 Nov 2008 16:24:20 GMT

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

Hope this helps..

Regards

Ravish

topic Currency Conversion. in Application Development and Automation Discussions

Currency Conversion.

Re: Currency Conversion.

Re: Currency Conversion.