Skip to Content

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

Custom query for all WH instock < min inventory level by item


Before I run the schedule alert by displaying the min inventory level by item on specific WH.

But now I wish to run the query if the sum of the (sum of all WH).onhand < oitm.minlevel.

Can anyone please help.


Former Member

Hi Olga,

Please try below query and revert back.

Select A.ItemCode, A.ItemName, A.MinLevel, A.Onhand

from OITM A

Where A.MinLevel > A.Onhand



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