topic select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 20 Sep 2007 04:39:46 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:44:55 GMT

Hi Line ,

What all condition you want to check , because in this case if a record satisfies any of the condition

1. status EQ 'CL' AND bukrs EQ p_ccode

2. lifnr EQ p_vendor OR lifnr EQ ' '

3. invr_date GE so_date-low and invr_date LE so_date-high

then the record will be selected , now if what you want is the the date range must be in the so_date range then the condition must not be OR but AND , so that for every record that is selected this condition must be satisfied.

Regards

Arun

Re: select statement

Former Member — Thu, 20 Sep 2007 04:44:58 GMT

Hi,

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 ' ' ) -

> Here comes the mistake

OR ( invr_date GE so_date-low and

invr_date LE so_date-high ).

Use

SELECT ... WHERE <s> IN (<f 1>, ......, <f n>) ...

Please reward if useful.

Re: select statement

Former Member — Thu, 20 Sep 2007 04:45:00 GMT

Hi line,

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

OR ( lifnr EQ p_vendor OR lifnr EQ ' ' )

AND invr_date IN so_date.

Regards,

Sachin.

Re: select statement

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

hi,

invr_date is select options then try like this

data: so_date like sy-datum [use appropriate table and field for 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

OR ( lifnr EQ p_vendor OR lifnr EQ ' ' )

OR ( invr_date in so_date.)

if it displays all records means then ur condition is failing and after select check sy-subrc value by if and proceedd further or debug it.

if helpful reward some points.

with regards,

Suresh Aluri.

Re: select statement

Former Member — Thu, 20 Sep 2007 05:03:39 GMT

hi,

i changed last line of ur sele3ct query please check...

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

thanks,

maheedhar

Re: select statement

Former Member — Thu, 20 Sep 2007 05:14:35 GMT

Dear,,

try this: SURELY RESOLVED.

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 ' ' )

AND invr_date IN so_date.

CHEERS !!

REGARDS

AMIT SINGLA

Re: select statement

Former Member — Thu, 20 Sep 2007 05:17:58 GMT

Hi Suresh,

I tried this way but cannot get the required output.

Line

Re: select statement

Former Member — Thu, 20 Sep 2007 07:00:37 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 ( invr_date GE so_date-low and invr_date LE so_date-high )

OR ( lifnr EQ p_vendor OR lifnr EQ ' ' ).

thanks

Dharmishta

Re: select statement

Former Member — Thu, 20 Sep 2007 07:19:55 GMT

hi line,

since u need data only in between the dates in so_date you need to put an and condition instead of or.also instead of taking the so_date-low and so_date-high you can use "IN" to get the range.

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 ' ' )

and ( invr_date in so_date).

Regards,

Sohi..