Currency conversion issue in SPM. We are getting incorrect results with SPM conversion function from one of the document currency to USD.

[Former Member]

Currently we are using SPM 2.0 version and we have been facing currency conversion issues.

Please help me in following aspects.

1) Where actually currency conversion happens in SPM. Is it the global program which does the conversion or other way.

2) We have conversion issue for one of the currency where conversion function is giving incorrect results when converting from one of the document currency to USD. here The respective document currency is considering the 1:1 ratio with Dollar which is actually incorrect.

3) We have verified in both BI side(currency tables) and even ECC side.

Please help me in understanding this issue and let me know if you need more information on this.

Its an production issue and appreciated your immediate inputs.

Thanks

Kiran

[Former Member]

Hi. John,

Sorry for late reply.

Thanks for your communication.

Currently we are not doing any loads for Currency objects in our environment.

Currency conversion is happening with standard API program during load to inbound layer.

we have an issue for one Document currency(Pakistani Rupee  to reporting currency USD.

where Spend amounts are showing incorrect results because system currency considering 1PKR = 1 USD which is wrong. That's why both the Invoice Spend(Doc) are exactly same as Invoice Spend(USD) which is actually wrong.

Can you help me out as how to get correct results.

1) Do we need to change the Standard API code which is responsible for SPM currency conversion?

2) Or is there any way to get the correct spend amounts by correcting conversion.

Let me know if you need any information.

Thanks

Arun

[Former Member]

Hi. John,

Can you help us on this as how to correct our currency conversion results.

Thanks

Arun

[former_member257798]

Hi Arun,

The following information may be helpful to you.The SSA_HELPER_PROGRAM has options regarding currency settings.

EXCH_RATE_TYPE: This flag governs the exchange rate type which will be used for currency conversion in data management. For example if RSXAADMIN contains an entry EXCH_RATE_TYPE = „ZSPM‟ then the conversion type used for currency conversion is ZSPM. The default value for the exchange rate type is „M‟. More details can be found in the note 1278988.

CURRENCYCONVERSION: By default data management converts all the measures in transaction currency to reporting currency and copies over to the corresponding measure in reporting currency. If the measure in reporting currency is already available in source it might be desirable to disable the currency conversion. To disable the conversion you can make an entry CURRENCYCONVERSION = „ „ in the table RSXAADMIN. This can also be achieved by running the program SSA_HELPER_PROGRAM with the option DEACTIVATE_CURRENCYCONVERSION. The conversion can be reactivated by running the same program with option ACTIVATE_CURRENCYCONVERSION.

UNITCONVERSION: Similar to above. To deactivate unit conversion you can use the program with option and DEACTIVATE_UNITCONVERSION and to reactivate ACTIVATE_UNITCONVERSION. By default both the conversions are switched on

EXTERNAL_CURRENCIES: Normally most of the international currencies are stored with two decimal places however certain currencies do have 0 and 1 decimal place too. For example JPY has 0 decimal places. SAP internal format stores even these currencies with 2 decimal places and at the time of display it changes the value to right decimal places. In case a file from external source is loaded to SPM it might have the format with 0 decimal places in the file. To convert it to SAP standard format post processing needs to be done on this value. If that is the case you can set the flat EXTERNAL_CURRENCIES = „X‟ in the table which will enable the post processing for these values. This flag can also be set and reset using the helper program using the option TURNON_EXT_CURRENCY_FORMAT and TURNOFF_EXT_CURRENCY_FORMAT.

Kind Regards,

John Harris

Senior Support Engineer, SAP Active Global Support

[former_member257798]

Hi Arun,
You can use Exchange Rates to set the proper values for the currencies. This will enable the transactional currencies to be displayed in the reporting currency. 
You can upload the exchange rates to enable currency conversion.

Proceed as follows:
SPM Interface/ Data Management/ Global Settings
Choose the Exchange Rates tab page.
Enter a file name or choose a file from the value help.
Select the delimiter for your environment.
Choose Upload.
Note
The exchange rate files have to be passed to a folder, which follows a naming convention as follows:
<name of the import folder>EXCHANGE_RATE\

Kind Regards,
John Harris
Senior Support Engineer, SAP Active Global Support