topic Re: selecting not matching fields in Application Development and Automation Discussions

selecting not matching fields

Former Member — Mon, 07 Jun 2010 13:52:19 GMT

hi experts,

i have selected matnr and normt from mara and kept in internal table i_mara,

i have selected matnr from z table in internal table i_docp,

i want to have a internal table

it should contain matnr from mara which is not matching with ztable matnr...

Re: selecting not matching fields

Former Member — Mon, 07 Jun 2010 13:58:10 GMT

data: begin of ls_data,
           matnr type matnr,
           normt type ???,
           zmatnr type matnr,
         end of ls_data,
         lt_data like table of ls_data.


SELECT mara~matnr mara~normt z~matnr as zmatnr
  into corresponding fields of table lt_data
  from mara left outer join z
  on mara~matnr = z~matnr
  where ....

delete lt_data where [not] zmatnr is initial.

Kind regards

André Witt

Re: selecting not matching fields

Former Member — Mon, 07 Jun 2010 14:07:28 GMT

hi...

use this code..



loop i_mara into wa_mara.

read table i_docp into wa_docp with key matnr = wa_mara-matnr.
 if sy-subrc eq 0.
   delete i_mara where matnr = wa_mara-matnr.
 endif.
endloop.

best regards

Marco