function module

[Former Member]

Hi,

Which function module can we use for

1. to convert Numberic value to Value in words say Amount 100.9 -in words one hundred & paise nine only

2. to convert exchange rate automatically based on obo8 setting

say usd to inr

Edited by: Aspirant sd SD on Oct 21, 2008 12:41 PM

[Former Member]

Try with spell_amout.

[Former Member]

Hello,

I think we dont have any functional module but we can write the progam by checking the each digit in the program using case statement.

[Former Member]

SPELL_AMOUNT - Convert numbers and figures in words

READ_EXCHANGE_RATE - Translation of Currency Amounts etc.

[Former Member]

Hello,

you can use this FM SPELL_AMOUNT

Inputs:

AMOUNT 1,437.00

CURRENCY INR

LANGUAGE EN

Output:

000000000001437 000 2 ONE THOUSAND FOUR HUNDRED THIRTY-SEVEN

[Former Member]

HI,

THX FOR REPLYIN.

Can you pl tel me how to execute this function module directly which tcode to use

[Former Member]

SE37

[Former Member]

hi,

se37 -fun module SPELL_AMOUNT

AMOUNT 999.19

CURRENCY INR

FILLER

LANGUAGE EN

it shows NINE HUNDRED NINETY-NINE

1 Paise is not coming as nineteen paise only

2 what is FILLER OPTION

[Former Member]

Hi,

Use HR_IN_CHG_INR_WRDS

Regards

Debarshi

[Former Member]

HI,

i want to know in tcode J1iin which function module is used for exchange rate conversion

which picks tate from ob08 setting

pl suggest

[Former Member]

Hi,

Try /NFM/CURRENCY_CONVERT or CMS_API_CURR_CONV

[Former Member]

hi,

thx for replyin

CMS_API_CURR_CONV i checked by usd to inr i tried it picks same rate for all dates

thought exchange rate is different 0.02500

i'm looking for fun module used in tcode J1IIN which picks from OB08 RATE SETTING

PL SUGGEST

[Former Member]

Hi,

In J1iin they are using fm CONVERT_TO_LOCAL_CURRENCY

call function 'CONVERT_TO_LOCAL_CURRENCY'
  EXPORTING
    date             = j1ii300-pdate
    foreign_amount   = excitm-nccd
    foreign_currency = j1ii300-waerk
    local_currency   = j1ii300-waers
    rate             = excitm-kursk
    type_of_rate     = j_1iindcus-j_1iexpexcg
  IMPORTING
    local_amount     = excitm-nccd
  EXCEPTIONS
    no_rate_found    = 1
    overflow         = 2
    no_factors_found = 3
    no_spread_found  = 4
    others           = 5.

Please check it and say.....

Regards

Debarshi

[Former Member]

Hello

1 Paise is not coming as nineteen paise only
2 what is FILLER OPTION

1. Return table have fields: word and decword.

2. Filler - it is a symbol which is filled initial place.

P.s. Look at report RF_SPELL.

[naveen_inuganti2]

Hi...

Sample code:1

call function 'SPELL_AMOUNT'
      exporting
        language = sy-langu
        currency = <pass currrency like USD>
        amount   = <Input Amount>
      importing
        in_words = spell(type spell)
    write spell-word to amount(char300).

Here you will get output into amount.if it is not currency field say percentage or quanity dont pass the currency parameter.

Thanks,

Naveen.I

[bpawanchand]

Hi

Use SPELL_AMOUNT Fm to convert numeric into words

Use CALCULATE_EXCHANGE_RATE For second

[Former Member]

Hi,

Amount is represented in different ways in different countries. For example, the amount 100000 is read as one hundred thousand in some countries and one lakh in countries like India .

This tip details about printing the amount in words for Indian Currency. We can use the function module HR_IN_CHG_INR_WRDS in this regard.