Skip to Content

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

Stock Quantity With Decimals

Hi All,

I have noted that we've got some stock items whose Quantity include Decimals yet they are suppossed to be whole numbers.

For instance: for Bread: OITM.OnHand=10.5

I want to come up with a query to display all these kind of items. Whats the right Condition in an SQL query to achieve this? Thanks

Regards,

Henry

Former Member
Former Member replied

Try this query:

Select itemcode, itemname from OITM where Onhand > Round(Onhand,0)

Thanks,

Gordon

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question