Skip to Content

Hi,

This is common requirement getting from client. I want to share this to all. I hope for freshers and users it is helpful;

Requirement : GR value and qty , IR value and qty and balances can be viewed on purchasing organization basis using the T Code: MB5S. User requirement is need results for this report automatically through mail to HOD every day.

Means every day for this report results need to send automatically mail with out executing manually.

The below are steps for achieving this requirement.

Step 1: create Distribution lists in SO23

/wp-content/uploads/2013/07/1_249278.png

Click on create button.

Enter name and title

click on f4 functionality in place of folder.

/wp-content/uploads/2013/07/3_249279.png

click on create folder

/wp-content/uploads/2013/07/4_249280.png

enter folder and name and click on enter

/wp-content/uploads/2013/07/5_249281.png

click on enter

click on Distr.list content tab

/wp-content/uploads/2013/07/6_249282.png

enter your mail id in place of recipient and Recip. type

/wp-content/uploads/2013/07/7_249283.png

Here three boxes is there , purpose of these is

1) Send Express :


If you select this field, this document is sent to the recipient as an express message. A dialog box then appears informing the user that an express document has been sent, allowing him/her to switch to the inbox.

2) Send Copy :

If you select this field, the user receives the document as a copy. This means the user receives the document for his/her information and does not need to take any action.

3) Send : blind copy :

If this field is selected, the recipient receives the document as a blind copy.

Save.

/wp-content/uploads/2013/07/8_249297.png

Step 2:  Execute Report with your requirement

T-code : MB5S

enter data in selection screen

/wp-content/uploads/2013/07/9_249298.png

Save as variant.

/wp-content/uploads/2013/07/10_249299.png


save

go to menu –> Program—>execute in back ground

/wp-content/uploads/2013/07/11_249300.png

/wp-content/uploads/2013/07/12_249301.png

/wp-content/uploads/2013/07/13_249302.png

click on date/time

select schedule start

/wp-content/uploads/2013/07/14_249303.png

and click on Period Values

Here you can select period values like hourly ,daily, weekly, monthly , other period means you can select job start  like every minitiues

/wp-content/uploads/2013/07/16_249304.png

Here i selected every 5 minutes i need  report results .

click on save.

/wp-content/uploads/2013/07/17_249305.png

Go to T- code SM37 :

enter Job name : * and execute

/wp-content/uploads/2013/07/18_249306.png

After five minutes you refresh the screen

/wp-content/uploads/2013/07/19_249309.png

/wp-content/uploads/2013/07/19_249309.png

/wp-content/uploads/2013/07/20_249308.png

It shows activity finished and it will show spool in the field of spool.

go to menu —> JOB —->chnage

/wp-content/uploads/2013/07/21_249310.png

/wp-content/uploads/2013/07/22_249311.png

click on spool list recipient

/wp-content/uploads/2013/07/23_249312.png

/wp-content/uploads/2013/07/24_249314.png

click on detail search

/wp-content/uploads/2013/07/25_249315.png

and enter and click on copy

click on F4 on recipient

/wp-content/uploads/2013/07/26_249316.png

and click on f5

/wp-content/uploads/2013/07/27_249323.png

save

You will get mail after five minutes with results of report.

/wp-content/uploads/2013/07/28_249324.png

/wp-content/uploads/2013/07/30_249326.png

Hope its helpful to all.

To report this post you need to login first.

38 Comments

You must be Logged on to comment or reply to a post.

  1. NIREESH PH

    Hi,

    Thanks, very useful information…

    I have tried this for one of our customized (Z-report) report and is not working.

    Whether this will work only for standard SAP reports?

    Regards

    Nireesh

    (0) 
    1. Ravindra Devarapalli Post author

      First check whether back ground job is working for your customized report. If it is working in up to SM37 then it will work for mail triggering also.

      Check in SCOT, for object name INT, mail host and mail port is assigned currectly or not.

      (0) 
  2. Rashid Imam

    Very useful document.

    I am setting up same for my client, but unable to send same in excel format, can u please guide me how to send same in excel format.

    Regards

    Rashid

    (0) 
  3. Mark Ezekiel Torio

    Thanks to this article, i know my question was not relate to this page, but ill take my chance on the last screenshot the report already send to your email, now my question was how did you group the report? is that layout in SQVI? hoping for your answer or if there’s any link let me it would a great help for me thanks

    (0) 
  4. Gaurav Solanki

    Hi,

    Its a great document and well defined by you.But I am facing a problem that mail is not going at external mail id while I followed same step as you mentioned.

    Thanks

    Regards

    Gaurav Solanki

    (0) 

Leave a Reply