Skip to Content
avatar image
Former Member

calculation field is defined too small when using a SAP function in Query

Hi folks,

I applied a SAP function which is to convert amount in local currency. I got the below short dump when I execute the job.

"Calculation field is defined too small.[SAP NWRFC 720][SAP Partner 740 ]

The calculate field is decimal. I made the target table larger which did not help. In the Query, I'm not able to edit on the type of calculation field.

Please give me some help! Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 10, 2016 at 03:40 PM

    This is not a DS error. The error message comes from the SAP function. Which function do you call? What are the values you pass?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2016 at 04:38 PM

    That confirms my answer. There's a FOREIGN_AMOUNT value resulting in a too high value for EXCHANGE_RATEX. Can you run data profiling on the input column?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2016 at 05:15 PM

    I changed the data type of EXCHANGE_RATEX. Then the previous warning has gone. But there is a new one.

    R/3 CallReceive warning: <Function Z_CONVERT_TO_LOCAL_CURR_RFC: RFC_ABAP_EXCEPTION-(Exception_Key: NO_RATE_FOUND, Enter 3300 / USD rate type M for 2009.04.15 in the system settings)[SAP NWRFC 720][SAP Partner 740

    I have put 'Rate' as default value 0 / 8/4.11....etc.. Not sure what kind of value should put here. Please advise.

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2016 at 05:56 PM

    I suggest testing your function in se37 before trying to use in Data Services.

    Add comment
    10|10000 characters needed characters exceeded