Skip to Content
author's profile photo Former Member
Former Member

Currency Conversion in Bex Report

Hi,

My report is based on Procurement GR data. The requirement is based on currency conversions in selection screen

There are 2 columns in report which are planned exchange rate and applied exchange rate.

Logic:

“Applied exchange rate” should be exchange rate between document currency to selected target currency based on Posting date of the GR issue date from M type exchange

“Planned exchange rate” should be based on year (YYYY) from posting date of the GR issue 31.12.YYYY, should be exchange rate between document currency to selected target currency and M type exchange

Can you please update me how it can be done?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2013 at 08:45 PM

    Please update

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 29, 2013 at 04:25 AM

    Please search for below documents :--

    1) Currency Conversion using Variables in SAP BI -Reporting

    2) How to…Use Variables for Currency Conversion

    You need to apply variables locally to two Columns but not in the Filter pane.

    Create a Dummy KF and restrict it with GR Issue Date Variable. This is to enable to selection screen while running report. Hide this KF.

    Applied Exchange rate can be easily achieved by above two Documents which I proposed.

    For Planned Exchange rate, you must create a Calyear variable which replaces with GR Issue Date Variable-->External Value Key-->Offset Length as 4.

    Restrict this variable for Planned exchange Rate KF

    Hope I have given you some ideas to go ahead.

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.