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

Currency Conversion in SAP Query

Posted on Oct 04, 2005 at 09:39 AM 376 Views

Hi,

I have created a query where I am reading a table with currency = NOK. I need to convert this currency to EUR before saving it to a file. I have searched SAP Library and found the "Convert" function under ABC Analysis, but I do not think I can use this since I am going to save directly to a file. (In DBF Format). Somebody know how to solve this? Another possibility could be to be able to save in DBF-format directly from the MCIS (Information structure)reports, but I think this is not possible?

Thankful for any answers 😊

Best Regards

Ellen Odegaard

ABAP Development
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Andreas Mann
    Andreas Mann
    Posted on Oct 04, 2005 at 09:51 AM

    Hi,

    you're talking about sq01 / sq02 `

    than you can solve it with an additional field (e.g. btr2)and an additional coding at event GET / record processing

    -> use fm 'CONVERT_TO_LOCAL_CURRENCY' to convert your value

    regards Andreas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Andreas Mann
      Oct 04, 2005 at 01:30 PM

      Thank you all very much 😊

      I was able to generate the infoset now, and hopefully it works also by testing..

      I have never tried this forum before, and this was a very positive experience 😊

      Best Regards

      Ellen

  • author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2005 at 09:46 AM

    Hi,

    Please try CURRENCY_DOCUMENT_CONVERT.

    Add comment
    10|10000 characters needed characters exceeded