topic Re: doubt in spell_amount? in Application Development and Automation Discussions

doubt in spell_amount?

Former Member — Mon, 09 Jul 2007 12:46:23 GMT

hi all

how to use the function module spell_amount..what should i export and import?

CALL FUNCTION 'SPELL_AMOUNT'

EXPORTING

AMOUNT = ?

CURRENCY = ?

FILLER = ' '

LANGUAGE = SY-LANGU

IMPORTING

IN_WORDS = ?

EXCEPTIONS
NOT_FOUND = 1
TOO_LARGE = 2
OTHERS = 3

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Re: doubt in spell_amount?

Former Member — Mon, 09 Jul 2007 12:47:52 GMT

Hi..,

This spell_amount function module gives the amount (that u have entered) in words,,,,

if u give the amount as 50,320.00

and currency INR

language EN

then the importing parameter contains the text ...

Fifty Thousand Three hundred and twenty rupees.

regards,

sai ramesh

Re: doubt in spell_amount?

Former Member — Mon, 09 Jul 2007 12:48:27 GMT

Export parameters are the amount, has to be written in words, and the currency, in import parameter you'll have the amount in words.

Try this:

TABLES SPELL.

PARAMETERS: P_AMOUNT LIKE BSEG-WRBTR,
            P_WAERS  LIKE T001-WAERS.


CALL FUNCTION 'SPELL_AMOUNT'
     EXPORTING
          AMOUNT    = P_AMOUNT
          CURRENCY  = P_WAERS
          LANGUAGE  = SY-LANGU
     IMPORTING
          IN_WORDS  = SPELL
     EXCEPTIONS
          NOT_FOUND = 1
          TOO_LARGE = 2
          OTHERS    = 3.

IF SY-SUBRC <> 0.
  MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
  WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.


WRITE: 'Integer part:', SPELL-WORD,
       'Decimal part:', SPELL-DECWORD.

Max

Re: doubt in spell_amount?

Former Member — Mon, 09 Jul 2007 12:49:11 GMT

check the program RF_SPELL

Re: doubt in spell_amount?

Former Member — Tue, 07 Aug 2007 01:51:55 GMT

SPELL_AMOUNT is a function that return an amount in words. The exporting parameters are amount (in numbers), currency (currency of wanted country) and filler (character wanted to out).

The IMPORTING parameter is in_words (a structure filled with the amount in words).

I did learn this yesterday...

It's a simple explanation... I hope this has helped you...

Alexis Sanchez

ABAP Trainee

Valencia, Venezuela

Re: doubt in spell_amount?

Former Member — Tue, 07 Aug 2007 01:58:17 GMT

Re: doubt in spell_amount?

Former Member — Tue, 07 Aug 2007 02:40:27 GMT

hi Asha

try this

call function 'SPELL_AMOUNT'

exporting

amount = w_amount

importing

in_words = w_text

exceptions

not_found = 1

too_large = 2

others = 3

there w_amount should be like SPELL-NUMBER

and w_text should be type SPELL

data : w_amount like SPELL-NUMBER

data : w_text type SPELL

Rewards If Useful.

Re: doubt in spell_amount?

Former Member — Tue, 07 Aug 2007 07:34:48 GMT

but if i try like this no output is displayed.....

cheers

asha

Re: doubt in spell_amount?

Former Member — Tue, 07 Aug 2007 07:38:52 GMT

WHAT IS THE CASE DEAR....

Re: doubt in spell_amount?

Former Member — Wed, 08 Aug 2007 18:54:26 GMT

Hi...

Try this...

DATA: p_amnt like spell-number, " Amount in numbers (input)

p_words type spell. " Amount in text (output)

p_amnt = 150000.

CALL FUNCTION 'SPELL_AMOUNT'

EXPORTING

AMOUNT = p_amnt

CURRENCY = 'VEB'

FILLER = '*' " It's the character to fill blanks

LANGUAGE = SY-LANGU

IMPORTING

IN_WORDS = p_word " It's amount in words

EXCEPTIONS

NOT_FOUND = 1

TOO_LARGE = 2

OTHERS = 3

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

¡¡¡WARNING!!!

The two last digits are the decimal part.

>>>> The output for ES languaje is MIL QUINIENTOS**************************

>>>> The output for EN languaje is ONE THOUSAND FIVE HUNDRED***************

Good luck

Alexis Sanchez
ABAP Trainee
Valencia, Venezuela