cancel
Showing results for 
Search instead for 
Did you mean: 

Currency translation

Former Member
0 Kudos

Dear Sap Expert,

We have Consolidation Group - CG001 , Group_CURRENCY - KZT

When we run consolidation package, the data consolidated from LC to KZT.

So now we need to convert data from KZT to USD, is it possible?

When we run fxtrans.lgf, it convert data from LC to USD.

Could you please answer, what we should make, to convert data from GROUP_CURRENCY to selected currency (ex. USD).

//--------------------------------------------------------------------

//--------------------------------------------------------------------

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

  CATEGORY     = %C_CATEGORY_SET%

  CURRENCY = %RPTCURRENCY_SET%

  TID_RA = %TIME_SET%

  RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

*COMMIT

//--------------------------------------------------------------------

Thanks,

Kadraliyev Yerlan

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Erlan,

the standard in BPC is to convert from LC to all currencies but you should be able to achieve what you want with a custom script that uses a LOOKUP to retrieve the rates from your rates application and post the converted values back to the DB.

This link explains it a bit more http://scn.sap.com/docs/DOC-26482

Hope this helps,

Arnold

Former Member
0 Kudos

Dear Arnold,

Thank you for your answer. We already set it using script logic (with LookUP command to retrieve currency from Rate application), but my question : is it possible to make the same think using currency conversion business rule. We found that it only convert from  LC to KZT or LC to USD, not from KZT to USD.

We suppose that if we will solve this problem using standard business rule Currency Conversion, it will be much more effeciently.

Thank,s

Kadraliyev Yerlan

Former Member
0 Kudos

Hi Erlan,

no, as far as I know it is not possible to use the standard business rule in that way.

Regards,

Arnold

former_member210696
Active Contributor
0 Kudos

Hi Erlan,

Standard currency conversion process is for

1. Reporting Currency Mode - Convert transaction data from LC to reporting currency

2. Group Currency Mode - Convert subsidiaries' data to Group's currency

For your requirement which is to convert from a transaction currency to a reporting currency, std currency conversion process will not work. You need to tweak the process as described in the doc.

Hope it helps!!

Former Member
0 Kudos

Agree with the above that it looks like you are using Reporting Currency mode.

In your currency dimension if you flag USD with RPTCURRENCY as "Y" and run the package for "USD" RPTCURRENCY this will also convert to USD

If you want to use Group currency reporting method - you need to ensure LC is loaded to NO_GROUP, and on the Group dimension for CG001 you can maintain the group currency as "USD,KZD" and the package will then be run for CG001 and convert to both currencies.