Fields on ECC ABAP report triggering action

[Former Member]

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!

[Former Member]

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

[raymond_giuseppi]

Why would BW team ask ECC Abap team for this, they already have the Reporting Agent with its  Exceptions Management ?

Regards,

Raymond

[Former Member]

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.

[Former Member]

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.