topic Re: delete internal table matnr in Application Development and Automation Discussions

delete internal table matnr

Former Member — Sat, 25 Jul 2009 05:23:07 GMT

dear all

i want to delete internal table where matnr = '*J'. my material code is like 'E5178MPO80/095SJ'. so i want to delete where last character is J.

advance thanks

regards

p sree hari

Re: delete internal table matnr

Former Member — Sat, 25 Jul 2009 05:37:35 GMT

HI,

Use this code,

Loop at itab.
if itab-matnr+15(1) = 'J'.
   delete itab.
endif.
endloop.

Regards.

Re: delete internal table matnr

Former Member — Sat, 25 Jul 2009 09:25:24 GMT

Hi,

Try this way..

RANGES : R_MATNR FOR MARA_MATNR.

R_MATNR-SIGN = 'I'.
R_MATNR-OPTION = 'CP'.
R_MATNR-LOW = '*J'.
APPEND R_MATNR. CLEAR R_MATNR.

DELETE ITAB WHERE MATNR IN R_MATNR.

Re: delete internal table matnr

Former Member — Sat, 25 Jul 2009 11:18:44 GMT

please don't use ranges for internal tables. there is no advantage.

The first solution is o.k., but use no headerlines,

... see below ....

Edited by: Siegfried Boes on Jul 27, 2009 1:39 PM

Re: delete internal table matnr

Former Member — Mon, 27 Jul 2009 11:13:32 GMT

Hi,


No need of loop here.
delete itab where  matnr+17(1) = 'J'.  " deletes all the matnr ending with 'J'.

conclusion as 
data : matnr type matnr,w_i type i .
matnr = '000000000000000023'.
w_i = matnr+17(1).
write w_i . " Answer is 3 here

hope this might be helpfull,

Regards,

Aby

Re: delete internal table matnr

ThomasZloch — Mon, 27 Jul 2009 11:25:24 GMT

why not simply use

DELETE itab WHERE MATNR CP '*J'.

Thomas

Re: delete internal table matnr

Former Member — Mon, 27 Jul 2009 11:44:37 GMT

E5178MPO80 /095SJ


LOOP AT itab ASSIGNING <fs>.
  IF ( <fs>-matr+16(1) = 'J' ).
    DELETE itab INDEX sy-tabix.
  ENDIF.
ENDLOOP.

I have my doubts that the WHERE-condition also offset manipulation.

The CP is probably less efficient than something with one offset check.

It depends on size of itab.

Please, recount the offset, there are no proposals between 15 and 17

Siegfried

Re: delete internal table matnr

Former Member — Fri, 20 Sep 2019 07:14:56 GMT

Thanks. That was helpful for me.