SELECT QUERY

[Former Member]

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.

[Former Member]

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

[Former Member]

SELECT * FROM

ZTABLE

where

werks = '1901' and

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

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

[Former Member]

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

[amit_khare]

select * from <table> where plant = 1901

and ( meins =kg

or meins = L20 )

and ( msehi = KG

or msehi = L20 ).

Regards,

Amit

[Former Member]

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

[naveen1241]

select * from <table> to <itab>

where plant = '1901'

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

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

[Former Member]

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.