Configure Number Format and save Number larger than 12 digits

[Former Member]

Dear SAP Experts,

I have two Questions:

1.   1.  About Number format

Usually, Number format is: 1,000,000.000

That means:

+Thousand Seperator is: “,”

+Decimal Places is “.”

I need to configure the Number format as: 1.000.000,000

That means:

+Thousand Seperator is: “.”

+Decimal Places is “,”

How can I configure Number Format everywhere (Interactive Planning Table…) in SCM as above.

2.   2. How to configure to save number larger than 12 digits

Currently with Key figure, when input number, system doesnot allow to save number less than or equal 12 digits. When I input a number more than 12 figure value, like 9999999999999 (13 digits), system show messages:

“Value of key figure KF1 in period 05.07.2012 - 05.07.2012 too large”

Dianogsis:

“A key figure value is larger than the maximum permitted twelve figure value of 999999999999 in at least one bucket of the data view.”

As I know, in Database, system can store a much larger values.

How can I configure save number greater than 12 digits

Thanks very much for your support!

Duyennx

[Former Member · Accepted solution]

Hi Duyennx,

The number format is set when the user is first created in the system.  Note 636647 has a bit of information on this.  You can have each user maintain their own default settings for date and time with transaction SU0 or System -> User Profile -> Own Data -> Defaults.  I don't know how to do a mass change of users.  Maybe another expert can address this.

liveCache stores numbers in 15.3 format.  That means 12 digits to the left of the decimal place.  You can't have larger numbers.

Best Regards,

Mike

[Former Member · Accepted solution]

Dear Mike and SAP Gurus,

I followed System -> User Profile -> Own Data -> Defaults

My default Number format settings is: 1.234.567,89

However in Interactive Planning Table, data still is: 384,683,512

What is wrong here?

Moreover, content of NOTE "636647" is not relate to our case:

"Symptom

During the posting by means of Transaction FEBAN text 'NEW_FEBA:110' is displayed in the status bar, which is incorrect."

Thanks very much for your supports!

Duyennx

[Former Member · Accepted solution]

Hi Duyennx,

I suggest you open a customer message with SAP.

Best Regards,

Mike

[Former Member · Accepted solution]

Dear Mike,

Thanks very much for your guides.

I am now waiting for response from SAP.

Best Regards,

Duyennx