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'.