topic Re: select query problem? in Application Development and Automation Discussions

select query problem?

Former Member — Wed, 19 Jul 2006 05:45:27 GMT

Guys,

with the following select statement data is not coming correctly.pleae help on this.

select werks lifnr from t001w into table int_t001w where

werks in s_werks and

werks in s_werks1.

regards,

vijay

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:46:27 GMT

select werks lifnr from t001w into table int_t001w where

werks in s_werks or

werks in s_werks1.

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:48:04 GMT

we use IN in the where clause when we deal with select options in reporting.

otherwise, to correct ur statement use '=' operator in where clause.

Reward points if helpful.

Naveen

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:48:13 GMT

Or you can simply do away with one select-options

append lines of s_werks1 to s_werks.

select werks lifnr from t001w into table int_t001w where

werks in s_werks.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:49:08 GMT

Hi vijay,

Explain your requirement then we can come out with exact select statement.

Azaz Ali.

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:49:08 GMT

Hi Vijay

select werks lifnr from t001w into table int_t001w where

werks in s_werks and

werks in s_werks1.

collect int_t001w.

You have to use collect statement.

Regards

Abhishek

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:49:25 GMT

Hi,

What is the difference in S_WERKS and S_WERKS1??

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:49:33 GMT

Hi Vijay,

your Problum is :

select werks lifnr from t001w into table int_t001w where

werks in s_werks and

werks in s_werks1.

append lines of s_werks1 to s_werks.

you can use collect statement through it you can add all the int. values.

Regards.

Ankur garg.

Message was edited by: Ankur Garg

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:50:23 GMT

Hi Vijay,

I have made a slight change to your select statement.

Please find it below.


select werks lifnr from t001w 
                   into table int_t001w 
                   where werks in s_werks 
                <b> or </b> werks in s_werks1.

Hope it solves your problem.

Regards,

Anirban.

Re: select query problem?

Former Member — Wed, 19 Jul 2006 05:53:38 GMT

Hi,

Combine both the select options and pass that only in where clause.

append lines of s_werks1 to s_werks.

select werks 
       lifnr
   from t001w 
   into table int_t001w
 where werks in s_werks.

Regards

vijay

Re: select query problem?

abdul_hakim — Wed, 19 Jul 2006 05:56:59 GMT

use the below code..

APPEND LINES OF s_werks1 TO s_werks.

select werks lifnr from t001w into table int_t001w where

werks in s_werks.

Cheers,

Abdul Hakim

Re: select query problem?

Former Member — Wed, 19 Jul 2006 06:00:20 GMT

Hi Vijay,

I assume that your using s_werks and s_werks1 to input multiple values and ranges for werks.

This can be done using a single select-option.

Consider this code.


REPORT zztest.

TABLES : t001w.

DATA : int_t001w TYPE STANDARD TABLE OF t001w WITH HEADER LINE.
SELECT-OPTIONS : s_werks FOR t001w-werks.


INITIALIZATION.

<b>*Values in Ranges</b>
  s_werks-sign = 'I'.
  s_werks-option = 'BT'.
  s_werks-low = '1000'.
  s_werks-high = '2000'.
  APPEND s_werks.
  CLEAR s_werks.

<b>*Values in Ranges</b>
  s_werks-sign = 'I'.
  s_werks-option = 'BT'.
  s_werks-low = '4000'.
  s_werks-high = '5000'.
  APPEND s_werks.
  CLEAR s_werks.

<b>*Single Value</b>
  s_werks-sign = 'I'.
  s_werks-option = 'EQ'.
  s_werks-low = '2200'.
  APPEND s_werks.
  CLEAR s_werks.


START-OF-SELECTION.

  SELECT werks lifnr FROM t001w INTO TABLE int_t001w WHERE
  <b>werks IN s_werks</b>.

Regarding you code,

Instead of AND put a OR condition



  SELECT werks lifnr FROM t001w INTO TABLE int_t001w WHERE
  werks IN s_werks <b>OR</b>
  werks IN s_werks1.

Regards,

Arun Sambargi.

Re: select query problem?

Former Member — Wed, 19 Jul 2006 06:46:55 GMT

Thanks to all,problem is solved.