Solved: Email Infoset Query Result

Former Member · ‎05-19-2006

Is anyone aware of a way to email the results of a infoset query run on R/3 . Would like to schedule the query to run then have it emailed out automatically.

Any help at all will be rewarded with points

Thanks

Richard

RichHeilman · ‎05-19-2006

Sure, schedule it in SM36. There is a button on the first screen called Spool List Recipients. Put the email address there or a distribution list . The output will then be emailed to these addresses. Of course SAPconnect must be setup/configured.

Regards,

Rich Heilman

RichHeilman · ‎05-19-2006

Sure, schedule it in SM36. There is a button on the first screen called Spool List Recipients. Put the email address there or a distribution list . The output will then be emailed to these addresses. Of course SAPconnect must be setup/configured.

Regards,

Rich Heilman

Former Member · ‎05-19-2006

That sounds perfect. When you schedule in SM36 is it the Query name or a program name ?

RichHeilman · ‎05-19-2006

It will be the program name. You can get the report name by going to SQ01, select the query name, click Query, More Functions, Display Report Name.

Regards,

Rich Heilman

suresh_datti · ‎05-19-2006

You can try this..Write a custom Program that runs the query using SUBMIT <query> to SAP-SPOOL and RETURN. Retrieve the spool using the function module 'RSPO_RETURN_SPOOLJOB' & email it using another function 'SO_NEW_DOCUMENT_ATT_SEND_API1'.

Regards,

Suresh Datti

I like Rich's suggestion

Message was edited by: Suresh Datti