Skip to Content

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



In the Sales Opportunites i have 5 stages.

1. Lead

2. Design

3. Manufacturing

4. Marketing

5. Quotation

As soon as new enquiry come i will enter the details in the sales opportunities module. In the Stage tab, i will enter the 1st stage as Lead. When i enter the second stage i need to send the alert message to design department user.


I need to send only the new lead number which i have entered. And when i have changed from "Design" to other stage. Alert message should not come to "Design department". For the i have used the below query.

SELECT T0.[OpprId], T0.[Line], T0.[SlpCode], T0.[Step_Id] FROM OPR1 T0 where Step_Id = 2 and OpprId = (select max(OpprId) FROM OPR1)

But when i used this query if i change the stage of the lead from "Design" to other, still alert message is forwarding to "Design" department.

Helpful Answer

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