topic Re: select-options in Application Development and Automation Discussions

select-options

Former Member — Fri, 06 Jul 2007 06:45:04 GMT

date field should particularly 2 months.

i think we have to use at selection-screen what query we have to write.

Re: select-options

Former Member — Fri, 06 Jul 2007 06:48:48 GMT

declare

tables: bsis.

data: v_days type I.

select-options: s_monat for BSIS-monat.

you will enter some value in LOW and High fields.

at selection-screen.

v_days = s_monat-high - s-Monat-low.

if v_days < 60 days. (rough calculation for 2 months it is 60 days)

message i000 with 'Enter correct data range'.

endif.

Reward points for useful Answers

Regards

Anji

Re: select-options

Former Member — Fri, 06 Jul 2007 06:49:09 GMT

please dont raise duplicate posts, chk my answer in previous thread

REPORT ychatest.

SELECT-OPTIONS : s_date FOR sy-datum.
DATA : v_date LIKE sy-datum,
       v_mon(2) TYPE n.

INITIALIZATION.

  s_date-sign = 'I'.
  s_date-high = 'BT'.
  s_date-low = sy-datum.
  v_mon = sy-datum+4(2) + 2.
  CONCATENATE sy-datum+0(4) v_mon sy-datum+6(2) INTO v_date.
  s_date-high = v_date.
  APPEND s_date.
  CLEAR s_date.

Re: select-options

Former Member — Fri, 06 Jul 2007 06:58:59 GMT

It would be better if you use the Fucntion module RP_CALC_DATE_IN_INTERVAL for your requirement.

Thanks,

Maheshwari V

Re: select-options

mohammed_moqeeth — Fri, 06 Jul 2007 08:47:47 GMT

Dear Jamshad Ali,

You have to validate the date at selection-screen, Here is a code for you:

SELECT-OPTIONS: s_date FOR sy-datum.

AT SELECTION-SCREEN ON s_date.

DATA date_diff TYPE i.

date_diff = s_date-high - s_date-low.

IF date_diff GT 60.

MESSAGE e000(0) WITH 'Please enter date not more that two months'.

ENDIF.

Reward points .. if useful.

Cheers!

Moqeeth.

Re: select-options

kesavadas_thekkillath — Fri, 06 Jul 2007 11:05:11 GMT

At selection screen on <ur date field>

if <date field-high> ! = ' '.

subtract two dates.

if difference greater than 60.

print the error msg.

endif.