topic Re: Internal table deletion in Application Development and Automation Discussions

Internal table deletion

Former Member — Fri, 23 Jul 2010 06:23:11 GMT

Hi,

I have an internal table with 1000 material and i want to delete the material from internal table which length is more than 15.

I do not want to use

loop .

delete

endloop.

Is there any other better way?

Thanks

Re: Internal table deletion

former_member186741 — Fri, 23 Jul 2010 06:39:33 GMT

Please clarify.

Are you saying that you only need the first 15 entries of the table or are you saying you want to remove any entries in the table which have a matnr field of greater length than 15? Or something else??

Re: Internal table deletion

Former Member — Fri, 23 Jul 2010 06:41:18 GMT

What you can do is create a field symbol and then let this field symbol point to the header line of the internal table then check you query against the field-symol entry and if the entry is found then the remove the adress where the field symbol is pointing for that entry.

Thanks

Re: Internal table deletion

Former Member — Fri, 23 Jul 2010 06:52:30 GMT

Hi,

I want to delete the material length if greater than 15

for ex

material

123444 - do not delete

1234567890abcdefr - delete

1234567890abcdefty - delete

asdhgk - do not delete

Re: Internal table deletion

Sandeep_Panghal — Fri, 23 Jul 2010 06:58:08 GMT

loop at itab.

find stlen for each material.

if stlen >15 .

delete itab using index.

endif.

endloop.

Re: Internal table deletion

Former Member — Fri, 23 Jul 2010 07:05:30 GMT

Hi,

Just a sample.


DATA lt_vbap TYPE TABLE OF vbap.

SELECT *
  FROM vbap
  INTO TABLE lt_vbap
 WHERE matnr NE space.

DELETE lt_vbap WHERE matnr+15(x) NE ' '.  "fill x with the remaining length of data variable

best regards,

John

Re: Internal table deletion

former_member440650 — Fri, 23 Jul 2010 07:05:42 GMT

Hi , check the following code..

data:begin of it_data occurs 0,

matnr(18),

end of it_data.

data: int type i.

it_data-matnr = '123444'.

append it_data.

it_data-matnr = '1234567890abcdefr'.

append it_data.

it_data-matnr = '1234567890abcdefty'.

append it_data.

it_data-matnr = 'asdhgk'.

append it_data.

loop at it_data.

clear int.

int = strlen( it_data-matnr ).

if int > 15.

delete it_data.

endif.

endloop.

Ram.

Re: Internal table deletion

Former Member — Fri, 23 Jul 2010 07:06:21 GMT

Hi,

I dont want to use use loop .. endloop.

If i have 2 lacs material if i use loop .. endloop it will read 2 lacs times . i want to avoid this

I need someother way to do it.

Re: Internal table deletion

Former Member — Fri, 23 Jul 2010 07:10:05 GMT

Have you taken a look at my example?

Best regards,

John

Re: Internal table deletion

Former Member — Fri, 23 Jul 2010 07:13:10 GMT

try with jvanpelt solution

its work

Thanks

Re: Internal table deletion

former_member440650 — Fri, 23 Jul 2010 07:19:23 GMT

Hi, check this one........becarefull remove leading zeros for material

data:begin of it_data occurs 0,

matnr(18),

end of it_data.

data: int type i.

it_data-matnr = '123444'.

append it_data.

it_data-matnr = '1234567890abcdefr'.

append it_data.

it_data-matnr = '1234567890abcdefty'.

append it_data.

it_data-matnr = 'asdhgk'.

append it_data.

DELETE it_data WHERE matnr+15(3) NE ' '.

Re: Internal table deletion

Former Member — Fri, 23 Jul 2010 07:21:36 GMT

Hi,

You can code like this:

DELETE <itab> WHERE matnr+15(3) NE space.

This statement will delete the record from <itab> where the MATNR is greater than 15 character.

Regards

DKS

Re: Internal table deletion

Former Member — Fri, 23 Jul 2010 07:23:18 GMT

use this code.

DELETE <your Internal Table> WHERE strlen(material) GT 15.

Hope this will work.

With Regards.