05-29-2006 4:16 PM
Hi,
I need tp print the value in AMOUNT field in one of my report in words.
How do i proceed for that?
Regards
Nishant
05-29-2006 4:17 PM
05-29-2006 4:17 PM
05-29-2006 4:19 PM
CALL FUNCTION 'SPELL_AMOUNT'
EXPORTING
LANGUAGE = SY-LANGU
CURRENCY = T001-WAERS
AMOUNT = SUM_UBKNT
FILLER = SPACE
IMPORTING
IN_WORDS = SPELL
EXCEPTIONS
NOT_FOUND = 1
TOO_LARGE = 2.
Please award points if found helpful
05-29-2006 4:25 PM
Hi,
Use this function Module
HR_IN_CHG_INR_WRDS
and pass AMT_IN_NUM = numeric Vale
it will Return
AMT_IN_WORDS = Amount in words
mark Helpfull answers
Regards
05-29-2006 4:26 PM
05-29-2006 4:28 PM
Hi nishant,
check this sample code:
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.
regards,
keerthi.
05-29-2006 6:15 PM
Hi Nishanth,
Use FM SPELL AMOUNT...
CALL FUNCTION <b>'SPELL_AMOUNT'</b>
EXPORTING
AMOUNT = PAMOUNT
CURRENCY = PWAERS
FILLER = SPACE
LANGUAGE = 'E'
IMPORTING
IN_WORDS = T_SPELL
EXCEPTIONS
NOT_FOUND = 1
TOO_LARGE = 2
OTHERS = 3.
Check this Link for the same
http://www.sap-img.com/fu001.htm
Regards,
Santosh
05-30-2006 6:06 AM
Hi Nishant,
Check this FM 'HRCM_AMOUNT_TO_STRING_CONVERT' it might be useful for u
cheers
ganesh
05-30-2006 6:51 AM
tables : t001.
parameter amt type t001-waers .
Data inwords like spell value is initial.
CALL FUNCTION 'SPELL_AMOUNT'
EXPORTING
AMOUNT = amt
CURRENCY = sy-waers
FILLER = space
LANGUAGE = SY-LANGU
IMPORTING
IN_WORDS = inwords
EXCEPTIONS
NOT_FOUND = 1
TOO_LARGE = 2
OTHERS = 3
.
05-30-2006 7:01 AM
Hi Nishant,
For amount in Millions n thousands, use FM SPELL_AMOUNT.
for Indian style(Crores,lakhs), use FM HR_IN_CHG_INR_WRDS
hope it helps,
Regards,
Bikash