cancel
Showing results for 
Search instead for 
Did you mean: 

number separator on table view - how to change from 0,00 to 0.00?

Former Member
0 Kudos

Hi,

I have some fields in a table view. one of them is Type P decimals 2.

I get the output like 0,00 and not 0.00.

the problem is that I want to display the second format and not the first and I have no idea how to set it up.

also, when I try reading the values from the screen into the table again (I am working on stateless mode simple BSP) then I get a conversion dump since this is not a number like.

Thanks,

Itay

Accepted Solutions (0)

Answers (2)

Answers (2)

raja_thangamani
Active Contributor
0 Kudos

CHeck out this..String to Decimal...

data: s type string.
data: p type p decimals 2.
 
s = '1,765,654.25'.
 
call function 'HRCM_STRING_TO_AMOUNT_CONVERT'
     exporting
          string              = s
          decimal_separator   = '.'
          thousands_separator = ','
     importing
          betrg               = p
     exceptions
          convert_error       = 1
          others              = 2.

Raja T

Former Member
0 Kudos

Hi Raja,

this function will do the trick but also a simple REPLACE.

but for this I will have to look on the field type and start doing manipulations.

I prefer to refrain from doing that. simple is best.

per my other note, it will be best to find where the defaults for the SU05 internet user are stored.

Thanks.

BTW,

you are doing on hell of a good job in the forum!

I really appreciate your contribution.

Itay

raja_thangamani
Active Contributor
0 Kudos

If i am not wrong..YOu can create the User name alias via SU01 for internet user( I read somewhere..)...If you can do then you can mention the Default parameters via SU01.

And one more thing, Internet users can be created via SU01 also..

Hope this will help you...

But you can't expect all the user to have the settings..So i would suggest you to handle thro the program to avoid the Dumps..

<i>* Reward each useful answer</i>

Raja T

Message was edited by:

Raja Thangamani

Former Member
0 Kudos

of course Internet users can be created via SU01 but then you have to pay license fee for them. Doesn't it miss the whole point of using interent users?

raja_thangamani
Active Contributor
0 Kudos

What i feel, It doesnt matter whether you create the Internet user via SU01 or SU05..so u may need not to pay for license.Lets see if somebody coming with more answer...

Raja T

Former Member
0 Kudos

I found it.

it was taking the user formats of the general user who was maintained in SICF.

stupid not to look at that place.

I didn't do this initially so I didn't think to look at that place.

raja_thangamani
Active Contributor
0 Kudos

I think, you user profile needs to be changed..

Goto menu system>user profile>own data--> Default tab...THere it might be defined as 1,23 format..change the format in user profile & check..

Raja T

Former Member
0 Kudos

Thanks.

I know that the definitions are in the user profiles but what I forgot to mention is:

I am using an internet user (transaction SU05) user type KNA1.

That user does not have a SU01 profile thus I have no idea where it is taking the definitions from. I guess there is some default in SAP... somewhere...