Working with SAP and TCURR

[#1]

Hi all,

I'm very new to QlikView so appologies for being dumb... but I am struggling to find the best way (or any way!) of calculating figures based on current rates that are maintained in SAP.

I have the contents of table TCURR available which contains:-

RateType	FromCurr	ToCurr	DateFrom	ExchRate
P	EUR	USD	20120701	1.3234
M	EUR	USD	20120101	1.2442

And I have a main billing facts table which has many fields but an example is below:-

CompanyCode	FiscPer	ProdHierLev1	DocCurr	NetRevenue
0500	001.2012	PYT	EUR	100
0500	001.2012	PYT	GBP	200

My question is... in QlikView world how can I join this data?  In BW it is all handled at query runtime by SAP, but I know that I need to somehow replicate that in QlikView but I'm unsure how.

What I need is for the users to be able to select a target currency (USD) and rate type and convert all NetRevenue values at that rate as per TCURR table.

Any hints and tips will be very much appreciated!

Thanks in advance.

Sean.

[#2]

I fixed this myself.  I joined the billing facts table to the exchange rate table on DOC_CURRCY.  For P rate conversions only the latest P rate is used regardless of time so I just needed to find the latest P rate for the DOC_CURRCY and the TO_CURRCY.