range in select option

[SwarnaliBasu]

HI

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

[Pawan_Kesari]

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

[SwarnaliBasu]

HI

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

please chek once more

[former_member217544]

Hi,

Can you explain what do ypu mean by this :

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

Regards,

Swarna Munukoti

[Pawan_Kesari]

>

> 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..

OR

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

[Nawanandana]

hi

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.

[kesavadas_thekkillath]

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

[SwarnaliBasu]

HI

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

[kesavadas_thekkillath]

values are never fixed

what do you mean by this?Could you explain more

[Nawanandana]

hi

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.

[SwarnaliBasu]

thanks but none of them worked