Currency translation

[Former Member]

Hi everyone,

I am extracting data from 2lis_02_acc datasource into BW ODS.There is one field called non deduc tax ,which should come in document currency.This document currency is available in my ODS.But there is no document currency field in this datasource.But there are local currency and order currency fields in the datasource and ODS.So, because of not getting doc currency, that particular infoobject is showing currncy error.Please suggest how to get this doc currency data into my ODS.

Thanks.

[mansi_dandavate]

Hi,

You can convert the incoming data into document currency...

You can use the function module CONVERT_TO_LOCAL_CURRENCY for this purpose...

[Former Member]

Hi Mansi,

Thanks for ur reply.But I need to convert it from Local currency to Doc currency.Will it possible to do this with the FM suggested by you?Becoz when I executed this FM iam not getting doccurrency in the output.Pls advice.

Thanks.

[mansi_dandavate]

Yes this function module will help you for that too...

Basically when you execute the function module it asks you local_currency i.e. the currency in which you want the output..

and foreign_curreny is the currency in which you have your data...

So there you need to specify your document currency...like USD, or any that you want..

THen it will convert the amount from Foreign_currency to local_currency.

[Former Member]

Hi Mansi,

You mean I should map the HWAERs to 0DOC_CURRCY in the transfer rules and write a routine there calling this particular FM.?

Thanks.

[mansi_dandavate]

You need to know what is the document currency for every transaction...

Do you have that info anywhere?

If yes then you can give HWAERs as the input currency to the FM and the document currency as the ouptu.

What you can do is find in ECC any table where the document currency is stored and then enhance your datasource to bring this currency and then in BI you can do currency translation.

Edited by: mansi dandavate on Aug 17, 2009 7:38 AM

[Former Member]

Hi Mansi,

I have checked for the doc currency field in all the tables on which this data source is based, but no table contains this particular field.So, how can I use this fm in this scenario.pls suggest.

Thanks

[mansi_dandavate]

Ask the functional guy responsible to let you know the table from where you will get document currency....

[Former Member]

Hi Mansi,

Thanks for ur replies.But, as per my user I dont want to enhance my datasource with document currency.I just need to get document currency along with tax value as it is based on document currency.

For example if tax value is 100,then in my report now it is coming as 100error, becoz of no values are getting populated for 0doc currency info object.so, I need to get values for 0doc_currency based on local currency values.I have odocdate,odoctype etc.,.in my ODS.Is it possible to get 0doccurency values based on all these fields I mentioned.Pls advice.

Thanks

[mansi_dandavate]

Ok.. Is the value of document currency same for all the records like USD??

Or will it change?? If yes then you need to ask the functional guy from where should you pick this...