topic Re: Fields on ECC ABAP report triggering action in Application Development and Automation Discussions

Fields on ECC ABAP report triggering action

Former Member — Sat, 13 Jul 2013 14:54:05 GMT

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!

Re: Fields on ECC ABAP report triggering action

Former Member — Mon, 15 Jul 2013 07:31:48 GMT

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

Re: Fields on ECC ABAP report triggering action

RaymondGiuseppi — Mon, 15 Jul 2013 08:10:26 GMT

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

Regards,

Raymond

Re: Fields on ECC ABAP report triggering action

Former Member — Mon, 15 Jul 2013 13:00:42 GMT

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.

Re: Fields on ECC ABAP report triggering action

Former Member — Tue, 16 Jul 2013 15:15:40 GMT

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.