Dynamic date selection in the report executing background and send mail to user

In this Document , I would like explain about Dynamic Date selection in the back ground executing report and  send mail to user periodically.

Requirement ; Client Requirement, Need report result of the every day GR posting materials with stock and value with material document number and vendor.

We can find Material Document list and GR qty with value in MB51.

Step 1 : Create Distribution list in SO23, to create Private distribute lists and Shared distribution lists.

I created one distribution list like shared distribution list for assigning mail id to shared distribution list. You can see how to create distribution list in below link.I am not going deeply this, my target on dynamic selection date in background. You can find in below link for detail distribution list.

http://scn.sap.com/docs/DOC-44263

Step 2 :Create variant for input selection

For Dynamic selection date in background the creation of variant is important step. See below screen shots.

To create variant just enter your input details in selection screen and click on save button.

enter your Variant name and Description

I need dynamic selection in  the field Posting date , Select the “D” type of selection Variable

We  have option number of variable names :

we can select the name of variable as per the client requirement

The below are the name of variables

Current Date

From month start to today

Current date +/- ??? days

current date +/- ??? work days

First day of current month

nth working day of current month

First day of next month

First day of previous month

Last day of previous month

Last Day of the Current Month

Once entered the details, you save the variant.

Once completed the input selection, you start execute the background job .

you can see  in below link, how to do scheduled job and assignment of distribution list in Sm37

http://scn.sap.com/docs/DOC-44263

Once run  the Job you will get mail every day with dynamic posting date as a system date.

You received the mail with report results. You can generate any report like this way dynamic selection date.

Hope Its help ful to all.

We are always welcome to all for any suggestions……..