topic Re: currency amount data problem in Application Development and Automation Discussions

currency amount data problem

Former Member — Thu, 03 May 2007 13:05:22 GMT

Hi All,

In FB03 to create a document if the amount is given with 5 decimal places this data stores in PAYR table wrongly coz the field PAYR-RWBTR is of curr 13 and 2 decimal places.

In my program when i fetch data from PAYR as this data is wrong we are getting wrong output. Is there any conversion routine avaliable to convert this to correct 2 decimal places?

Example:

Amount entered in FB03 is 1000.120000 - US5 currency

but in table it is showing - 1000120.00

thanks,

Anil.

Re: currency amount data problem

Former Member — Thu, 03 May 2007 13:07:11 GMT

Hi Anil,

Use the WRITE TO using the CURRY key option of the WRITE statement. It will automatically adjust the values according to the currency key of the table.

Hoep this helps.

Cheers

Re: currency amount data problem

Former Member — Thu, 03 May 2007 13:31:19 GMT

Hi,

Try this below code

DATA: val TYPE string .

val = amount.

REPLACE ',' WITH space INTO val.

REPLACE '$' WITH space INTO val.

CONDENSE val.

WRITE val DECIMALS 2 TO amount.

Regards