Q
Problem solve Get help with specific problems with your technologies, process and projects.

Dots or commas as decimal-separators

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.
update USR01
set USR01.DCPFM='X'
where MANDT='200' and BNAME='MYUSER'
go

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.


This was last published in June 2001

Dig Deeper on SAP Basis administration and NetWeaver administration

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close