topic Re: Select Material by Material Type in Application Development and Automation Discussions

Select Material by Material Type

Former Member — Fri, 06 Jul 2007 19:00:53 GMT

I have Material Number in an internal table and not material type.i want to delete all the material Number from the table whose material type not equal to 'ZFRT'.How i can i do that? Kindly help me.

Re: Select Material by Material Type

RichHeilman — Fri, 06 Jul 2007 19:05:33 GMT

Well, it would be easier and better to have Material Type within the internal table if you have the chance to do that, or even you could do this condition when selecting the materials from the database into the internal table, but if you truely have no other option, then i guess you can do this.



data: xmara type mara

loop at itab.

   select single * from mara into xmara
               where matnr = itab-matnr
                   and mtart = 'ZFRT'.
   if sy-subrc <> 0.
     delete itab.
     continue.
    endif.

endloop.

REgards,

Rich Heilman

Re: Select Material by Material Type

Former Member — Fri, 06 Jul 2007 19:53:27 GMT

Rich Heilman

It Works Perfect....

Thanks

Re: Select Material by Material Type

Former Member — Fri, 06 Jul 2007 19:59:23 GMT

Hi,

If you have material number in it_itab, then


TYPES : BEGIN OF x_mara,
          matnr TYPE matnr,
          mtart TYPE mtart,
        END   OF x_mara.

DATA : it_mara TYPE TABLE OF x_mara.

SELECT matnr mtart
  FROM mara
  INTO TABLE it_mara
  FOR ALL ENTRIES IN it_itab
  WHERE matnr = it_itab-matnr
    AND mtart = 'ZFRT'.

IF sy-subrc = 0.
  DELETE it_itab FROM it_mara.
ELSE.
  REFRESH : it_mara.
ENDIF.

Reward points if the answer is helpful.

Regards,

Mukul

Re: Select Material by Material Type

Former Member — Fri, 06 Jul 2007 20:02:12 GMT

Hi,

If you have material number in it_itab, then


TYPES : BEGIN OF x_mara,
          matnr TYPE matnr,
          mtart TYPE mtart,
        END   OF x_mara.
 
DATA : it_mara TYPE TABLE OF x_mara.
 
SELECT matnr mtart
  FROM mara
  INTO TABLE it_mara
  FOR ALL ENTRIES IN it_itab
  WHERE matnr = it_itab-matnr
    AND mtart = 'ZFRT'.
 
IF sy-subrc = 0.
  DELETE it_itab FROM it_mara.
ELSE.
  REFRESH : it_mara.
ENDIF.

Reward points if the answer is helpful.

Regards,

Mukul