topic Re: delete in itab in Application Development and Automation Discussions

delete in itab

Former Member — Thu, 15 Mar 2007 12:25:54 GMT

hallow

I wont to now if I have a table

With 5 Colman and I wont to search the Colman and see if I have a record that I don’t wont , delete the record form my internal table delete the row

How can I do that

Ex.

score_itab

Score*weight*tttt**fff

1******22*******2***7

2 ******23******2***4

3 ******24*******2 ***5

4 ******25******2***4

the astrick is just for the ex.

If I wont to delete from my internal table score that have number 3 and wight 24 just that (i wont to keep the num 2 and 5 in ttt and fff)

How can I do that , I wont to do a search on my and loop and

if wa_itab_score ='3'

delete wa_itab_score and wa_itab_weight

i dont wont to buield new colman

regards

Re: delete in itab

Former Member — Thu, 15 Mar 2007 12:29:05 GMT

Hello Antonio,

DO like this


DELETE TABLE score_itab where not num in ( '2', '5') and 
                                                   not weight in ( '24'....)

Hope this will solve ur problem.

Regards,

Vasanth

Re: delete in itab

Former Member — Thu, 15 Mar 2007 12:29:18 GMT


DELETE score_itab WHERE score eq '3' AND weight eq '24'.

You better put 3 and 24 inside variables -;)

Greetings,

Blag.

Re: delete in itab

Former Member — Thu, 15 Mar 2007 12:32:58 GMT

hi dear

U r question is very good

loop at <itaB> INTO <WA>

CHECK WA-SCORE = 3 AND WA-WEIGHT = 24

CLEAR: WA-SCORE , WA-WEIGHT .

MODIFY ITAB BY WA TRANSPORTING SCORE WEIGHT.

ENDLOOP.

**Please reward suitable points***

With Regards

Navin Khedikar

Re: delete in itab

Former Member — Thu, 15 Mar 2007 14:15:24 GMT

Score*weight*tttt**fff

1******22*******2***7

2 ******23******2***4

3 ******24*******2 ***5

4 ******25******2***4

You can't modify the table if Score and Weight are primary keys.

So store the entire record in a field string

then delete the record from the table

Now change Number(Score and Weight) to initials i.e to blanks(so Make these fields as character type)

Then Number and Weight are spaces i.e; no dat -> deleted

reward if useful