Skip to Content
Author's profile photo Ravindra Devarapalli

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.

Untitled1.png

Untitled2.png

Enter variable name and Description.

Untitled3.png

Untitled4.png

Untitled5.png

In posting date row select selection variable as a “D” – current date.

Untitled6.png

select name of variable select current date .

Untitled7.png

Untitled8.png

Untitled9.png

Untitled10.png

Save. So variable created .

Go to SM36 – enter your program name as job name.

Untitled11.png

To find program name from MB51 go to menu bar system—>status

Untitled12.png

copy the program name and copied into SM36 in place of job name.

Untitled13.png

Untitled19.png

enter and enter details of name (program name) and variant (saved in MB51)

Untitled14.png

save and enter , come initial screen SM36 .

Untitled15.png

click on spool list recipient , Hope every one know how to distribution list. ( see previous post)

Untitled16.png

click on start condition in initial screen SM36

Untitled17.png

enter time periods here

Untitled18.png

click on immediately and after that click on period button .

Untitled.png

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.

Untitled1.png

Untitled3.png

Untitled2.png

So we received every day on time  report results to mail  .

Hope it is helpful to All.…………

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Super !!!

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      nice document !!!

      Author's profile photo Former Member
      Former Member

      Hi

      good work

      Author's profile photo Former Member
      Former Member

      Excellent work

      Author's profile photo Former Member
      Former Member

      Awesome document

      Author's profile photo Former Member
      Former Member

      hi, this is very useful! thank you

      Author's profile photo Narayana N
      Narayana N

      Hi Ravindra Devarapalli,

      Nice document. Thank you.

      Regards,

      Narayana Nagaraju

      Author's profile photo Rashmin Rao
      Rashmin Rao

      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!