Question Re: 0CURRENCY in Technology Q&A

0CURRENCY

Former Member — Mon, 30 May 2011 15:36:15 GMT

Hi All,

I am loading data through flat file interface, i get master data load seperately and transcation data load seperately. In transcation data against Sales ( the file which am getting) due to some reasons unable to populate 0CURRENCY for that particular sales. However, am getting currencies against each country in master data. How to map source and target with above scenario wrt transcation data where i need currency against sales in cube.

Re: 0CURRENCY

former_member360228 — Mon, 30 May 2011 15:52:23 GMT

You are talking about two different things here, if you need currency in your transaction data then they should come through your transaction data flat file only along with the amount key-figures. Another option is to have them as constant for your key-figures in the transformation. So either get the currency information in the flat file or confirm with business or the functional team if you can have a constant for your currency(which is only possible if your client deals in only one country).

Regards,

Arminder

Re: 0CURRENCY

Former Member — Mon, 30 May 2011 16:04:42 GMT

hmm..Thanks Arminder for quick reply

What i assume is if i make 0currency as attribute of country and do some abap... does it work.

Thought of mapping 0currency with infoobject assignment at rule details, unable to tell the system what is the source currency. this was a workaround.

So is it a bench mark that to get currency against transcation data, it should be loading in transcation data itself.

Re: 0CURRENCY

former_member360228 — Mon, 30 May 2011 16:25:16 GMT

Under normal conditions for every key-figure you should have its currency coming along in the transaction data. In your case since you are saying that on the basis of country you want to have the currency for a key-figure then it all depends on your requirement. Most of the time in the transaction data you wont have the country field associated with each line item, but in your case if you have country field associated with every item of transaction data then you can read the master data but i doubt this would be the case.

The best approach would be to ask the team who sends you the transactional flat file to add another field for currency for the amount key-figure and then you map it directly with your data target.

Regards,

Arminder

Re: 0CURRENCY

Former Member — Mon, 30 May 2011 16:30:49 GMT

Hi,

If you have Selling Country is available in your transaction file, you can select country master in internal table and populate 0CURRENCY in update routine based on the Country.

But are you sure transactions will always be in local currency?

Re: 0CURRENCY

Former Member — Mon, 30 May 2011 16:38:56 GMT

Hi Parth,

Differnt countries, different currencies

Re: 0CURRENCY

Former Member — Mon, 30 May 2011 16:40:36 GMT

Hi Arminder,

Can i get a hint how to read master data, becoz am doing against transcation data sales.

Re: 0CURRENCY

former_member360228 — Mon, 30 May 2011 17:06:36 GMT

One straight forward option is to have "Read master Data" option in the mapping rules in the transformation, just mention the source as country info-object and currency as its attribute to be filled. But if you want to take performance into consideration then create an internal table in the start routine of you transaction data transformation and fill it up with data from your country master data, you only require country and currency to be filled. After filling it up you can perform a read table in the field level routine of your transformation from that internal table. You can search on SDN on how to write these routines to read from master data if you need help with the codes. But again it seems like a strange requirement.

Regards,

Arminder