I'm the Basis Guy in my company. We are Spanish company. We have SAP configured for spanish people, but a lot of users ask me if they can use "." of the numeric keypad like "," for separating decimals without update theirs master profiles using SU3. It is possible?
I like this type of questions!
The decimal notation is controlled in table USR01 field DCPFM. When the field value is 'X' then the dot (.) is used.
Knowing this, you can either issue an update query at the database level or you can write an ABAP program to make the changes in the entire R/3 system.
-- The following query lists all user accounts in client 200. select * from USR01 where MANDT='200'
-- The following query changes the decimal notation to "." for the user MYUSER in client 200.
where MANDT='200' and BNAME='MYUSER'
You can ommit the "and BNAME=XXX" and change the field in the whole client. If you ommit the client, then you change the field for all clients in the system.
Notice that you will need to stop and re-start the R/3 instance for the change to actually work. The change in the field takes effect immediately but it seems to be buffered so the user does not get the change until you bounce the R/3 instance.
Dig Deeper on SAP Basis
Related Q&A from Giovanni Davila
Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila. Continue Reading
Learn fundamentals of transport management and STMS from Basis guru Giovanni Davila in this expert tip. Continue Reading
Giovanni Davila, Basis expert, provides advice on how to copy all SAP users from one system to another in this tip. Continue Reading