Skip to Content

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

Golden Link Arrow on Query Alerts

Hello Experts,

     i tried add  link arrow on Sales order Document No. And Delivery Document No. I can Put Link Arrow on Delivery Document No but I can't Put On Sales Order Document No. If I pull up the query in the query manager it has several golden arrows but when the alert comes up and it's clicked on there is no golden arrow.

SELECT T1.[DocEntry] As [Delivery No], T0.[DocEntry] As [Sales No],T1.[DocNum],T0.[Quantity], T2.[Quantity] FROM  ODLN T1 INNER JOIN DLN1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN RDR1 T0 ON T2.[BaseRef] = T0.[DocEntry] WHERE T0.[TrgetEntry]= T1.[DocNum] and T0.[Quantity] < > T2.[Quantity] FOR BROWSE

Thanx & Regards
Harshit

replied

Hi,

1. Try:

SELECT T1.[DocNum], T1.[DocEntry] As [Delivery No], t3.docnum,T0.[DocEntry] As [Sales No],T0.[Quantity], T2.[Quantity]

FROM  ODLN T1 INNER JOIN DLN1 T2 ON T1.DocEntry = T2.DocEntry INNER JOIN RDR1 T0 ON T2.[BaseRef] = T0.[DocEntry] inner join ORDR T3 on T3.docentry = T0.docentry

WHERE T0.[TrgetEntry]= T1.[DocNum] and T0.[Quantity] < > T2.[Quantity] FOR BROWSE

2. It is not possible to get sales order document link arrow in alert. Only first document no in the query  will be displayed alert message.

Thanks & Regards,

Nagarajan

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