Routine conversion currency

[Former Member]

Hi all,

I need know the routine to convert currency.

I need this routine because when I load, I get a dump due to diferent currency type.

Can you help me please?

Thanks and regards.

[former_member187400 · Accepted solution]

Hi German ,,

To convert your local currency to foreign one ..

You can use this function in your routine:

CONVERT_TO_LOCAL_CURRENCY

e.g.

CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'

EXPORTING

DATE = COMM_STRUCTURE-/BIC/ZACTVADT "current date

FOREIGN_AMOUNT = COMM_STRUCTURE-/BIC/ZACTVPDoc " local currency amount

FOREIGN_CURRENCY = COMM_STRUCTURE-DOC_CURRCY " local currency

LOCAL_CURRENCY = 'USD' " forign currency

IMPORTING

LOCAL_AMOUNT = RESULT

EXCEPTIONS

NO_RATE_FOUND = 1

OVERFLOW = 2

NO_FACTORS_FOUND = 3

NO_SPREAD_FOUND = 4

OTHERS = 5.

Hopefully it can help you a lot..

Regards,

Niel.

• Thanks a lot for the points you choose to assign.

[Former Member]

Hi German,

i assume you are in BI 7.0, the currency conversion can be done via the transformation which links two data target together, e.g. from ODS to Cube or ODS to ODS or Cube to ODS. Please note this is a complex topic, hence, i might not be able to provide the full ansewer in one go.

In each key figure routine, you should be able to see the following settings:

Description

Targt InfoObjct 0CS_TRN_GC Period Value in Group Currency

Rule Type Direct Assignment

Aggregation Summation

Currency

Target Currency 0CURKEY_GC Currency Key for Group Currency

Currency "From Source" or "From Conversion"

Source Currency 0CURKEY_GC Currency Key for Group Currency

"From Source" meaning changing the target (e.g Cube) currency to source (e.g. ODS) currency if you have multiple different currency from your source, say an ODS, then you can switch to one of them.

"From Conversion" meaning the conversion routine is based on a currency type that you created via RSCUR. this is separate configuration, please let me know if you need help to configure your currency conversion type.

cheers.