Using Variant, how to send mail automatically to user on peridically with results
Hi,
I would like to share document on topic : how to run back ground job for report by using Variant.
Client always asking requirements like EOD need information of How many Purchase orders created and inward stock and goods issues stock to branch and list of production orders on current date and confirmation qty of order on current date etc……..
I have taken one example: client Need information GR qty happend on current date through mail.
I created one Variant in MB51, considered posting date as a dynamic selection like current date.
T-code : MB51
enter required details and click on save button.
Enter variable name and Description.
In posting date row select selection variable as a “D” – current date.
select name of variable select current date .
Save. So variable created .
Go to SM36 – enter your program name as job name.
To find program name from MB51 go to menu bar system—>status
copy the program name and copied into SM36 in place of job name.
enter and enter details of name (program name) and variant (saved in MB51)
save and enter , come initial screen SM36 .
click on spool list recipient , Hope every one know how to distribution list. ( see previous post)
click on start condition in initial screen SM36
enter time periods here
click on immediately and after that click on period button .
select as per your requirement daily or any period values you can enter.
Save.
Once complete the assignment of periods and other things start date and time. save the changes.
Go to SM37 t- code check your job, whether it is released or not after reaching your start time.
check mail, you received the result of report with respect variant.
So we received every day on time report results to mail .
Hope it is helpful to All.…………
Super !!!
nice document !!!
Hi
good work
Excellent work
Awesome document
hi, this is very useful! thank you
Hi Ravindra Devarapalli,
Nice document. Thank you.
Regards,
Narayana Nagaraju
Great work! I was actually searching if we can set the mail attachment format to MS-Excel. But looks like it will need some ABAP work. still your efforts are appreciated! keep it up!