How to send email daily to all the vendors which have Past Due POs.

[Former Member]

Hi

In BI BEx Query Designer, i have created 1 report showing all the POs which are Past Dues.

My requirement is:

I want to send email daily to all the associated vendors which have Past Due POs (POs which are not being received yet after their due dates). And don't want to send email to vendor which doesn't have any Past Due PO.

Could anyone suggest me how to achieve it.

Thanks

[Former Member · Accepted solution]

Hi

I don't think so it is possible to send like that, since in your report you will have mutilple vendors who's PO's due. If a you a report for each vendor level then you send email to vendors using broadcasting feature.

Thanks

Raghu

[Former Member · Accepted solution]

Hi Raghu,

Yes i understand that, but trying to find if i could get some clue on this.

Thanks.

[Former Member]

Hi Harpal,

Heres what you can do. Now that your query is ready, use this query in an APD and in that APD include a ABAP routine process type.

In this code you will loop through the query results and whichever matches your desired condition for them e-mail can be sent through some standard function module.

Regards,

Amit

[Former Member]

Hi Amit

I am scheduling ABAP program and having loop around "SO_NEW_DOCUMENT_SEND_API1" function module for each vendor to send email to vendors.

Thanks.

Edited by: Harpal Singh on Sep 8, 2010 4:18 PM