topic Re: range in select option in Application Development and Automation Discussions

range in select option

SwarnaliBasu — Thu, 03 Dec 2009 10:32:37 GMT

My requirement is i have to consider all the sales order between two shipping dates.

eg: s_cmngv for vbak_cmngv
               
 IF s_cmngv IS NOT INITIAL.


 SELECT vbak~vbeln vbak~spart vbak~vkorg vbak~vtweg vbak~knkli vbak~cmngv
             fpltc~ccins fpltc~ccnum fpltc~ccname fpltc~datbi

             INTO TABLE i_next
             FROM vbak INNER JOIN fpltc
             ON vbak~rplnr = fpltc~fplnr
             WHERE fpltc~datbi < s_cmngv-low btw fpltc~datbi < s_cmngv-high.

please tell me how to write the select statement that all the CMNGV falls between these range.

Edited by: Rob Burbank on Dec 3, 2009 9:28 AM

Re: range in select option

Pawan_Kesari — Thu, 03 Dec 2009 10:35:48 GMT

IF s_cmngv IS NOT INITIAL.

SELECT vbak~vbeln vbak~spart vbak~vkorg vbak~vtweg vbak~knkli vbak~cmngv
fpltc~ccins fpltc~ccnum fpltc~ccname fpltc~datbi

INTO TABLE i_next
FROM vbak INNER JOIN fpltc
ON vbak~rplnr = fpltc~fplnr
WHERE fpltc~datbi IN s_cmngv

ENDIF.

If you are filling data in S_SMNGV then make sure data is filled as below

s_cmngv-sign = 'I' .

s_cmngv-option = 'BT' .

s_cmngv-low = date1 .

s_cmgv-high = date2 .

where date1 <= date2 .

If data is coming from select-option then you don't have to do anything it is taken care of.

Edited by: Pawan Kesari on Dec 3, 2009 4:06 PM

Edited by: Pawan Kesari on Dec 3, 2009 4:08 PM

Re: range in select option

SwarnaliBasu — Thu, 03 Dec 2009 10:42:22 GMT

i cannot use IN because i want to compare two dates which are from different tables.

please chek once more

Re: range in select option

Nawanandana — Thu, 03 Dec 2009 10:47:12 GMT


data : s_cmngv for vbak_cmngv.

 IF s_cmngv IS NOT INITIAL.

            SELECT vbak~vbeln vbak~spart vbak~vkorg vbak~vtweg vbak~knkli vbak~cmngv
            fpltc~ccins fpltc~ccnum fpltc~ccname fpltc~datbi

            INTO TABLE i_next
            FROM vbak
            INNER JOIN fpltc    ON vbak~rplnr = fpltc~fplnr
            WHERE fpltc~datbi IN s_cmngv.

  endif.

regard

nawa.

Re: range in select option

former_member217544 — Thu, 03 Dec 2009 10:49:28 GMT

Hi,

Can you explain what do ypu mean by this :


 i want to compare two dates which are from different tables.

Regards,

Swarna Munukoti

Re: range in select option

kesavadas_thekkillath — Thu, 03 Dec 2009 10:49:29 GMT

if s_cmngv is a selection screen field

you can just use in s_cmngv in your query.

or if you are building the range ,

then

s_cmngv-sign = 'I'.

s_cmngv-option = 'BT'.

s_cmngv-low = '20071212'.

s_cmngv-high = '20081212'.

append s_cmngv.

then use in statement

Edited by: ksd on Dec 3, 2009 4:20 PM

Re: range in select option

Nawanandana — Thu, 03 Dec 2009 10:50:11 GMT


data : s_cmngv for vbak_cmngv.

 IF s_cmngv IS NOT INITIAL.

            SELECT vbak~vbeln vbak~spart vbak~vkorg vbak~vtweg vbak~knkli vbak~cmngv
            fpltc~ccins fpltc~ccnum fpltc~ccname fpltc~datbi

            INTO TABLE i_next
            FROM vbak
            INNER JOIN fpltc    ON vbak~rplnr = fpltc~fplnr
            WHERE fpltc~datbi IN s_cmngv.

  endif.

regard

nawa.

Re: range in select option

Pawan_Kesari — Thu, 03 Dec 2009 11:00:24 GMT


> HI
> i cannot use IN because i want to compare two dates which are  from different tables.
> 
> please chek once more

Prepare the range from those two dates from different tables

s_cmngv-sign = 'I' .

s_cmngv-option = 'BT' .

s_cmngv-low = date from first table .

s_cmgv-high = date from second table .

append s_cmngv .

Now use s_cmngv in select with IN operator..

If you really don't want to use IN then use below statement

SELECT vbak~vbeln vbak~spart vbak~vkorg vbak~vtweg vbak~knkli vbak~cmngv
fpltc~ccins fpltc~ccnum fpltc~ccname fpltc~datbi
INTO TABLE i_next
FROM vbak INNER JOIN fpltc
ON vbak~rplnr = fpltc~fplnr
WHERE fpltc~datbi >= s_cmngv-low AND fpltc~datbi <= s_cmngv-high.

Edited by: Pawan Kesari on Dec 3, 2009 4:30 PM

Re: range in select option

SwarnaliBasu — Thu, 03 Dec 2009 12:03:16 GMT

My S_cmngv-low/ high values are never fixed, its a variable so how will i use a fixed value for it

Re: range in select option

kesavadas_thekkillath — Thu, 03 Dec 2009 15:26:53 GMT


values are never fixed

what do you mean by this?Could you explain more

Re: range in select option

SwarnaliBasu — Wed, 13 Jan 2010 16:57:01 GMT

thanks but none of them worked