topic Re: Problem in Date Range in Application Development and Automation Discussions

Problem in Date Range

satish_kumar127 — Wed, 17 Sep 2014 06:59:46 GMT

Hi guys,

SELECT-OPTIONS: v_month FOR s068-spmon OBLIGATORY.

here v_month (month and year) is excluding given input months while fetching the data.

it's not fetching the 4th and 9th months data.

colud anybody please let me know how to make both input dates include?

Thanks in Advance

regards

satish

Re: Problem in Date Range

Former Member — Wed, 17 Sep 2014 07:05:28 GMT

Hi satish,

You can create a range table for date and pass option as equal and then use this for making selection.

Regards
Giri

Re: Problem in Date Range

jrg_wulf — Wed, 17 Sep 2014 09:23:51 GMT

Hi Satish,

by only looking on the select-option, i'd say , there's nothing wrong with it.

The option BT signals an open interval, meaning that both, low and high value are included in the selction.

Whithout further knowledge of your source, where you actually use the select-option, it's next to impossible to analyse your problem.

Please provide a bit more information.

Best regards - Jörg

Re: Problem in Date Range

satish_kumar127 — Wed, 17 Sep 2014 10:16:39 GMT

hi jorg,

thanks for the input

the following is my query

SELECT mblnr mjahr zeile bwart matnr lifnr ebeln ebelp lgort budat_mkpf meins menge werks FROM mseg

INTO CORRESPONDING FIELDS OF TABLE it_mseg

WHERE lifnr IN s_lifnr

AND matnr IN s_matnr

AND werks IN s_werks

AND budat_mkpf IN v_month

here budat_mkpf is the date field (ddmmyyyy) AND V_MONTH is my input (mmyyyy).

is it giving any problem.

regards

satish

Re: Problem in Date Range

former_member202818 — Wed, 17 Sep 2014 10:33:23 GMT

Hi Satish,

Edit v_month.

concatenate v_month-low '01' to v_month-low.

concatenate v_month-high '31' to v_month-high.

Re: Problem in Date Range

jrg_wulf — Wed, 17 Sep 2014 10:50:50 GMT

Hi Satish,

here we go.

You're actually comparing an 8-digit DB-field to a 6-digit select-option.

Let's have a look on it, from a programs perspective

Budats inner representation is like YYYYMMDD, whereas your select-options inner representation comes as IBTYYYYMMYYYYMM. The db now interpretes the line IBT201404201409

as interval between 20.04.2014 to ... well something.

Now there're two possible ways out:

change your select-option to

SELECT-OPTIONS v_month for mseg-budat_mkpf and fill it like

01.04.2014 to 30.09.2014

or 2.

create another ranges tab like

DATA: rt_budat TYPE RANGE OF mseg-budat_mkpf,

rs_budat LIKE LINE OF rt_budat.

DATA: l_hlp TYPE DATS.

LOOP AT v_month.

MOVE-CORRESPONDING v_month TO rs_budat

rs_budat-low+6(2) = '01'.

* the following looks a bit lengthy, yet it's the fastest way

* to calculate the last day of any given month

l_hlp = rs_budat-high.

l_hlp+6(2) = '28'. "highest day in every month

ADD 4 TO l_hlp. "garanteed to be in the next month

l_hlp+6(2) = '01'. "set to first day of next month

SUBTRACT 1 from l_hlp. "Let ABAP do the month-end calculation

rs_budat-high = l_hlp.

append rs_budat to rt_budat.

ENDLOOP.

Now use your new rangetab instead of select-option.

Personally, i'd go for the first option.

Best regards - Jörg

Re: Problem in Date Range

satish_kumar127 — Wed, 17 Sep 2014 11:03:27 GMT

hi jorg,

you are really awesome. thanks for the wonderful kt. my issue has been resolved.

Thanks a lot.

regards

satish