topic Re: Currency in Application Development and Automation Discussions

Currency

former_member564866 — Wed, 17 Oct 2007 08:49:23 GMT

Hi All

My amount Field Contains the value 1234567890.12

I Should display in INDIAN RUPEE FROMAT (1,23,45,67,890.12)

Thanks

siva

Re: Currency

Former Member — Wed, 17 Oct 2007 08:51:22 GMT

Hi,

Refer to the following code:

write int_final-hwbas to int_exl_pca-hwbas currency int_final-hwaer.

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: Currency

Former Member — Wed, 17 Oct 2007 08:52:52 GMT

move it to charecter field with decimals 2 extension...automatically commas will be generated......

Re: Currency

amit_khare — Wed, 17 Oct 2007 08:52:59 GMT

USE FM CONVERT_TO_LOCAL_CURRENCY

Re: Currency

Former Member — Wed, 17 Oct 2007 08:54:41 GMT

use the command

SET COUNTRY 'IN'

and display this cuurency field and see

it will display in indian format

Regards

Anji

Re: Currency

Former Member — Wed, 17 Oct 2007 08:55:45 GMT

<b>use this CONVERT_TO_LOCAL_CURRENCY to convert into Local

and CONVERT_TO_FOREIGN_CURRENCY to convert to Foreign</b>

Re: Currency

Former Member — Wed, 17 Oct 2007 09:01:45 GMT

Please try following EXAMPLE CODE


DATA:  DMBTR  LIKE BSIS-DMBTR,
       WAERS LIKE BSIS-WAERS.

DMBTR  = 1234567890.12.
WAERS = 'INR'.                    "FOR Indian Rupee

WRITE:  DMBTR CURRENCY WAERS.

Hope this will helps.

Re: Currency

former_member564866 — Wed, 17 Oct 2007 09:02:42 GMT

Give me one example.

Thank

siva

Re: Currency

former_member564866 — Wed, 17 Oct 2007 09:27:20 GMT

That example code will display like this 12345,678,901.2

But i want 1,23,45,67,890.12

Thank

siva

Re: Currency

Former Member — Wed, 17 Oct 2007 09:56:46 GMT

Dear siva kumar,

You can try on following code to get all currency format and try to select one of the type listed.(All country currency will be listed.) But I afraid that the format you want is not Indian Rupee.

If still could not find the desired format, probably you have to code it using string.


TABLES: TCURC.
DATA:  DMBTR  LIKE BSIS-DMBTR,
       WAERS LIKE BSIS-WAERS,
       IT_TCURC LIKE TABLE OF TCURC.

DMBTR  = '1234567890.12'.

SELECT * FROM TCURC INTO TABLE IT_TCURC.
LOOP AT TCURC.
  WAERS = TCURC-WAERS.
  WRITE: / WAERS, DMBTR CURRENCY WAERS.
ENDLOOP.