topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 20 Sep 2007 04:42:22 GMT

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

Re: select statement

Former Member — Thu, 20 Sep 2007 04:46:40 GMT

Hi,

Instead of using OR operator, use IN operator. Refer the syntax for it and use. Bcoz., of OR operator it is taking all records I suppose.

Reward if useful.

Re: select statement

gopi_narendra — Thu, 20 Sep 2007 04:47:18 GMT

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
AND ( lifnr EQ p_vendor OR lifnr EQ ' ' ) " change OR to AND
AND invr_date GE so_date-low " change OR to AND
AND invr_date LE so_date-high .

This should work.

Regards

Gopi

Re: select statement

Former Member — Thu, 20 Sep 2007 04:55:18 GMT

I changed the code accordingly But I am unable to get the output., No records are picking with the select statement now.

Regards,

Line

Re: select statement

Former Member — Thu, 20 Sep 2007 05:01:24 GMT

Hi Line ,

Please check my response to the same question you have posted in the other post.

Regards

Arun

Re: select statement

Former Member — Thu, 20 Sep 2007 05:16:20 GMT

Hi,

Try this

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

AND ( lifnr EQ p_vendor OR lifnr EQ ' ' ) " change OR to AND

AND invr_date in so_date

Regards,

Aruna