07-13-2013 3:54 PM
I looked a little on the forums for this topic, but I'm not sure what area it really even fits in. We have ECC and BI at my installation, and I mostly know the ECC side. The BI/BW group has asked me if it's possible (and if so, what tools/processes I would use) to have an ECC ABAP report that triggers action (like sending an e-mail) only if report fields pass a certain threshold, or perhaps contain a certain value.
Can someone point me in the right direction if this is possible in ECC/ABAP and what resources / links to investigate further. Obviously, if you have an example ABAP program, that would help me a lot too. I'm just trying to figure out how easy/possible. I've written lots of ABAP, but I don't have experience with this idea of triggering e-mails or taking action only based on certain values.
Please let me know.
Thanks!
07-15-2013 8:31 AM
Hi Jeremy,
Design a normal report program to trigger the mail based on the value or threshold.
Schedule this program as a batch program with very less time interval.
I hope it will help you to solve your problem.
Thanks and Regards,
Vinay
07-15-2013 8:31 AM
Hi Jeremy,
Design a normal report program to trigger the mail based on the value or threshold.
Schedule this program as a batch program with very less time interval.
I hope it will help you to solve your problem.
Thanks and Regards,
Vinay
07-15-2013 9:10 AM
Why would BW team ask ECC Abap team for this, they already have the Reporting Agent with its Exceptions Management ?
Regards,
Raymond
07-15-2013 2:00 PM
We have some business clients in the organization that would like to have an e-mail or some kind of notification pertaining to the following:
(1) "For example, if an account orders more than $50,000 in product a report is sent to us with what they purchased, maybe the same thing at the SKU level, if we sell 2000 of a product a report could be sent out. This could even be done at the weekly level, if an account does more weekly sales than any account has ever done " ... (2) "Events would be even more awesome with real time data. A report could be sent out if a huge order was just placed, or we topped our daily/weekly sales record. Some sort of notification in the moment that could be analyzed ..."
So, the idea/request seems 2-fold: (1) trigger an e-mail/notification based on some near-time analytic/historical values and (2) do something similar based on real-time info (at order-create, for instance). I think BI/BW has a handle on the 1st scenario, and is asking me about the 2nd in ECC, b/c it is real-time.
07-16-2013 4:15 PM
Thank you for the replies, and confirming my thoughts regarding this. I'm going to close this, since our BI/BW team decided to put the whole thing on the back-burner for awhile.