Skip to Content
-1

Select price with more than two decimals

Jan 26, 2017 at 11:05 AM

32

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Raymond Giuseppi
Jan 26, 2017 at 12:06 PM
0

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

Regards,
Raymond

Share
10 |10000 characters needed characters left characters exceeded