topic Re: issue with spell_amount in Application Development and Automation Discussions

issue with spell_amount

pashasapcha — Mon, 09 Oct 2023 11:54:45 GMT

Hi, gurus

I have requirement where till now the business is using 'HR_IN_CHG_INR_WRDS' to convert amount into text which is displaying

in rupees. However, now it has to be used for other currencies also

I have tried 'SPELL_AMOUNT'

but it is throwing dump as it is saying wa_head-currency is having different field type than expected.

when I double clicked on it it is of type char20 in custom structure.

But the function module parameter is of SY-WAERS following type for currency.

What can I do so that the fm spell check will give me the amount in words.

Thanks in advance.

Re: issue with spell_amount

Dominik_Tylczynski — Mon, 09 Oct 2023 12:33:11 GMT

Hello pashasapcha

It looks like the CURRENCY field in your structure is incorrectly defined. It shouldn't be of CHAR20 type, but of WAERS which is dedicated for currency fields.

Why don't you declare a local variable like sy-waers, assign the currency from your structure and call SPELL_AMOUNT with that local variable - code snippet:

DATA:
lv_waers LIKE sy-waers.

lv_waers = wa_head-currency.

CALL FUNCTION 'SPELL_AMOUNT'
  EXPORTING
    amount    = amt_num
    currency  = lv_waers
    filler    = ' '
    language  = sy-langu
  IMPORTING
    in_words  = wa_head-amt_in_wrds
  EXCEPTIONS
    not_found = 1
    too_large = 2
    OTHERS    = 3.

IF sy-subrc <> 0.
* Implement suitable error handling here
ENDIF.

Best regards

Dominik Tylczynski

Re: issue with spell_amount

matt — Mon, 09 Oct 2023 12:58:08 GMT

CALL FUNCTION 'SPELL_AMOUNT'
  EXPORTING
    amount    = amt_num
    currency  = CONV syst_waers( wa_head-currency )
    filler    = ' '
    language  = sy-langu
  IMPORTING
    in_words  = wa_head-amt_in_wrds
  EXCEPTIONS
    not_found = 1
    too_large = 2
    OTHERS    = 3.

Re: issue with spell_amount

pashasapcha — Mon, 09 Oct 2023 13:11:09 GMT

I have tried the same way, now the dump is due to length of amt_in_wrds.

I have checked the fm import parameter 'IN_WORDS'

but here SPELL is a structure with 35 fields. how can I fix the length issue so that I can avoid dump.

Re: issue with spell_amount

Sandra_Rossi — Mon, 09 Oct 2023 13:35:16 GMT

The question title doesn't deserve this misleading title "issue with spell_amount", because it's just a dump because of different parameter/argument type, which has been asked many many times in the forum.

You must pass the same type.

Re: issue with spell_amount

Dominik_Tylczynski — Mon, 09 Oct 2023 13:53:44 GMT

matthew.billingham that will work too of course - I'm just an old dog.

Re: issue with spell_amount

Dominik_Tylczynski — Mon, 09 Oct 2023 14:01:10 GMT

pashasapcha You need to get the output of the function into a variable of the SPEEL type, then get the spelled amount out of the WORD field. Check the documentation of the function. It points to the RF_SPELL report that contains a sample call to the function.

Re: issue with spell_amount

Sandra_Rossi — Mon, 09 Oct 2023 16:07:09 GMT

matthew.billingham I think constructor expressions are invalid with function module parameters. I guess SAP doesn't want to invest on the old function module concept.

Re: issue with spell_amount

matt — Tue, 10 Oct 2023 08:07:20 GMT

sandra.rossi I've used CONV many times with FM.

Re: issue with spell_amount

Sandra_Rossi — Tue, 10 Oct 2023 13:49:42 GMT

matthew.billingham Thanks. I confirm (test in ABAP 7.57). Well, still learning :D. I'll test in other ABAP releases to see why I had this in mind.

Re: issue with spell_amount

ChristianGnter — Wed, 11 Oct 2023 06:31:21 GMT

sandra.rossi I guess you meant CONV #( ) which is not possible with FMs as it cannot derive the type statically.

Re: issue with spell_amount

matt — Wed, 11 Oct 2023 06:39:46 GMT

christian.guenter

as it cannot derive the type statically.

It could try! 😄