topic Re: SPELL_AMOUNT in Application Development and Automation Discussions

SPELL_AMOUNT

Former Member — Thu, 14 Sep 2006 11:29:13 GMT

what r the limitation of function SPELL_AMOUNT

can it convert a number having more than 4 digit into

words

Re: SPELL_AMOUNT

dani_mn — Thu, 14 Sep 2006 11:32:54 GMT

HI,

Yes it can.

it can take upto 15 digits.

Regards,

Re: SPELL_AMOUNT

Former Member — Thu, 14 Sep 2006 11:34:47 GMT

Yes you can do it.Check the SAP standard program RF_SPELLfor your reference

Re: SPELL_AMOUNT

Former Member — Thu, 14 Sep 2006 11:35:27 GMT

i guess its upto 3 decimals.the reason behind is if you see the structure SPELL

DECIMAL IN_DECI NUMC 3 0 Decimal places of the amount converted

CURRDEC CURRDEC INT1 3 0 Number of decimal places

these both the fields are of 3 length.

correct me,if i am wrong.

for NUMERIC you can give any value.i guess there is no such limit for a NUMERIC. but the above explanation is for DECIMALS.

also check this post,

SRiaknth

Message was edited by: Srikanth Kidambi

Re: SPELL_AMOUNT

Former Member — Thu, 14 Sep 2006 11:36:56 GMT

i think it is taking as many

chk this prog by increasing the amount

REPORT ZSPELL.

TABLES SPELL.

DATA : T_SPELL LIKE SPELL OCCURS 0 WITH HEADER LINE.
DATA : PAMOUNT LIKE SPELL-NUMBER  VALUE '123451022343333235'.

SY-TITLE = 'SPELLING NUMBER'.

PERFORM SPELL_AMOUNT USING PAMOUNT 'USD'.

WRITE: 'NUMBERS', T_SPELL-WORD, 'DECIMALS ', T_SPELL-DECWORD.

FORM SPELL_AMOUNT USING PWRBTR PWAERS.

  CALL FUNCTION 'SPELL_AMOUNT'
       EXPORTING
            AMOUNT    = PAMOUNT
            CURRENCY  = PWAERS
            FILLER    = SPACE
            LANGUAGE  = 'E'
       IMPORTING
            IN_WORDS  = T_SPELL
       EXCEPTIONS
            NOT_FOUND = 1
            TOO_LARGE = 2
            OTHERS    = 3.
ENDFORM.                               " SPELL_AMOUNT

Re: SPELL_AMOUNT

Former Member — Thu, 14 Sep 2006 11:37:02 GMT

Hi Jitendra,

1) You can enter values upto 999 trillion ie it can accept upto 15 digits.

2) Upto this range it will converts into number into words.

3) To know more about this just check table TO15Z which actually converts numbers into words.

Thanks,

Vinay

Re: SPELL_AMOUNT

Former Member — Thu, 14 Sep 2006 11:38:33 GMT

u can use...

data: words(50) type c.
 
call function 'HR_IN_CHG_INR_WRDS'
     exporting
          amt_in_num   = '100000'
     importing
          amt_in_words = words.
 
 
write:/ words.

Re: SPELL_AMOUNT

Former Member — Thu, 14 Sep 2006 11:38:49 GMT

Hi,

Have a look at the documentation for the function module for a clear understanding of its usage and limitations.

Regards

Re: SPELL_AMOUNT

Former Member — Thu, 14 Sep 2006 11:41:35 GMT

maximum is 23 and 2 dcimal places , execute RF_SPELL program , and check the amount length