topic Re: Select Option in Application Development and Automation Discussions

Select Option

Former Member — Fri, 22 Sep 2006 13:23:15 GMT

In select-options, how to get the default values as current month first date and last date by default?

Eg: 1/12/2004 and 31/12/2004

Thanks

Vicky

Re: Select Option

LucianoBentiveg — Fri, 22 Sep 2006 13:25:25 GMT

In INITIALIZATION event, do:

S_BUDAT-LOW = 1/12/2004

S_BUDAT-HIGH = 31/12/2004

Regards

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:26:18 GMT

In Initialization write the following.

s_date-option = 'EQ'.

s_date-sign = 'I'.

S_date-low = '20041201'.

s_date-high = '20041231'.

append s_date.

clear s_date.

Regards,

Raj

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:26:55 GMT

Not for One month!!It should be with respect to sy-datum..

Thanks

Vicky

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:31:12 GMT

Use FM HR_JP_MONTH_BEGIN_END_DATE

and pass Sy-datum, you will get first date of month and last date..populate in s_date (select-option field)

Regards,

Raj

For eg:

Test for function group HRJE

Function module

HR_JP_MONTH_BEGIN_END_DATE

Import parameters

Value

IV_DATE 21.09.2006

Export parameters Value

EV_MONTH_BEGIN_DATE 01.09.2006

EV_MONTH_END_DATE 30.09.2006

Message was edited by: Rajasekhar Dinavahi

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:39:21 GMT

in INITIALIZATION use:

I_BUDAT-OPTION = 'EQ'.

I_BUDAT-SIGN = 'I'.

I_BUDAT-LOW = sy-datum. "lets say 20060922

I_BUDAT-LOW+6(2) = '01'.<-- Populate 1 day of that month

here this I_BUDAT-LOW becomes 20060901

i_budat-high = sy-datum.

CALL FUNCTION 'LAST_DAY_OF_MONTHS'

EXPORTING

DAY_IN = I_BUDAT-HIGH "20060922

IMPORTING

LAST_DAY_OF_MONTH = I_BUDAT-HIGH. 20060930

-> Gives you the last day of a Month

APPEND I_BUDAT.

this function module will get Last day of the month in date format,if we pass current date.

Regards

Srikanth

Message was edited by: Srikanth Kidambi

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:40:26 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.

reward if it helps..

Message was edited by: srinu k

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:40:36 GMT

Hi,

Use this in INITIALIZATION

Use Fm 'FIRST_DAY_IN_PERIOD_GET' to get first day of month.

Export parameters:

I_GJAHR = sy-datum+0(4)

I_PERIV = K4

I_POPER = sy-datum+4(2)

Use Fm 'LAST_DAY_IN_PERIOD_GET' to get first day of month.

Export parameters:

I_GJAHR = sy-datum+0(4)

I_PERIV = K4

I_POPER = sy-datum+4(2)

regrds..

jaison

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:40:44 GMT

Try:

SELECT-OPTIONS: s_date FOR sy-datum.

DATA: date_lo LIKE sy-datum,
      date_hi LIKE sy-datum.

INITIALIZATION.

  date_lo = sy-datum.
  date_lo+6 = '01'.

  date_hi = date_lo + 33.
  date_hi+6 = '01'.
  date_hi = date_hi - 1.

  s_date-option = 'EQ'.
  s_date-sign   = 'I'.
  s_date-low    = date_lo.
  s_date-high   = date_hi.

  APPEND s_date.

Rob

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:40:55 GMT

You can use sy-datum and find the month by offsetting method.

Start date is always going to be 1st. So no issues. you can concatenate and find.

Now the problem is to find the end date, it might be 28,29,30, 31.

use this functional module to find the last date of the month.

SLS_MISC_GET_LAST_DAY_OF_MONTH

Then you have to assign

sel_date-option = EQ'.

sel_date-sign = 'I'.

Sel_date-low =

sel_date-high =

append sel-date

regards

Vivek

reward points for all the useful answers

Re: Select Option

Former Member — Fri, 22 Sep 2006 13:49:39 GMT

Hey just follow these steps.

No need to code anything.

Create a variant.

1. While Saving the variant Check the box for the your date field and Selection variable "L" and

2. Click on the Selection variable button.

3. Choose option "D"

4. Below your date field you can find a down arrow, press it.

5. Select the opotion "Current period" and choose.

6. Save it.

Whenever you use this variant again, you can find the low & high fields got pupulated with the First & Last date's of the current month.

Reward if useful,

-Vinodh.

Re: Select Option

Former Member — Fri, 22 Sep 2006 14:11:49 GMT

Hello,

In the event INITIALIZATION,

S_MATHR-LOW = MUM7000.

S_MATNR-HIGH = MUM7999.

Regs,

Venkat

Re: Select Option

shishupalreddy — Mon, 25 Sep 2006 09:46:58 GMT

use

FIRST_DAY_IN_PERIOD_GET to get the first day of the month .

LAST_DAY_IN_PERIOD_GET to get the last day of the period .

provide the required exporting parmeters .

Store the result in selection screen parameters.

use these function modules in initilazation event to get the default values ion to the selction screen

Re: Select Option

Former Member — Sun, 04 Aug 2013 09:53:22 GMT

This message was moderated.