topic Re: Select Query. in Application Development and Automation Discussions

Select Query.

Former Member — Mon, 23 Jun 2008 02:11:02 GMT

Hi,

I am trying to fetch data from a data base table, checking some conditions. My trying like this,

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE sprsl = sy-langu

AND moabw = '25'

AND (awart = '0210' or awart = '0220' or awart = '0230' or awart = '0930').

But it showing error for the field AWART. Could you please anybody suggest me how to correct my query.

Thanks,

Ram.

Re: Select Query.

nikhil_chitre — Mon, 23 Jun 2008 02:16:53 GMT

Hi,

Create a Range for field AWART.

Fill this range with desider values for selection.

And then use the select query.

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE sprsl = sy-langu

AND moabw = '25'

AND awart IN r_awart.

Hope this helps.

Regards,

Nikhil

Edited by: Nikhil A Chitre on Jun 23, 2008 12:17 PM

Re: Select Query.

Former Member — Mon, 23 Jun 2008 02:21:04 GMT

try this,

used ranges.

*Create range for awart

r_awart-sign = 'I'.

r_awart-option = 'EQ'.

r_awart-low = '0210'.

append r_awart.

r_awart-low = '0220'.

append r_awart.

r_awart-low = '0230'.

append r_awart.

r_awart-low = '0930'.

append r_awart.

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE sprsl = sy-langu

AND moabw = '25'

AND awart in r_awart.

reward if its useful.

Link : [ABAP Tips|http://abap4beginner.blogspot.com]

Re: Select Query.

Former Member — Mon, 23 Jun 2008 02:58:39 GMT

Hi Ram,

Try this way...

SELECT SINGLE atext
  INTO p_leave_type_text
  FROM t554t
 WHERE sprsl = sy-langu
   AND moabw = '25'
   AND ( awart = '0210'
    OR   awart = '0220'
    OR   awart = '0230'
    OR   awart = '0930' ).

Best regards,

raam

Re: Select Query.

Former Member — Mon, 23 Jun 2008 03:43:51 GMT

HI,

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE sprsl = sy-langu

AND moabw = '25'

AND awart IN ( '0210' , '0220' , '0230' , '0930').

Re: Select Query.

kesavadas_thekkillath — Mon, 23 Jun 2008 03:46:31 GMT

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE moabw = '25'

AND awart in ('0210','0220','0230','0930')

and sprsl = sy-langu.

Re: Select Query.

Former Member — Mon, 23 Jun 2008 04:17:06 GMT

Hi Ram,

Create a Range and append all the data in the range and pass it in the select query.

RANGES: R_AWART FOR T554T-AWART.

R_AWART-SIGN = 'I'.

R_AWART-OPTION = 'EQ'.

R_AWART-LOW = '0210'.

APPEND R_AWART.

R_AWART-SIGN = 'I'.

R_AWART-OPTION = 'EQ'.

R_AWART-LOW = '0220'.

APPEND R_AWART.

R_AWART-SIGN = 'I'.

R_AWART-OPTION = 'EQ'.

R_AWART-LOW = '0230'.

APPEND R_AWART.

R_AWART-SIGN = 'I'.

R_AWART-OPTION = 'EQ'.

R_AWART-LOW = '0930'.

APPEND R_AWART.

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE sprsl = sy-langu

AND moabw = '25'

AND awart IN R_AWART.

&***********Reward Point if helpful****************&

Re: Select Query.

Former Member — Mon, 23 Jun 2008 06:22:07 GMT

Hi,

Either you need to create a Range table or use IN clause or use Select-options.

1. Ranges:

Ranges: r_awart for t554t-awart.

*Create range for awart
r_awart-sign = 'I'.
r_awart-option = 'EQ'.
r_awart-low = '0210'.
append r_awart.
r_awart-low = '0220'.
append r_awart.
r_awart-low = '0230'.
append r_awart.
r_awart-low = '0930'.
append r_awart.

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE sprsl = sy-langu
AND moabw = '25'
AND awart *in*  r_awart.

2. Use IN clause :

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE sprsl = sy-langu
AND moabw = '25'
AND awart *IN* ( '0210' , '0220' , '0230' , '0930').

3. Use Select-options instead of parameter for awart :

select-options: s_awart for t554t-awart no intervals.

this will work same as parameter and even you can have any values for awart.

SELECT SINGLE atext I
NTO p_leave_type_text 
FROM t554t 
WHERE sprsl = sy-langu
AND moabw = '25'
AND awart *IN* s_awart.

This will surely help you.

Plz reward if useful.

Thanks,

Dhanashri.

Edited by: Dhanashri Pawar on Jun 23, 2008 8:22 AM

Edited by: Dhanashri Pawar on Jun 23, 2008 8:23 AM

Re: Select Query.

Former Member — Mon, 23 Jun 2008 06:58:29 GMT

Hi,

Use your query like this .

SELECT SINGLE atext INTO p_leave_type_text FROM t554t WHERE moabw = '25'

AND and sprsl = sy-langu

AND awart in ('0210','0220','0230','0930')

Other wise you can made range for the field awart but if you write like this your query will run faster and data fetching will be efficient and your code lines will be reduced.

I hope this will help you.

Help children of U.N World Food Program by rewarding points and encourage others to answer your queries.