topic Re: Selection Screen Dymnamic varient in Application Development and Automation Discussions

Selection Screen Dymnamic varient

Former Member — Wed, 19 Aug 2009 14:42:19 GMT

I have a Date field as my selection Options. I need to save a variant where my date would between the first and the last day of the previos month.

When i check the selection varibable check Box for the date and click the selection variable button it takes me to a different screen and and i have selected dynamic date calculation.

In the drop down i see first day of the first month and its gets selected but I can select both the first day and the last day. It works as a parameter, but i want it as a select-options.

Any suggestions.

Bob

Re: Selection Screen Dymnamic varient

former_member194669 — Wed, 19 Aug 2009 15:09:13 GMT

You have 2 options

1. Use table TVARVC for setting the variant values (The transactions STVARV and STVARVC are available for maintaining the table variants) then use that entries while creating dynamic date variant

2. If your report is custom one, then in the INITIALIAZATION event , set the date default values


initialization.
call function OIL_LAST_DAY_OF_PREVIOUS_MONTH  " Find the last month end date and first date 

s_datum-low = <last month first date>
s_datum-high = <last month end date>
s_datum-sign = 'I'
s_datum-options = 'EQ'.
append s_datum

a®

Re: Selection Screen Dymnamic varient

Former Member — Wed, 19 Aug 2009 15:29:05 GMT

Thanks ARS,

I would do that but how come this valus in the table will be changed for every month. DO i have to write for an updation of this and run on the last day of every month..

Bob

Re: Selection Screen Dymnamic varient

former_member194669 — Wed, 19 Aug 2009 15:38:28 GMT

May be you need to check this

I find this will help you out.

a®