query -report

[Former Member]

hi

write the select satatment

that tables stko,stpo,mast,marc.

in this we take matnr werks.the query is display the data

which plant(werks) does not belangs to stko stpo mast and that belong to marc. means.u choose matnr that is not belongs mast and u get matnr from marc which does not belongs to mast stko stpo.write it full reo\port..

[Former Member]

SELECT matnr werks into itab

From marc where .

loop at itab.

select count(*) into lcnt

from mast

where matnr = itab-matnr and

werks = itab-werks.

if lcnt = 0.

• it does not belong to mast.

endif.

Endloop.