Question:
Hi everybody,
I will appreciate if someone answers the following three questions.
1. What is the difference between 0CURRENCY, 0LOC_CURRCY, 0OBJ_CURR? What is DOCUMENT CURRENCY?
2. I do not find any master data tables showing a list of all the cuurencies and description. I see entries only in SID table for all three with same number of entries. Where to look for them?
3. While designing the data model, is it ok to use 0CURRENCY?
Thanks in advance.
Answer:
Hi everybody,
I will appreciate if someone answers the following three questions.
1. What is the difference between 0CURRENCY, 0LOC_CURRCY, 0OBJ_CURR? What is DOCUMENT CURRENCY?
2. I do not find any master data tables showing a list of all the cuurencies and description. I see entries only in SID table for all three with same number of entries. Where to look for them?
3. While designing the data model, is it ok to use 0CURRENCY?
Thanks in advance.
You can look up the definitions of these objects in your metadata repositry, but the short answer is that SAP assigns different currencies for different contexts. 0DOC_CURR is used in the context of the business document, such as Sales Order, Billing Document, Delivery Document, etc. 0LOC_CURR is used in the context of geographic location, such as country. 0CURRENCY is a unit of measure.
The master data tables for currency are the TCUR* tables (look at them in SE12). They work exactly like the currency tables on R/3.
You may use 0CURRENCY in modeling if you wish, but you may not care for the results. It might cause you a boatload of extra work down the road. Most currency amount InfoObjects have a default CUKY. Use it if you are unsure. If you do not want to dig through the metadata repository (and I strongly suggest that you do) you should find someone with an FI-CO background to explain currency in SAP to you.
Answer:
Don't see why he/she shouldn't use 0CURRENCY??? We've been using it for 3 years now without any problem. We also use 0LOC_CURRENCY when we deal with setups both for Great Brittain and the rest of Europe.
Answer:
perhaps the same in other words
let's assume that your company is working in EUR, have customers working in GBP, and is pertaining to a group that is working in USD
In the same record, you could have one amount labelled in the three currencies for three different purposes :
one amount in DOCUMENT currency, that is in GBP, using ZAMOUNT1 with currency in 0DOC_CURRENCY
the same amount in LOCAL currency, that is in EUR, using ZAMOUNT2 with currency in 0LOC_CURRCY
and the same amount a third time in STATISTICAL currency, that is in USD, using ZAMOUNT3 with currency in 0STAT_CURRCY
If you only had one infoobject speaking about currency in your record, you would not be able to specify that ZAMOUNT1 is not labelled in the same currency as ZAMOUNT2 or ZAMOUNT3
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Thanks CHC and ElBelgio. Still I cannot inderstand what CHC tells in the last para. Moreover, the meta data repository tells 0LOC_CURRCY is referenced to 0CURRENCY and I could not get more info like CHC has given for geographic, document view and intrepretation. However, I used 0CURRENCY and 0LOC_CURRCY for two different key figures as units/currency fields and in the csv files I gave different currencies. The Bex query gave correct display. I will appreciate if CHC can give more info what will be the problems in the long run if we use 0CURRENCY. Will the answer be different if the source system is not R/3? This is urgent as I am in the design phase.
Cheers.
Answer:
Look at your KF's (Currency ones). They have defined for them where to get the Currency type from (iether 0CURRENCY, 0LOC_CURRCY, 0DOC_CURRCY, etc...)
This makes a difference in that if you want or need to commonly report on values in a common currency, you might want to design your KF's to use several currency's..
Say I have 0KF1, and it uses 0DOC_CURRCY, so I load data which looks like this:
RECORD 0KF1 0DOC_CURRCY
1 100 USD
2 150 EUR
3 75 YEN
If I were to SUM 0KF1, I would get the result of:
325 MIXED VALUES
It would not be accurate b/c of mixed currency.
If I were however to add another KF, called 0KF2 with 0LOC_CURRCY as the currency for that KF, I could then load the same data above, with a routine which converts 0KF1 to 0KF2 to a common currency for 0KF2, such as USD.
So I could have the above, but additionally get: (using an exchange rate as well to do the conversion from document currency to local currency.)
RECORD 0KF2 0LOC_CURRCY
1 75 USD
2 50 USD
3 120 USD
So I could then accurately sum 0KF2.
You cannot have the same InfoObject in a a DS or Cube, so SAP provides multiple currency object for different purposes. You are free to use them however you wish.
If all you need is to pull in legacy data of the same currency, the just pick a currency to base your KF's off of.
- Stephen