topic Re: Table for currency in Application Development and Automation Discussions

Table for currency

Former Member — Mon, 09 Jan 2006 08:20:48 GMT

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.

Re: Table for currency

abdul_hakim — Mon, 09 Jan 2006 08:23:34 GMT

CHECK THE TABLE TCURX..

ABDUL

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:26:21 GMT

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

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:27:33 GMT

Table name is T015Z. Reward points if it helped.

Ankur Bhandari

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:28:43 GMT

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

Thanks & regards

sreenivasareddy

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:30:37 GMT

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

Ankur Bhandari

Re: Table for currency

jayanthi_jayaraman — Mon, 09 Jan 2006 08:30:46 GMT

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.

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:33:52 GMT

Hi thanks for the response

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

Thanks& regards

sreenivasareddy

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:35:46 GMT

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

Ankur Bhandari

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:36:03 GMT

Hi,

Use Function module HR_IN_CHG_INR_WRDS.

This will definitely work.

Please acknowledge.

Regards,

Bikash

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:38:28 GMT

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

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:44:35 GMT

Hi sreenivasa,

1. HR_IN_CHG_INR_WRDS

Try the above FM.

It will give description till RUPEES & PAISE.

regards,

amit m.

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:46:52 GMT

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.

Re: Table for currency

Former Member — Mon, 09 Jan 2006 08:59:31 GMT

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

Re: Table for currency

Former Member — Mon, 09 Jan 2006 10:02:03 GMT

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

Re: Table for currency

Former Member — Mon, 09 Jan 2006 11:08:27 GMT

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

Re: Table for currency

suresh_datti — Mon, 09 Jan 2006 11:13:28 GMT

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