cancel
Showing results for 
Search instead for 
Did you mean: 

Save data with more than 6 decimal places in SAP MDM 5.5

Former Member
0 Kudos

Hi there,

I need some help concerning saving data with about 20 decimal places (e.g. 0,00452961328622164) in MDM. I declared the datatyp "REAL", there are only 6 decimal places possible.

How can I save this Data? Maybe exponential function?

Please help.

Thank you

Thomas Pfab

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

solved in BI...

Former Member
0 Kudos

currency takes you to 14 decimal places, if you want to have it as a little work around....you can always take out that symbol if it is annoying.(ohhh and decimal is multilingual too in currency, probably not a good hack!)

or without even knwoing what your requirement is? try normalizing the value, How many more decimal places can you hit?

One 100 1. "ten to the zero"

tenth 10-1 0.1 "ten to the minus one"

hundredth 10-2 0.01. "ten to the minus two"

thousandth 10-3 0.001. "ten to the minus three"

ten thousand 10-4 0.0001. "ten to the minus four"

hundred thousandth 10-5 0.00001. "ten to the minus five"

millionth 10-6 0.000001 "ten to the minus six"

ten millionth 10-7 0.0000001. "ten to the minus seven"

hundred millionth 10-8 0.00000001. "ten to the minus eight"

billionth 10-9 0.000000001. "ten to the minus nine"

ten billionth 10-10 0.0000000001. "ten to the minus ten"

hundred billionth 10-11 0.00000000001. "ten to the minus eleven"

trillionth 10-12 0.000000000001 "ten to the minus twelve"

ten trillionth 10-13 0.0000000000001. "ten to the minus thirteen"

hundred trillionth 10-14 0.00000000000001. "ten to the minus fourteen"

and put that field label indicating the 10th power. Like "Accuracy in 10 POW -9"

Just a wild guess.well thats how we usually show data in catalogues too!

(or)

separate the integer and decimal portions into two fields and store it in the repository.(split on ',')

-Sudhir.

Former Member
0 Kudos

Hi,

thanks for your reply!

My requirements are to save "exchange water factors" for BI. They will need it for some following calculations.

Hence it is important that it will be exported in the right way. You can save data as exponetialfunction but in the export MDM cuts the value on 6 decimal places.

So we will save the data directly in BI...

Thanks for your help!

Best regards

Thomas