Skip to Content
0
Former Member
Jan 16, 2008 at 12:11 PM

select statement

20 Views

hi

my requirement is i have to exculde the Z2 and Z5 in mstae field. is the follwing select query is correct,

please tell me how to use mstae ne z2 and z5 in one statement insted of using in following manner.

select matnr

mstae

from mara

into table gt_mara

where matnr EQ ms_matnr

and mstae ne 'Z2'

and mstae ne 'z5'.