topic Re: SELECT QUERY in Application Development and Automation Discussions

SELECT QUERY

Former Member — Tue, 29 May 2007 11:15:12 GMT

Hi Abappers,

I want to fetch data from a table where plant = 1901 and meins is KG or L20 and msehi is KG or L20.

How shud i formulate the query.

Thanks,

Mansi.

Re: SELECT QUERY

Former Member — Tue, 29 May 2007 11:17:35 GMT

select * 
           from ztable
            into table itab 
            where werks = '1901' and
                      meins in ('KG' , 'L20') and
                      msehi in ('KG' , 'L20').

Re: SELECT QUERY

Former Member — Tue, 29 May 2007 11:18:02 GMT

SELECT * FROM

ZTABLE

where

werks = '1901' and

meins in ( 'KG' , 'L20' ) and

msehi in ( 'KG' , 'L20').

Re: SELECT QUERY

Former Member — Tue, 29 May 2007 11:18:05 GMT

Write the query like this

select * from table into table in_table

where werks = '1901'

and meins = ('KG' 'L20')

and msehi = ('KG' 'L20').

reward points if it is helpful

Thanks

Seshu

Re: SELECT QUERY

amit_khare — Tue, 29 May 2007 11:18:41 GMT

select * from <table> where plant = 1901

and ( meins =kg

or meins = L20 )

and ( msehi = KG

or msehi = L20 ).

Regards,

Amit

Re: SELECT QUERY

Former Member — Tue, 29 May 2007 11:19:14 GMT

Hi,

Use the statement as below.

Select <fields> from table <table name> into tbale <internal table>

where plant = '1901' and

means = ( 'kg' or 'L20' ) and

msehi = ( 'KG' or 'L20' ).

Regards,

Ram

Re: SELECT QUERY

naveen1241 — Tue, 29 May 2007 11:21:18 GMT

select * from <table> to <itab>

where plant = '1901'

and meins in ('KG', 'L20')

and msehi in ( 'KG' , 'L20').

Re: SELECT QUERY

Former Member — Tue, 29 May 2007 11:38:03 GMT

hi mansi,

select *

from ztable

into table itab

where werks = '1901' and

meins in ('KG' , 'L20') and

msehi in ('KG' , 'L20').

if useful reward some points.

with regards,

suresh babu aluri.