Skip to Content

Dump while converting data for exchange rates.

Hello Expert,

I am importing the list of currency exchange values from the flat file and after some clean-ups, passing the file data to the BAPI

BAPI_EXCHRATE_CREATEMULTIPLE.

To pass the exchange rate, the data-type used by BAPI is UKURSP (length 9, decimal 5). So i am assigning my CHAR values to the bapi-data type to get he 5 decimal value.

It is working correctly if exchange value from the CSV file is, for eg, 0007.6269000 --> getting converted to 7.62690

but i am getting dump when the value is 15973.900000. This is not getting converted to 5 decimal required for BAPI;s field UKURSP.

How to solve the problem?

Kindly advise.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 11 at 11:32 AM

    Please post the error message next time.

    The value cannot be casted into the currency field, as it is too big:

    • The source value 15973.900000 hast 5 characters before the decimal point and 6 characters after the decimal point, whereas only the first is relevant, as the others are all 0.
      => So you would need a type that has at least 5 characters before and at least 1 character after the decimal point
    • The type UKURSP has in total 9 characters, 4 before the decimal point, and 5 after the decimal point
      => Therefore the value 15973.9 cannot fit into a variable of Type UKURSP without loosing information, and therefore it dumps

    What currencies are involved in the exchange rate? Have you looked at the current "Currency Exchange Rates (V_TCURR)" to see how this exchange rate pair has been stored in the past?

    • Have you checked the customizing "Currencies: Translation Ratios (V_TCURF)" and whether you should be dividing that input value by the corresponding ratio?
    • And also whether instead of using the "Direct Quoted Exchange Rate" (Field KURSP, Type UKURSP), you might rather use the "Indirect Quoted Exchange Rate" (Field KURSM, Type UKURSM), which is the reciprocal (inverse value), see customizing "Currency Translation Exchange Rate Types V_TCURV)".

    => So inorder to save 'that' exchange rate in your system, you will definitly have to use to set the correct ratio factors and maybe use the inverse value instead in your BAPI, you should check your customizing and current values

    BAPI value and ratios for direct quoted exchange rate:

    • EXCH_RATE Types UKURSP
    • FROM_FACTOR Types FFACT_CURR
    • TO_FACTOR Types TFACT_CURR

    BAPI value and ratios for indirect quoted exchange rate:

    • EXCH_RATE_V Types UKURSM
    • FROM_FACTOR_V Types FFACT_CURR
    • TO_FACTOR_V TypesTFACT_CURR
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 11 at 12:59 PM
    -1

    Sandra Rossi unfortunately the target field is having 4 digits before the decimal and 5 after the decimal (length 9), therefore conversion is not happening in this case.

    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.