Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Rounding in Query Generator

Hey guys,

I'm quite stumped by this one. SAP is making rounding decisions on calculated fields in the query I have no control over. SAP is set to round quantities to 4 decimals. However, if I run this query, column 1 is rounded to 4 decimals, column 2 is rounded to 2 decimals!

SELECT T0.[Quantity], T0.Quantity*1 FROM INV1 T0

How do I get column 2 to round to 4 decimals just like column 1?

Thanks,

Kevin

Former Member
replied

You can try to convert it to text:

SELECT T0.[Quantity], str(T0.Quantity*1,19,4) FROM INV1 T0

(But the result will be left justified.)

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question