topic Re: query -report in Application Development and Automation Discussions

query -report

Former Member — Tue, 10 Oct 2006 09:36:45 GMT

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..

Re: query -report

Former Member — Tue, 10 Oct 2006 09:49:49 GMT

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.