topic Re: function module in Application Development and Automation Discussions

function module

Former Member — Tue, 21 Oct 2008 10:41:32 GMT

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

Re: function module

Former Member — Tue, 21 Oct 2008 10:42:21 GMT

Try with spell_amout.

Re: function module

Former Member — Tue, 21 Oct 2008 10:46:42 GMT

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.

Re: function module

Former Member — Tue, 21 Oct 2008 10:51:53 GMT

SPELL_AMOUNT - Convert numbers and figures in words

READ_EXCHANGE_RATE - Translation of Currency Amounts etc.

Re: function module

Former Member — Tue, 21 Oct 2008 10:52:33 GMT

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

Re: function module

naveen_inuganti2 — Tue, 21 Oct 2008 10:53:38 GMT

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

Re: function module

bpawanchand — Tue, 21 Oct 2008 10:54:53 GMT

Use SPELL_AMOUNT Fm to convert numeric into words

Use CALCULATE_EXCHANGE_RATE For second

Re: function module

Former Member — Tue, 21 Oct 2008 11:20:28 GMT

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.

Re: function module

Former Member — Wed, 22 Oct 2008 06:04:42 GMT

HI,

THX FOR REPLYIN.

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

Re: function module

Former Member — Wed, 22 Oct 2008 06:05:38 GMT

SE37

Re: function module

Former Member — Wed, 22 Oct 2008 06:09:52 GMT

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

Re: function module

Former Member — Wed, 22 Oct 2008 06:12:54 GMT

Hi,

Use HR_IN_CHG_INR_WRDS

Regards

Debarshi

Re: function module

Former Member — Wed, 22 Oct 2008 06:14:42 GMT

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

Re: function module

Former Member — Wed, 22 Oct 2008 06:26:29 GMT

Hi,

Try /NFM/CURRENCY_CONVERT or CMS_API_CURR_CONV

Re: function module

Former Member — Wed, 22 Oct 2008 09:43:34 GMT

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

Re: function module

Former Member — Wed, 22 Oct 2008 10:03:47 GMT

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

Re: function module

Former Member — Wed, 22 Oct 2008 10:03:50 GMT

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.