Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

USD to LC currency conversion!!!

Hello, I am familiar with LC to Reporting currencies conversion. but my client has a requirement of USD to LC currency conversion, can someone give me an idea on how to do that with lookup?



Hi Zack,

Some comments:

1) You do not need to define scope for datasrc if you only send either one and want either one triggered. In your case if you send miscadj then corpadj gets included as well but we normally do not need that. These records will be handled when they are sent. Removeing xdim_memberset will improve performance.

2) For the rate lookup you need to define any dimensions that are not common or are variable:

Time is already defined, category as well;

We need source currency and destination currency. In the end you'd have something like this:

RateEntity = Global

RateDim = AccountDim.Ratetype

RateSrc = RateInput

SourceCurr:InputCurrency = USD

DestCurr:InputCurrency = CompanyDim.Currency // This is local currency

// Now we have two variable to look up

3) We need to multiply %value% with the rate stored in the appropriate intersection, in this case whatever local currency is and USD. Which one is divided by which one, depends how you store your rates.

WHEN DataSrcDim

IS miscadj, corpadj // We want to makse sure only these will be handled

REC(FACTOR=LOOKUP(SrcCurr)/LOOKUP(DestCurr),CurrencyDim="LC") //


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question