topic Re: sq01-default value in Application Development and Automation Discussions

sq01-default value

Former Member — Tue, 26 Sep 2006 07:56:32 GMT

hi,

I have created a query in sq01.I would like to make the selet-option as parameter and assign it sy-datum value as default on selection screen. Is it possible???

Re: sq01-default value

anversha_s — Tue, 26 Sep 2006 08:00:07 GMT

hi,

check this sample code...

tables: mkpf.

data date like sy-datum.

data date1 like sy-datum.

select-options: s_date for mkpf-budat.

initialization.

CALL FUNCTION 'HR_JP_MONTH_BEGIN_END_DATE'

EXPORTING

iv_date = sy-datum

IMPORTING

EV_MONTH_BEGIN_DATE = date

EV_MONTH_END_DATE = date1

s_date-option = 'EQ'.

s_date-sign = 'I'.

s_date-low = date.

s_date-high = date1.

append s_date.

so automattically,

low - 1st day of month.

high - last day of month.

chnge accoding to ur requirement.

rgds

anver

if helped mark points

Re: sq01-default value

Former Member — Tue, 26 Sep 2006 08:00:25 GMT

open sq01

enter query name in rite area.

go to infoset query.

now u just see the right side window where all the select option come.

thee in option for giving it value in 3rd tab just put the value here.

Re: sq01-default value

Former Member — Tue, 26 Sep 2006 08:02:29 GMT

its taking a value.but i need it to be sy-datum so that everytime it changes according to current date. this is my requirement.is it possible.

Re: sq01-default value

Former Member — Tue, 26 Sep 2006 08:11:29 GMT

i don't think it is possible with that..

but u can make dynamic variant for dat field.

Re: sq01-default value

Former Member — Tue, 26 Sep 2006 08:24:55 GMT

Could you tell me how to do it.

Thanks

Re: sq01-default value

Former Member — Tue, 26 Sep 2006 09:00:38 GMT

sorry for late reply..

1st go to infoset query.

goto--->variant mantinance for tamplate.

Enter the values in the selection screen

2. Save the variant using the SAVE button

3. In the next screen for the date variable select the 'Selection variable' checkbox (L) and click on the button 'Selection variable' in the toolbar.

4. Now you will see this variable in the next screen with 3 types of buttons. Click on the middle button (ie. D - Dynamic date calculation).

5. Click on the down arrow button and select the option 'Current Date'.

6. Save the variant.

noq go to sq01 and run the query.

Kindly assign points if this is helpful.