Skip to Content
0
Former Member
Dec 12, 2006 at 08:37 AM

query

29 Views

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