topic Re: currency query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/currency-query/m-p/4606031#M1085502 <HTML><HEAD></HEAD><BODY><P>hi tanisha,</P><P></P><P>CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'</P><P> EXPORTING </P><P> DATE = BKPF-WWERT</P><P> FOREIGN_CURRENCY = BKPF-WAERS</P><P> LOCAL_CURRENCY = T001-WAERS</P><P> LOCAL_AMOUNT = BSEG-DMBTR</P><P> RATE = BKPF-KURSF</P><P> TYPE_OF_RATE = 'M'</P><P> </P><P> IMPORTING </P><P> EXCHANGE_RATE = KURS</P><P> FOREIGN_AMOUNT = BSEG-WRBTR</P><P> FOREIGN_FACTOR = FAKTOR-F</P><P> LOCAL_FACTOR = FAKTOR-L</P><P> </P><P> EXCEPTIONS </P><P> NO_RATE_FOUND = 4</P><P> NO_FACTORS_FOUND = 8.</P><P></P><P></P><P></P><P>regards</P><P>arjun</P></BODY></HTML> Fri, 24 Oct 2008 04:28:02 GMT arjun_thakur 2008-10-24T04:28:02Z currency query https://community.sap.com/t5/application-development-and-automation-discussions/currency-query/m-p/4606030#M1085501 <HTML><HEAD></HEAD><BODY><P>i am using this function module for the currency conversion.</P><P>please tell is the fields correct that i am passing through it and how will be the date and currency field declaration.</P><P>please elaborate,</P><P></P><P>CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'</P><P> EXPORTING</P><P> CLIENT = SY-MANDT</P><P> date = b_date</P><P> foreign_currency = 'USD'</P><P> local_amount = g_usd1</P><P> local_currency = 'BRL'</P><UL><LI level="1" type="ul"><P> RATE = '0.57208'</P></LI><LI level="1" type="ul"><P> type of rate = 'M'</P></LI></UL><P> IMPORTING</P><UL><LI level="1" type="ul"><P> EXCHANGE_RATE =</P></LI></UL><P> FOREIGN_AMOUNT = g_usd</P><UL><LI level="1" type="ul"><P> FOREIGN_FACTOR =</P></LI><LI level="1" type="ul"><P> LOCAL_FACTOR =</P></LI><LI level="1" type="ul"><P> EXCHANGE_RATEX =</P></LI><LI level="1" type="ul"><P> DERIVED_RATE_TYPE =</P></LI><LI level="1" type="ul"><P> FIXED_RATE =</P></LI><LI level="1" type="ul"><P>EXCEPTIONS</P></LI><LI level="1" type="ul"><P> NO_RATE_FOUND = 1</P></LI><LI level="1" type="ul"><P> OVERFLOW = 2</P></LI><LI level="1" type="ul"><P> NO_FACTORS_FOUND = 3</P></LI><LI level="1" type="ul"><P> NO_SPREAD_FOUND = 4</P></LI><LI level="1" type="ul"><P> DERIVED_2_TIMES = 5</P></LI><LI level="1" type="ul"><P> OTHERS = 6</P></LI></UL><P> .</P><P>IF sy-subrc &lt;&gt; 0.</P><UL><LI level="1" type="ul"><P>MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</P></LI><LI level="1" type="ul"><P> WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</P></LI></UL><P>ENDIF.</P></BODY></HTML> Thu, 23 Oct 2008 12:06:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/currency-query/m-p/4606030#M1085501 Former Member 2008-10-23T12:06:21Z Re: currency query https://community.sap.com/t5/application-development-and-automation-discussions/currency-query/m-p/4606031#M1085502 <HTML><HEAD></HEAD><BODY><P>hi tanisha,</P><P></P><P>CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'</P><P> EXPORTING </P><P> DATE = BKPF-WWERT</P><P> FOREIGN_CURRENCY = BKPF-WAERS</P><P> LOCAL_CURRENCY = T001-WAERS</P><P> LOCAL_AMOUNT = BSEG-DMBTR</P><P> RATE = BKPF-KURSF</P><P> TYPE_OF_RATE = 'M'</P><P> </P><P> IMPORTING </P><P> EXCHANGE_RATE = KURS</P><P> FOREIGN_AMOUNT = BSEG-WRBTR</P><P> FOREIGN_FACTOR = FAKTOR-F</P><P> LOCAL_FACTOR = FAKTOR-L</P><P> </P><P> EXCEPTIONS </P><P> NO_RATE_FOUND = 4</P><P> NO_FACTORS_FOUND = 8.</P><P></P><P></P><P></P><P>regards</P><P>arjun</P></BODY></HTML> Fri, 24 Oct 2008 04:28:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/currency-query/m-p/4606031#M1085502 arjun_thakur 2008-10-24T04:28:02Z