topic Re: About decimal notation in Application Development and Automation Discussions

About decimal notation

Former Member — Wed, 29 Oct 2008 12:47:26 GMT

I have report which outputs the quantity field from mara. the quantity for a material in mara shows as 3,300 KG ( 3 kg 300 grms) . but the select from mara in the report fetches it as 3.300 . Instead of comma it is showing as dot.

The user profile setting is also correct which 12.334,000.

Please let me know which things we need to check.

Thanks,

Kishore

Re: About decimal notation

Former Member — Wed, 29 Oct 2008 13:18:20 GMT

Hi,

The select will always fetch is as 3.300 because in databse it is stored like this. You can't change it. If you want to convert it to your user setting, write this to another variable of type c.


Write : <QUANTITY> to <C Type variable>.

Regards,

Rudra

Re: About decimal notation

Former Member — Wed, 29 Oct 2008 13:24:19 GMT

Hi,

Also check if you want it to convert it from Grams to KG.

3.300 * 1000 = 3,300.

Re: About decimal notation

Former Member — Wed, 29 Oct 2008 13:33:45 GMT

Hi Kishore,

Its better to declare a character variable and assign that value into the character variable.

Example

DATA: V_AMT(10) TYPE C.

V_AMT = VAL. " Where VAL = 3.300

WRITE: V_AMT.

It will show the output as 3.300.

Thanks,

Chidanand