Function module to convert the value into Currency type (As per domain )

[sagar_ranasingh]

Hi ,

i hav used domain WERTV6 , ( Data type CURR , Length 11 Decimal places 2 ) .

i want when data comes to my internal table, it should be formatted as per this domain type,

Is there any Function Module to convert the data .

For ex . if data comes as 1123.234 , system gives error as Input should be in the form ___,___,__~.__V .

please throw some idea ?

Thanks

Edited by: sagar singh on May 12, 2011 6:52 PM

[Former Member]

I dont think if the data type is CURR, it will be stored with the formatting options. You can store

with formatting in a CHAR type. Also how are you getting the error.

Thanks,

Aravind

[sagar_ranasingh]

Hi,

I have also maintained the reference field as RV13A - KONWA .

but still if i give an input "14,214" , the error shows as Unable to interpret "14,214 " as a number. ??

Any suggestion, except removing the occurrence of ',' and then condense the value .

[sagar_ranasingh]

Hi,

Though i solved the issue by declaring a CHAR data type and REPLACE ALL OCCURRENCES OF statement .

But still not able to understand the issue, why its behaving like this,

If i enter data manually in Table , its accepting the values (Did not find any conversion exit defined for that Domain - WERTV6 .)

But if i upload the data from excel sheet and update , that time it's showing error Unable to interpret "14,214 " as a number.

Error analysis - : *The program attempted to interpret the value "14,214 " as a number, but

since the value contravenes the rules for correct number formats,

this was not possible.*

[Former Member]

Hi,

RV13A-KONWA is type which has length 5. it dont have decimal places so it cant interprete comma or dot.

declaring as char will solve problem

[sagar_ranasingh]

This is the CURRENCY KEY field, ---Rate unit (currency or percentage)

what it has to do with the decimal point or comma "," value .??

Didnot get your point ??

[sagar_ranasingh]

solved the issue