topic Re: Variant for a Report in Application Development and Automation Discussions

Variant for a Report

Former Member — Fri, 13 Mar 2009 10:14:03 GMT

Hello..

I have a report which has date as select option..

This report executes both in foreground and in background...

In foreground it runs for the date the user enters...

In background I want it should run for the current system date..The report will be scheduled daily at 11 pm. so each day it should take the current date as its input ...

How is this possible???

Re: Variant for a Report

Sandeep_Panghal — Fri, 13 Mar 2009 10:17:28 GMT

At initialization.

p_date = sy-datum.

start-of-selection.

check sy-batch value and proceed.

Re: Variant for a Report

Former Member — Fri, 13 Mar 2009 10:18:21 GMT

Set the the default date in selection screen by using Default Sy-datum.

Re: Variant for a Report

Former Member — Fri, 13 Mar 2009 10:18:42 GMT

USe this piece of code:

INITIALIZATION.

if sy-batch = 'X'.

s_date-low = sy-datum.

endif.

Cheers

Ravish

Re: Variant for a Report

Former Member — Fri, 13 Mar 2009 10:19:02 GMT

Just change the program where u used the select-options, there set the default value as sy-datum.

then if u run the report in background then it will take the current date.


SELECT-OPTIONS: date FOR sy-datum DEFAULT sy-datum.

Re: Variant for a Report

I355602 — Fri, 13 Mar 2009 10:20:31 GMT

Hi,

Set the default value of date field as current date. Use INITIALIZATION event


SELECT-OPTIONS : s_datum FOR sy-datum.

INITIALIZATION.
  IF sy-batch = 'X'.
    s_datum-low = sy-datum.
  ENDIF.

Hope this helps you.

Regards,

Tarun

Re: Variant for a Report

sreeramkumar_madisetty — Fri, 13 Mar 2009 10:20:42 GMT

At Initialization section,you can set the selection-screen date field as you required and validate the same using sy-batch for background processing and else for foreground processing.

Regards,

Sreeram Kumar Madisetty

Re: Variant for a Report

Former Member — Fri, 13 Mar 2009 10:20:55 GMT

Hi,

If you are using SAP 4.7 versions, while saving the variant:

Give the variant name and description.

Then for the date variable , in the field attributes, click check box Selection variable. Then press selection variables button. Press Dynamic date calculation (Traffic light for D column will turn green).

Then click the list box, and select Current date.

Save the variant.

Best Regards,

Suresh

Re: Variant for a Report

Former Member — Fri, 13 Mar 2009 10:25:51 GMT

Hi..Thanx...Ur answer solved my Problem....

Re: Variant for a Report

Former Member — Fri, 13 Mar 2009 10:27:10 GMT

Hi All...

All the answers were of gr8 help...I got two solutions to my problem..

Thank u all...

Re: Variant for a Report

Former Member — Fri, 13 Mar 2009 10:27:49 GMT

Hi,

If you are using SAP 4.7 versions, while saving the variant:

Give the variant name and description.

Click the check box, only for background processing.

Then click the list box, and select Current date.

Save the variant.

If it is ECC 6.0,

Click the check box, only for background processing.

Then in the selection variable column for the DATE field, There will be an F4 help. Select D - Dynamic date calculation.

Then in name of variable (Input only using F4 column), press F4 and choose 'Current date'.

This is an easy solution by using Variants. There is no need to change your code, if you use this method.

Best Regards,

Suresh