Skip to Content

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

Alert Management

I want to set alert management,When we create purchase document at least minmum quantity should be in 100 .

Former Member
Former Member replied

You can create an alert based on user query like:

SELECT DISTINCT T1.DocNum FROM POR1 t0
INNER JOIN OPOR T1 on T1.DocEntry = T0.DocEntry
WHERE T0.Quantity < 100 AND 
DATEDIFF(DD,T1.CREATEDATE,GETDATE()) = 0

You can select this new query by clicking on Open Saved Query button to bring up Query Manager and assign to your new alert.

Thanks,

Gordon

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