topic SELECT OPTIONS PROB in Application Development and Automation Discussions

SELECT OPTIONS PROB

Former Member — Tue, 20 Jul 2010 22:37:36 GMT

In select-options, how to get the default values as current month first date and last date by default? Eg: 1/12/2010 and 31/12/2010

Re: SELECT OPTIONS PROB

Former Member — Tue, 20 Jul 2010 23:29:36 GMT

Hi friend,,

Try this code:


INITIALIZATION.

DATA:
        lv_bgdat  TYPE d,
        lv_endat  TYPE d.

*
  CALL FUNCTION 'HR_JP_MONTH_BEGIN_END_DATE'
    EXPORTING
      iv_date             = sy-datum
    IMPORTING
      ev_month_begin_date = lv_bgdat
      ev_month_end_date   = lv_endat.

* p_out is your select-options
  REFRESH p_out.
  p_out-sign    = 'I'.
  p_out-option  = 'BT'.
  p_out-low     = lv_bgdat.
  p_out-high    = lv_endat.
  APPEND p_out.

hope that help

Re: SELECT OPTIONS PROB

bbalci — Wed, 21 Jul 2010 12:54:13 GMT

u can simply use this code :

REPORT zso_date.

SELECT-OPTIONS s_date FOR sy-datum.

INITIALIZATION.

"1 First day of month

CONCATENATE sy-datum(6) '01' INTO s_date-low.

"2 Last day of month :

"find first day of next month :

s_date-high = s_date-low.

ADD 1 TO s_date-high+4(2). "add 1 month

s_date-high+6(2) = '01'. "find first day

"go 1 day earlier :

SUBTRACT 1 FROM s_date-high.

APPEND s_date.

START-OF-SELECTION.

Re: SELECT OPTIONS PROB

Former Member — Wed, 21 Jul 2010 15:14:30 GMT

Moderator message - Please do not ask or answer basic questions - thread locked Rob