Hi Guys,
Whats wrong in my select statement.,
SELECT lifnr
xblnr
bukrs
inv_date
invr_date
zterm
dmbtr
waers
kursf
status FROM zinv_reg INTO TABLE lt_reg
WHERE status EQ 'CL'
AND bukrs EQ p_ccode
OR ( lifnr EQ p_vendor OR lifnr EQ ' ' )
OR ( invr_date GE so_date-low and
invr_date LE so_date-high ).
Here I need to pick only records where the data in between so_date-low and so_date-high, but with this select statement it is picking all the records.,
Can and one tell me how to do it.,
Regards,
Line