cancel
Showing results for 
Search instead for 
Did you mean: 

Curreny Translation

Former Member
0 Kudos

Hello Everybody ,

We have already implemented SEM-BCS. The reporting with SAP SEM-BCS permits only an evaluation on BU level. Therefore, it was decided to develop a MIS-reporting based on SAP BW.

The MIS-reporting shall be used by all Legal Entities already using (SAP R/3). The following reports will be implemented:

ð Balance Sheet

ð P&L (profit & lost)

All the reports are supposed to be very flexibly according to the reporting requirements of the controllers. Therefore, the reports will provide report views based on a combination of segment, BU, Profit centers and Legal Entities.

We are using the same infoobjects from SEM-BCS for our MIS data Model which will also act as data stream for BCS afterwardsl. The datasource is providing just local currency but we want to have a group currency as well. Following is my doubts

How we can do the currency translation to get values in group currency ?Can we use settings done in our SEM-BCS to get GC in our MIS model.Is that possible?? Or we need to create a seprate SEM-BCS databasis for MIS Curreny translation....

Cant we go for normal currency translation for MIS reporting rather going for BCS logic??

How can we achive GC for our MIS reporitng

Thanks in advance

Waiting for your kind replies

Atul

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Atul,

I quess that MIS stands for Management Information System, right?

I'll describe shortly the typical situation I met many times already.

The central BW-instance of the holding is loaded with the data of its companies (many views, dimensions, profit centers, BU etc.). Reports generated on this basis (B/S & P&L of the companies, different operational management reports, budget appropriation etc. -- most likely everything in local currency) are used by FinController and his/her folks for controlling the life of the separate parts of the holding and checking the consistency of data.

This is data as they were submitted (and modified if aneeded) by the companies.

Having been checked (and cleansed) this data is coming to the staging cube in BW. This cube is used by SEM-BCS for reading data from datastream. As Dan mentioned, in BCS you may set up the currency translation and get consolidated reports in GC.

Management reports might be built upon both, original data BW cube, and virtual totals BCS cube. Everything depends on the nature of reports: some of them supposed to be consolidated, some - not.

Moreover, non-consolidated reports you may generate in GC using different methods for currency translation provided by BW.

Former Member
0 Kudos

Hi Eugene ,

Thanks for your reply. We have decided to go for the following currency translation :-

Assets and liabilities according to the closing rate

· · Profit and Loss statement at the average rate

·Can u just clarify me what actually here average rate implies, Is it the average of closing rates of the periods . Average of what ?? I mean how we can arrive at average rates .

Waiting for your kind reply.

Thanks

Atul

dan_sullivan
Active Contributor
0 Kudos

In mt experience, typically the average rate is the average of each day's daily rates. However it is also in some cases simply the average of the begining of the period rate and the end of the period rate.

Former Member
0 Kudos

Hi Atul,

It's interesting how our experience with Dan supplements each other: he had a lot of projects dealing with R/3, while I was more involved with 3rd parties.

Ok, provided by Dan info, I guess is useful when you deal with ECCs (R/3s).

By the way, Dan, AFAIK, the BCS doesn't work with 'M' type of CT keys. How to use the CT rates from ECC?

Atul, from my experience, when dealing with 3rd party tools or loading from flat files, C/T in SEM-BCS might be straight-forward: practically all C/T keys use the direct read of C/T rates from the database. It means that you may determine, for example:

- 1001 C/T type - for current rate (closing rate) for version 100

- 2002 C/T type - for average for the current month (quarter) rate for version 200

- 3003 C/T type - for average YTD rate for version 300

and so on.

- In this case just enter the rate once a month/quarter/whatever for the given currency and the C/T type.

The system will take this entered rate and no headacke at all.

dan_sullivan
Active Contributor
0 Kudos

The CT rates, including M type, are typically extracted from ECC into the SEM environment in order for BCS to use them. BCS works with M rate type if called for in configuration of method.

Otherwise the rates may be manually entered in BCS workbench or BW, or updated via interface to the SEM system.

Former Member
0 Kudos

That's why was asking about "M" C/T key that it was not clear how it is used in BCS?

The C/T key "M" doesn't determined in BCS. So, how to use it? AFAIK, it's used in R/3 only(3)?

Not only??? Could you please clarify?

dan_sullivan
Active Contributor
0 Kudos

Where M rate type is the daily "spot" rate, it may be used in BCS for the period-end rate in the translation method.

Former Member
0 Kudos

Excuse me Dan, how?

What the settings must be done in BCS?

Former Member
0 Kudos

Hi Again ,

Thanks a lot for your fast and prompt reply.

Can we use these C/T types in Query Designer as we are not doing the currency translation in SEM BCS.

If yes can u just briefly give me the tips how to do it.

Regards

Atul

Former Member
0 Kudos

Do not ask me. It's a question to Dan.

Former Member
0 Kudos

Hi Again ,

Thanks a lot for your fast and prompt reply.

Can we use these C/T types in Query Designer as we are not doing the currency translation in SEM BCS.

If yes can u just briefly give me the tips how to do it.

Regards

Atul

dan_sullivan
Active Contributor
0 Kudos

Eugene, There must be some misunderstanding between us about this. I'll do my best to clarify, but if it does not answer your question, please be very specific as to what you are asking so that I may better answer you.

In ECC the exchange rate table may have several rate types including the rate type M. In many cases this is used for the daily spot exchanges rates (that may not be the case for every instance). This table may be extracted into BW with the same values. In BCS translation method if rate type M is used for period-end rate translations as most balance sheet items are translated. The exchange rate determination may be set to exchange rate type and type M may be selected.

I realize that in some ECC systems the text for the M rate type may be "Standard translation at average rate" but this is not necessarily the case for all ECC or R/3 systems. The text is also modifiable.

Does that help?

dan_sullivan
Active Contributor
0 Kudos

I am not a query designer expert and cannot answer this question.

I'm certain there are several other experts will answer this.

Former Member
0 Kudos

Thanks, Dan. But not really.

The BW system may upload any C/T rates existing in the connected R/3.

In the BCS system I may use any uploaded into BW system C/T rates.

What should I set up in SEM-BCS in order to say the system to use the uploaded from R/3 "M" values, not my own entered manually rates, for example, for C/T type 1001? Any numbering rules, or any other settings, or whatever?

dan_sullivan
Active Contributor
0 Kudos

In the configuration of the translation method is where you set what rate type is to be used, be it 1001 or M.

When rates are extracted from ECC or R/3 the options are for updates only or for ovewrite existing values. When overwrite is chosen, then any manually entered rates may be overwritten.

BCS uses the same exchange rate table as in BW.

BCS will take the last entry on the exchange rate table for the period for which translation is being executed. If there are rates for future dates beyond that they are ignored for the period being processed.

There are no other settings or rules I am aware of. It is simply a matter of what is configured for the method and what exists in the table.

Former Member
0 Kudos

Ok, Dan. I really appreciate it very much.

I'm leaving this thread in order not to burden it very much with (off-top?) themes.

But be ready to answer some more questions regarding the issue.

Thanks again!

Answers (1)

Answers (1)

dan_sullivan
Active Contributor
0 Kudos

If BCS is already implemented I suggest you use standard translation method in BCS and execute this for group currency.

After the translation is complete, as well as any other consolidation tasks, the data from BCS may be datamarted (see previous forum posting regarding SAP whitepapers for BCS datamart). The BCS datamart may then be a source for the reporting.

The other alternative may be viable, but I am not as familiar with it as Eugene is.