Skip to Content
0
Jun 16, 2016 at 05:40 PM

Decimal Notation issue while comparing the values in Select query

816 Views

Hello Gurus,

I am working on Material Pricing user exit. I have the Gauge value in MARA table as 2,000(US Notation) and also I am having Custom table in that there are 2 fields as Gauge From and Gauge To with values 1,000 and 3,000. Initially am fetching the Gauge value from Material Master data and comparing that Gauge value in Custom table between Gauge From and Gauge To and I need to pass the Condition Type to pricing table, Here select query is failing due to decimal notation which I have observed in Run time.

In run time the Gauge value is taking as 2.000(UK Notation). The Data type for the Gauge value in MARA is DEC and Gauge From and Gauge To is also DEC.

I have searched in SCN and I came to know about Translate, Replace with etc., as per my understanding these will work for Characters or strings.

How can I resolve this issue. Kindly help me on this issue.

Thanks and Regards,

Muralikrishna Peravali.