Does anyone know if it is possible to create a batch schedule to run a standard report (KSB1), with many Report Variants, each variant being user specific. Once run these individual reports need to distributed to the relevant users in HTML format by e-mail.
Can this be automated? Any help or suggestions will be appreciated
You can schedule a job using SM36. In the step, enter the program name for KSB1 (which is RKAEP000). Create a variant for each user you want it sent. You can set the spool recipient in SM36 as email address. However, since you want it in HTML mode, it may not work.
My suggestion is to write a custom program that read the spools, then call function module WWW_HTML_FROM_LISTOBJECT to convert the spool to HTML, then call function module SO_NEW_DOCUMENT_ATT_SEND_API1 to email it to an email address.