Skip to Content

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

Alert based on Batch Expiration Date


Batch Managed Items

Type: for every transaction

Goods receipt PO > Batch setup window > "Expiration date" ( activate expiration date field from form settings) > set date


An alert to be sent to the purchase dept. user 10 days prior to the defined "expiration date" (in the batch setup window)


Edited by: SU Vijay on Oct 6, 2008 3:42 PM

Former Member
Former Member replied

Use this query

SELECT T0.[ItemCode], T0.[ItemName],T0.[BatchNum], T0.[WhsCode], 
T0.[ExpDate],datediff(dd,getdate(),T0.[ExpDate]) as 'Days to Expire' 
FROM OIBT T0  where datediff(dd,getdate(),T0.[ExpDate]) =10

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