Comma problem

[Former Member]

Hi,

I have few values in a ALV report which is getting populated

9,00000.00

or 9.00000,00

But i need to display it like 9 00 000.00

Can anybody suggest me a procedure for that, i am using the field wrbtr from table ekbe.

-

---

Khan

[Former Member]

Hi,

1.set the settings in SYSTEM->user profile->own data.

Regards,

Shiva

[Former Member]

You can create a 2nd field for display and use this code

DATA: amount TYPE p DECIMALS 2 VALUE '900000.00'.
DATA: amount2(11) TYPE c.

WRITE amount TO amount2 USING EDIT MASK '_ __ ___.__'.

WRITE:/ amount2.

There is also an EDIT MASK field in the field catalog you can likely use. I don't have an example of that however.

[Former Member]

Change the user settings.

Go to SU01 and change the parameters.

Regards,

Madan.

[Former Member]

change your user settings ...

System>user profile>own data

in defaults tab .. change the decimal notation accordingly ...

[Former Member]

Hi,

For this u've the change the decimal notaion in the user profile default settings.

Try this way....

system->User Profile->Own Data, in this change to Defaults tab and change the Decimal notaion format to ur required format.

Reward accordingly,

Chandra

[Former Member]

hi to display like that use this:

your field value amount = 900000,00 .

data: char(30) type c.

write: amount to char

now use this field to display in ALV.

it will solve your problem.

reaward if useful.

[Former Member]

Hi guys,

This doesnt help, can u suggest me something else,

whenever i am using the edit mask option or the number to charater format i am not getting the desired out put,

look the current values are 9.000,00

1.000,00

7.000,00.

And my requirement is the dot that is coming in the second position should not come there. it should be like.

9 000,00.