topic Re: table in Application Development and Automation Discussions

table

Former Member — Wed, 04 Oct 2006 10:52:26 GMT

any table is available for cuurency details

ex : inr -

Rupees and paise

USD -

Dollers and cents

like that..

Re: table

Former Member — Wed, 04 Oct 2006 10:53:19 GMT

Please check

TCURC

TCURT

Re: table

anversha_s — Wed, 04 Oct 2006 10:54:32 GMT

hi,

Currency : TCURC

rgds

anver

pls mark hlpful answrs

Re: table

Former Member — Wed, 04 Oct 2006 10:54:44 GMT

check the table TCURC

and the field is WAERS.

Regards

Srikanth

Re: table

Former Member — Wed, 04 Oct 2006 10:55:10 GMT

hi Vijay,

try table

TCURC

Regards,

Preema

*Reward points for helpful answers

Re: table

Former Member — Wed, 04 Oct 2006 10:55:48 GMT

Hello Vijay,

U can make use of TCURC & TCURT.

If useful reward.

Vasanth

Re: table

Former Member — Wed, 04 Oct 2006 10:56:38 GMT

Hi Vijay,

Try table T500w. It contains currency per country and the valid date from and to.

Regards.

Re: table

Former Member — Wed, 04 Oct 2006 10:57:10 GMT

Hi,

If your looking for the text check table

<b>TCURT</b>

Regards,

Re: table

Former Member — Wed, 04 Oct 2006 10:58:15 GMT

Hi vijay,

<b>In TCURC

The fields waers is the code and LTEXT or KTEXT will give you the description for the code</b>

PLZ check...

REgards,

Ajith

MArk if useful

Re: table

Former Member — Wed, 04 Oct 2006 11:05:03 GMT

thanx all.

in these tables it is giving the details of rupees/dinar

etc. but they r not providing the details regarding paise..

Re: table

Former Member — Wed, 04 Oct 2006 11:14:01 GMT

i think, decimal related is not maintained in SAP.

as per the country it will be converted .

lets say 100.10 INR

means 100 rupees and .1 rupee.

in INDIA, it will be calculated how much a rupee for its paise like that.

Correct me,if i am wrong.

here is the small code about SPELL_AMOUNT function module, here we can give the curr field also

REPORT YTEST no standard page heading .

data : tline like tline occurs 0 with header line,
SPELL LIKE SPELL OCCURS 0 WITH HEADER LINE.

data amouno type p DECIMALS 5 value '5455555.65461'.

CALL FUNCTION 'SPELL_AMOUNT'
EXPORTING
AMOUNT = amouno
<b>CURRENCY = 'USD'</b>
* FILLER = ' '
LANGUAGE = SY-LANGU
IMPORTING
IN_WORDS = SPELL
EXCEPTIONS
NOT_FOUND = 1
TOO_LARGE = 2
OTHERS = 3
.

WRITE : / 'Amount in Number: ',AMOUNO.

WRITE : / 'Amount in Word: ',SPELL-WORD, 'AND DECIMALS' , SPELL-DECWORD.

Regards

Srikanth

Message was edited by: Srikanth Kidambi

Re: table

Former Member — Wed, 04 Oct 2006 11:21:03 GMT

hai srikanth

i have to print the amount according to the country specifec in words

if i use spell_amount it will give in US format.

if i use HR_IN_CHG_INR_WRDS it is giving in indian format because in this FM they r hard coded according to india..

but i need to print the amount of hongkong and ......

so how to fetch them.

Re: table

amit_khare — Wed, 04 Oct 2006 11:28:22 GMT

Hi Vijay,

did you try FM SPELL_AMOUNT with language change.

it uses language component to change to words.

Hope this help you.

Regards,

Amit

You also have to check that do your system is configured for that language check it out in T002 table.

there you will get the language key for ll the stored values in your system.

Also by default that FM uses EN therefore you should pick the right one.

Message was edited by: Amit Khare

Re: table

Former Member — Wed, 27 Apr 2011 12:23:12 GMT

This message was moderated.