topic Re: Comma problem in Application Development and Automation Discussions

Comma problem

Former Member — Wed, 07 May 2008 11:51:23 GMT

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

Re: Comma problem

Former Member — Wed, 07 May 2008 11:55:40 GMT

Hi,

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

Regards,

Shiva

Re: Comma problem

Former Member — Wed, 07 May 2008 11:56:46 GMT

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.

Re: Comma problem

Former Member — Wed, 07 May 2008 11:58:17 GMT

Change the user settings.

Go to SU01 and change the parameters.

Regards,

Madan.

Re: Comma problem

Former Member — Wed, 07 May 2008 11:59:41 GMT

change your user settings ...

System~~>user profile~~>own data

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

Re: Comma problem

Former Member — Wed, 07 May 2008 12:00:29 GMT

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

Re: Comma problem

Former Member — Wed, 07 May 2008 13:22:16 GMT

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.

Re: Comma problem

Former Member — Thu, 08 May 2008 05:16:48 GMT

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.