Rounding in Query Generator
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?