i need to take all the status of "objnr" but there are status that i dont want to see exclude
this is the select that take all the status
select-option: z_stat_i FOR jest-stat,
z_stat_e FOR jest-stat.
SELECT stat
FROM jest
INTO mdstat-zs_stat
WHERE objnr = mdeqp-objnr
AND stat IN z_stat_i
AND inact = ' '.
APPEND mdstat.
any ideas?
thanks