Convert String to Currency

[Former Member]

Hi Experts,

I read from text file to an internal table.

My text file contains data (eg. 1,799.01).

When i try to store into internal table, i couldn't do so cos the string cant store the value as currency (internal table field is currency).

How do i do so?

I tried removing ',' and the condense the string no gaps such that data becomes 1799.01 but still the internal table does not accept the string (as i'm forcing it to store into a currency).

Please help!

[Former Member]

Hi Experts,

I read from text file to an internal table.

My text file contains data (eg. 1,799.01).

When i try to store into internal table, i couldn't do so cos the string cant store the value as currency (internal table field is currency).

How do i do so?

I tried removing ',' and the condense the string no gaps such that data becomes 1799.01 but still the internal table does not accept the string (as i'm forcing it to store into a currency).

Please help!

[Former Member]

no need to store , in internal table but while output just make change in field catelog with datatype = 'CURR' .

[Former Member]

Hi

Have u tried using Currency format with Write Statement ..

Write field( from file) TO varaible(defined by you) Currency CURR(like JPY etc) .

This will wite string as per the currency format given by you .

Hope this may help.

Praveen

[former_member386202]

Hi,

Change the datatype of internal table field as character type.

Regards,

Prashant