Skip to Content

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

Alert for Delivery

Hi All,

I am using the below mentioned query which is assigned to generate alert to employee after addition of delivery. This alert works fine.

My requirement is: when alert is open in Inbox by user their is an column for attachment i want to provide link to user to access the PLD for delivery.

Solution will be appreciable.

SELECT T0.[CardName], T0.[DocDate], T1.[ItemCode], T1.[Dscription],

T1.[Quantity] FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry

Where DateDiff (dd, T0.DocDate,Getdate())=0

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