About decimal notation

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

Hi,

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

3.300 * 1000 = 3,300.

[Former Member]

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