Hi experts
1. is it possible to use NOT IN operator
for e.g if i check few condition using ( IN operator ) and at the
same time want to check that is not there in my ( IN operator)
else pls do let me know by saying how can this be done.....
My query
========
Select pernr begda massn from pa0000 into corresponding fields of table it_pa0000
WHERE
MASSN in ('S1', 'S2', 'S3', 'S4', 'S7')
and massn not in 'S5' " this is wat the condition i want to check and pernr in so_pernr.
Elseif pr_sep = 'X'.
Select pernr begda from pa0000 into corresponding fields of table it_pa0000
WHERE
BEGDA <= SY-DATUM AND
ENDDA >= SY-DATUM AND
MASSN in ('S5')
and pernr in so_pernr.
thanx & regards
Rachel