Local &Group Currency display for 0cca_c11

[Former Member]

Hi, Have a requirement I am not sure how to approach.

Have to display Local Currency and Group Currency in the reports. This is the first time I am dealing with currencies.

The Cube is : 0cca_c11 , infosource : 0CO_OM_CCA_1 ,0CO_OM_CCA_9.

Currently in BW I have only USD values. Trying to do a load too. The table for the records is COEP with GBP values.

-How to know which currency is being displayed? and

Currency Key?

-How to bring both local and group currency in BW and display them in reports. Its USD and GBP being used in R/3. There are no currency settings at all done in BW before.

Please suggest as I am not sure where do I have to start and what approach to follow.

Thanks

Sarah

[former_member188975]

Hi Sarah,

This should be possible using the 0CURTYPE InfoObject to store the currency type: Local and Group currencies (field CURTYPE in the transfer structure).

Hope this helps...

[Former Member]

Thanks for the response Bhanu.

In 0CURTYPE I have Document Currency, Company Code and Controlling area currency. We use CA currency in reports.

Do i have to create a new keyfig and new currency key to be able to bring LC and GC?

How do I know which currency is being displayed rt now?

~Sarah

[former_member188975]

Hi Sarah,

Group Currency comes in as "30" value for CurType. In the report it would be good to include this InfoObject and may be also use a variable for it so that users can decide what data to see. This way using the same key figure, different currency type values can be seen, instead of creating different KF.

Hope this helps...

[Former Member]

Hi Bhanu,

In that case which is local currency? As of now I have 00, 10, 20 in CurType and all are USD only.

How to bring in 30 and local currency ?

Will this support to get data in "GBP" also as in COEP table under WOGBTR: Value ObjectCurrency field.

Thanks

~Sarah

[former_member188975]

Hi Sarah,

Not sure what is the key for Local Currency, but you are seeing only 00, 10 and 20 in 0CURTYPE as only those values exist in your system. As you load more data, other values will be created as well. You need to make sure that 0CURTYPE is mapped to CURTYPE in your transfer structure. The 0CURTYPE will hold the type of currency, and your 0CURRENCY InfoObject will hold the actual value of the currency like USD or GBP etc...so your record will be like:

xxxxxxxxxx 20 USD

xxxxxxxxxx 30 GBP

Hope this helps...

[Former Member]

Thanks Bhanu, I understood part of Currencies with your response as I had no idea at all about how to work with currencies before. If at all you do find any information on Currencies, how to set Currency keys (RRC1, RRC2) etc. please suggest. Thanks once again for the direction.

Will now try to first set 0Curtype as /BI0/OICURTYPE table itself is not updated since long time. Moreover its showing /BI0/OICURTYPE & /BI0/OICURRENCT tables as inactive in SE16 but the objects are active .

So will try to set this up and try to load Local and Group Currency and then get back if still have issues. Thanks once again.

~Sarah

[former_member188975]

Hi Sarah,

For related info, please go through these threads:

Feel free to ask any other questions once you have done the load...

[Former Member]

Hi Sarah,

I have the same problem now in my project of , I need to give an option to the user to select Local currency or Group currency. You have done the thing. Can you give me the information like :

--> From which cube you fetched that infoobject 0CURTYPE which contains local/group type.

Can you explain me the whole process how u have done the mapping and with what keyfigures you mapped this infooject with???

IN my cube we defined Local currency and Group Currency as key figures, so how to map this char 0CURTYPE with keyfigures ..... can u explain me please..

Cheers.

Suntiha.

[Former Member]

You shoudl have 0CURR_TYPE n your cube - then select 00 for transaction currency, 10 for local and 20 for group

This works for most of the Finance cubes