Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Select price with more than two decimals

Go to solution
former_member355261
Participant

‎01-26-2017 11:05 AM

0 Kudos

Hello everyone,

I'm trying to get the Moving price (verpr) from the MBEW table. And I want it with 6 decimals but it's stored only with two decimals.

So with a Select query I'm only able to get it with two decimals and not more.

For example, the value 20,41 is actually 20,409562 (it's up rounded)

We can figure this out through standard transactions such as MB52

I don't know if there is any FMs or other tables to use in order to achieve this requirement.

Please help me solve this problem.

Thanks in advance

Regards

1 ACCEPTED SOLUTION

Go to solution
raymond_giuseppi
Active Contributor

‎01-26-2017 12:06 PM

0 Kudos

Divide LBKUM by SALK3 yourself, amounts are rounded to currency number of decimals.

Regards,
Raymond

1 REPLY 1

Go to solution
raymond_giuseppi
Active Contributor

‎01-26-2017 12:06 PM

0 Kudos

Divide LBKUM by SALK3 yourself, amounts are rounded to currency number of decimals.

Regards,
Raymond