topic Working with SAP and TCURR in QlikView https://community.qlik.com/t5/QlikView/Working-with-SAP-and-TCURR/m-p/450750#M489203 <HTML><HEAD></HEAD><BODY><DIV>Hi all,</DIV><DIV> </DIV><DIV>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.</DIV><DIV> </DIV><DIV>I have the contents of table TCURR available which contains:-</DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>RateType</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>FromCurr</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ToCurr</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DateFrom</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ExchRate</STRONG></SPAN></TH></TR><TR><TD>P</TD><TD>EUR</TD><TD>USD</TD><TD>20120701</TD><TD>1.3234</TD></TR><TR><TD>M</TD><TD>EUR</TD><TD>USD</TD><TD>20120101</TD><TD>1.2442</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>And I have a main billing facts table which has many fields but an example is below:-</DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>CompanyCode</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>FiscPer</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ProdHierLev1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style=": ; color: #ffffff;">DocCurr</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>NetRevenue</STRONG></SPAN></TH></TR><TR><TD>0500</TD><TD>001.2012</TD><TD>PYT</TD><TD>EUR</TD><TD>100</TD></TR><TR><TD>0500</TD><TD>001.2012</TD><TD>PYT</TD><TD>GBP</TD><TD>200</TD></TR></TBODY></TABLE><DIV> </DIV><DIV>My question is... in QlikView world how can I join this data?&nbsp; 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.</DIV><DIV> </DIV><DIV>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.</DIV><DIV> </DIV><DIV>Any hints and tips will be very much appreciated!</DIV><DIV> </DIV><DIV>Thanks in advance.</DIV><DIV> </DIV><DIV>Sean.</DIV></BODY></HTML> Tue, 20 Nov 2012 11:42:54 GMT 2012-11-20T11:42:54Z Working with SAP and TCURR https://community.qlik.com/t5/QlikView/Working-with-SAP-and-TCURR/m-p/450750#M489203 <HTML><HEAD></HEAD><BODY><DIV>Hi all,</DIV><DIV> </DIV><DIV>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.</DIV><DIV> </DIV><DIV>I have the contents of table TCURR available which contains:-</DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>RateType</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>FromCurr</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ToCurr</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DateFrom</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ExchRate</STRONG></SPAN></TH></TR><TR><TD>P</TD><TD>EUR</TD><TD>USD</TD><TD>20120701</TD><TD>1.3234</TD></TR><TR><TD>M</TD><TD>EUR</TD><TD>USD</TD><TD>20120101</TD><TD>1.2442</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>And I have a main billing facts table which has many fields but an example is below:-</DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>CompanyCode</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>FiscPer</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ProdHierLev1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style=": ; color: #ffffff;">DocCurr</STRONG></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>NetRevenue</STRONG></SPAN></TH></TR><TR><TD>0500</TD><TD>001.2012</TD><TD>PYT</TD><TD>EUR</TD><TD>100</TD></TR><TR><TD>0500</TD><TD>001.2012</TD><TD>PYT</TD><TD>GBP</TD><TD>200</TD></TR></TBODY></TABLE><DIV> </DIV><DIV>My question is... in QlikView world how can I join this data?&nbsp; 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.</DIV><DIV> </DIV><DIV>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.</DIV><DIV> </DIV><DIV>Any hints and tips will be very much appreciated!</DIV><DIV> </DIV><DIV>Thanks in advance.</DIV><DIV> </DIV><DIV>Sean.</DIV></BODY></HTML> Tue, 20 Nov 2012 11:42:54 GMT https://community.qlik.com/t5/QlikView/Working-with-SAP-and-TCURR/m-p/450750#M489203 2012-11-20T11:42:54Z Re: Working with SAP and TCURR https://community.qlik.com/t5/QlikView/Working-with-SAP-and-TCURR/m-p/450751#M489204 <HTML><HEAD></HEAD><BODY><P>I fixed this myself.&nbsp; I joined the billing facts table to the exchange rate table on DOC_CURRCY.&nbsp; 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.</P></BODY></HTML> Wed, 19 Dec 2012 13:28:50 GMT https://community.qlik.com/t5/QlikView/Working-with-SAP-and-TCURR/m-p/450751#M489204 2012-12-19T13:28:50Z