Currency

[former_member564866]

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

[former_member564866]

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.

[Former Member]

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

[Former Member]

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

[former_member564866]

Hi

Give me one example.

Thank

siva

[amit_khare]

USE FM CONVERT_TO_LOCAL_CURRENCY

[Former Member]

Hi

use the command

SET COUNTRY 'IN'

and display this cuurency field and see

it will display in indian format

Regards

Anji

[Former Member]

<b>use this CONVERT_TO_LOCAL_CURRENCY to convert into Local

and CONVERT_TO_FOREIGN_CURRENCY to convert to Foreign</b>

[Former Member]

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.

[former_member564866]

Hi

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

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

Thank

siva

[Former Member]

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.