Table for currency

[Former Member]

Hi all

Do we have any table for decimal currency.

For example when the currency is in 'Rupees'then the decimal currency should be "Paise'.i need this one when i write a amount in words.

For example for the amount Rs:235.65

two hundred thirty five Rupees sixty five Paise.

[abdul_hakim]

CHECK THE TABLE TCURX..

ABDUL

[Former Member]

What you want to do can be easily done using function module SPELL_AMOUNT.

This can be tested using standard report RF_SPELL.

Reward points if it helped.

Ankur bhandari

Message was edited by: Ankur Bhandari

[Former Member]

Table name is T015Z. Reward points if it helped.

Ankur Bhandari

[Former Member]

Hi thanks for your response but it is giving the number of decimal places not the decimal currency.

Thanks & regards

sreenivasareddy

[Former Member]

Did you use the function module SPELL_AMOUNT ? The example is illustrated in program RF_SPELL.

Ankur Bhandari

[Former Member]

Hi thanks for the response

'SPELL_AMOUNT'will give amount in words only . it will not mention any thing about currency.

Thanks& regards

sreenivasareddy

[Former Member]

You have to pass the currency as one of the parameters to this function module.What is your objective ?

Ankur Bhandari

[Former Member]

Hi 'T015Z' will give Digits and numbers in words.not related to currency

[Former Member]

Hi sreenivasa,

1. HR_IN_CHG_INR_WRDS

Try the above FM.

It will give description till RUPEES & PAISE.

regards,

amit m.

[jayanthi_jayaraman]

Hi,

TCURC is the table for currency code.

Just try using where-used-list to go and search further.Kindly reward points by clicking the star on the left of reply,if it helps.

[Former Member]

Hi,

Use Function module HR_IN_CHG_INR_WRDS.

This will definitely work.

Please acknowledge.

Regards,

Bikash

[Former Member]

Hi Thanks for the reply. It is giving amount in words as well as currency and decimal currency. but we don't option to give currency it is directly giving in Rupees and Paise.i need it for different currencies.

[Former Member]

Hi Sreenivasa,

To my knowledge there is no FM or any function that serves ur criteria. What u can do is code according to ur requirement. ie put a case statement :

when 'INR'.

curr1 = 'rupees'. curr2 = 'Paise'.

when 'USD'.

Curr1 = 'Dollars' . Curr2 = 'Cents'...

etc.

and then while writing the amount in ur Script u can put these 2 variables in between.

Hope it helps.

Regards,

Bikash

[Former Member]

Hi Bikash thanks for the suggestion,

but how many cases will we take, bacause we don't know what are the currencies they use.it depends on the vendors place.Instead we can do one thing. we can create a Z-table taking the KEY as word currency, based on that we can get the decimal currency. before to do that i want to confirm whether we have any table or 'FUNCTION MODULE' for this.

Thanks & regards

sreenivas

[Former Member]

Hi Srinivas,

I think what you should do is based on the vendor's company code or country code, pick up the currency and then using this currency you can use all the FM described by others. Both T001 an dT005 will have currency aginst them.

Using this will give you the words to the last penny/paise depening on the CUKEY

Hope this helps

[suresh_datti]

Hi,

I couldn't trace it.. but the very same issue has been discussed on this forum earlier.. Your conclusion is right.. there is no delivered function module and you will be better off maintaining a Z table for the decimal currency.

Regards,

Suresh Datti