hi
HOW TO MAKE THE FOLLOWING QUERY IN A SIMPLE WAY.
if S_MAT <> ''.
select A~matnr
A~ernam
A~mtart
A~meins
A~bstme
B~maktx
C~bwkey
C~lbkum
C~salk3
C~stprs
C~peinh
C~bklas
into corresponding fields of table it_rep
from mara as A
inner join makt as B on Amatnr = Bmatnr
inner join mbew as C on Amatnr = Cmatnr
where ( A~matnr in S_MAT ).
elseif S_PLANT <> ''.
select A~matnr
A~ernam
A~mtart
A~meins
A~bstme
B~maktx
C~bwkey
"C~lbkum
"C~salk3
"C~stprs
C~peinh
C~bklas
into corresponding fields of table it_rep
from mara as A inner join makt as B on Amatnr = Bmatnr
inner join mbew as C on Amatnr = Cmatnr
where A~matnr in
( select matnr from marc where werks in S_PLANT ).
elseif S_LOCT <> ''.
select A~matnr
A~ernam
A~mtart
A~meins
A~bstme
B~maktx
C~bwkey
"C~lbkum
"C~salk3
"C~stprs
C~peinh
C~bklas
into corresponding fields of table it_rep
from mara as A inner join makt as B on Amatnr = Bmatnr
inner join mbew as C on Amatnr = Cmatnr
where A~matnr in
( select matnr from mard where lgort in S_LOCT ).
endif.
GANESH