cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hi,

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.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

former_member212181
Active Contributor
0 Kudos

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

Thanks

Unnikrishnan

Former Member
0 Kudos

Hi,

It works !

Thanks, I didn't notice OITM has onhand field.

Thank you

Former Member
0 Kudos

Hi,

Can you help me on this issue?

http://scn.sap.com/thread/3746845

Regarding the min level inventory as well.

Thanls

Answers (0)