Exception Reporting Alerts - BI Mentors pls. help

[Former Member]

Hi,

I am seeking expert idea in this scenario.

We have an exception report which lists the passports that will expire in next 30 days. This alert need to be sent as an email to that particular SAP user. How to create this ?

The challenging part is that the email recipient is not fixed but will keep changing. It depends on the people whose passport will expire.

It will be great if I get a soution for my scenario.

Thanks.

[Former Member]

Greetings Vaishali-

Depending on your exact needs, you should be able to incorporate one of the following into an ABAP routine that is flexible enough to handle the variable recipient list:

1- <b>SO_NEW_DOCUMENT_ATT_SEND_API1</b> (delivered with BI)

This is a highly configurable function module that can even send attachments via Email

2- For a "quick-n-dirty", you can write your own ABAP that incorporates the UNIX "send

email" function, e.g., <b>CALL 'SYSTEM' ID 'COMMAND' FIELD email.</b> where This

requires a little fine-tuning (text massaging, etc) but it works. I have a sample program that I could share if you are interested. There are many example via Google as well.

Good luck!

-Stefan