Skip to Content

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

Alert based on Batch Expiration Date

Scenario:

Batch Managed Items

Type: for every transaction

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

Requirement:

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

vijay

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

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