topic Re: Dyanamic Date Selection in variants in Application Development and Automation Discussions

Dyanamic Date Selection in variants

arpit_shah — Mon, 31 Dec 2007 10:03:40 GMT

Hi....

In select-options i have declared one field for Posting Date.

my requirement is

in TO : Today - 1.

based on that FROM : start of month date

for that what i hv to change in variant.

I hv select for date selection variable as D and

Name of Variable : what i hv to choose.

or how can add my new formula in that.

Regards,

Arpit

Re: Dyanamic Date Selection in variants

Former Member — Mon, 31 Dec 2007 10:12:54 GMT

Hi,

try this code.

initialization.

d-high = sy-datum - '1'.

concatenate sy-datum0+(6) '01' into d-low.

append d.

Re: Dyanamic Date Selection in variants

arpit_shah — Mon, 31 Dec 2007 10:24:33 GMT

hi..will smith

is it possible to change by dynamic date calculation by variant??........

bcoz i m calling this report from other report using submit keyword and pass the variant name.

so i want to calculate from variant only..

for this what to do?...

Regards,

Arpit

Re: Dyanamic Date Selection in variants

Former Member — Mon, 31 Dec 2007 12:58:20 GMT

Hi,

yes it is possible,

please see the link from the online help:

[http://help.sap.com/saphelp_nw70/helpdata/en/c0/98039be58611d194cc00a0c94260a5/frameset.htm]

Kindly regards,

STefan

Re: Dyanamic Date Selection in variants

arpit_shah — Tue, 01 Jan 2008 05:02:14 GMT

hi..Stefan

but my requirement is in

To : Today - 1.

From : Current month Start date....

In that how to configure.

pls advise.

Re: Dyanamic Date Selection in variants

Former Member — Tue, 01 Jan 2008 05:22:02 GMT

Hi,

check the above link carefully it has the answer.

Re: Dyanamic Date Selection in variants

arpit_shah — Tue, 01 Jan 2008 06:08:18 GMT

but in that my requirement is not fulfill.

in there option of

current month date of start to today.

but i want in to TODAY - 1.

for that i cant get.

If i want to add my variant in that then what to do?.....

Re: Dyanamic Date Selection in variants

Former Member — Tue, 01 Jan 2008 10:50:40 GMT

Hi Arpit,

you are right - I thought it is possible without trying it,

Sorry!

You described that you call the report from an other report using SUBMIT statement-

Could you calculate the range of the date in first report and use this for the SUBMIT command?

Also there have to be a check, that the "today - 1" is not lower then the "current month start".

Today it would be 01.01.2008 to 31.12.2007 ... and this would be an error.

By the way: Happy new year!

Kindly Regards,

Stefan

Re: Dyanamic Date Selection in variants

arpit_shah — Tue, 01 Jan 2008 11:50:41 GMT

hi....stefan

thanks for your reply..

is it possible if i passed variant name for other selection and for date i am pass through program?

becoz the selection is not fixed so due to the selection criteria i m passing with variant and date pass with program?

so it is possible?........

Re: Dyanamic Date Selection in variants

Former Member — Tue, 01 Jan 2008 12:56:31 GMT

Hi Arpit,

yes this is possible ... and this time i tried it out before i post..

I used this little testreport:

...

DATA: lt_range_date TYPE RANGE OF d,

ls_range_date LIKE LINE OF lt_range_date.

ls_range_date-sign = 'E'.

ls_range_date-option = 'BT'.

ls_range_date-low = '20071201'.

ls_range_date-high = '20071212'.

APPEND ls_range_date TO lt_range_date.

SUBMIT zdatetest USING SELECTION-SET 'TEST'

WITH s_date IN lt_range_date.

...

It's calling a testreport zdatetest which has two parameters and a variant TEST.

One parameter was set by the variante and the other for the date-selection was set from the lt_range_date.

Stefan