topic Re: delete lines from an internal table in Application Development and Automation Discussions

delete lines from an internal table

Former Member — Mon, 22 Sep 2008 10:55:06 GMT

hi all,

i have the data in my internal table as follows:

Workload overview: Average time per step in ms
------------------------------------------------------------------------------------------
| Instance TOTAL First record 08.09.2008 08:25:26 |
| Period 08.09.2008 -14.09.2008 Last record 14.09.2008 23:59:07 |
| Task type All Period 6 Day(s) 15:33:41 |
------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Task Type |# Steps| Ø Time|Ø CPU Time|Ø DB Time|Ø Time|Ø WaitTime|Ø Roll In~|Ø Roll Wait Time|Ø Load- + Gen. Time|Ø LockTime|Ø CPIC/RFC|Ø Time|Ø GUI Time|# Trips| KB|
|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|ALE | 582 | 687,9 | 26,6 | 332,0 | 0,0 | 8,4 | 0,8 | 5,8 |2,0 | 0,3 | 17,5 | 0,0 | 0,0 | 0 | 13.976 |
|AutoABAP | 1.928 |13.534,3 | 542,4 | 862,4 | 0,0 | 22,2 | 3,7 | 0,0 | 40,3 | 2,2 | 7.129,9 | 0,0 | 0,0 | 0 | 486.019 |
|Background |18.414 | 6.376,6 | 412,5 | 4.969,8 | 0,0 | 0,2| 0,0 | 0,0 | 4,4 | 2,9 | 4,4 | 0,0 | 0,0 | 0 |5.945.477 |
|Batch Input | 37 | 3.612,4 | 740,8 | 956,8 | 0,0 | 5,5 | 1,4 | 2.050,5 | 89,6 | 3,5 | 0,0 | 0,0 | 0,0 | 37 | 97.688 |
|Buffer synchr.| 4.824 | 1,6 | 0,8 | 0,7 | 0,0 | 0,1 | 0,0 | 0,0 | 0,0 | 0,0 | 0,0 | 0,0 | 0,0 | 0 | 6 |
|Dialog |20.614 | 1.706,5 | 65,3 | 1.337,3 | 0,0 | 12,3 | 0,4 | 205,8 | 39,2 | 0,1 | 0,1 |144,7 | 220,4 |34.991 |6.360.797 |
|HTTPS | 9.570 | 11,6 | 8,7 | 0,3 | 0,0 | 0,2 | 0,0 | 0,0 |1,0 | 0,0 | 0,0 | 0,0 | 0,0 | 0 | 3.352 |

Re: delete lines from an internal table

Former Member — Mon, 22 Sep 2008 10:56:35 GMT

What do you want to delete from Internal table?

Re: delete lines from an internal table

Former Member — Mon, 22 Sep 2008 10:57:34 GMT

itab should be internal table with header line.

loop at itab.

delete itab from itab.

endloop.

Re: delete lines from an internal table

Former Member — Mon, 22 Sep 2008 10:59:03 GMT

refresh itab

Re: delete lines from an internal table

Former Member — Mon, 22 Sep 2008 11:00:30 GMT

use any of the statements...

delete from itab where <condition>....

delete from itab index <specify the line item number>....

Using any of this you can get required data into your processing internal table...

Re: delete lines from an internal table

Former Member — Mon, 22 Sep 2008 11:00:55 GMT

hi,

im sorry i forgot to mention the problem.

i want to delete the header lines line

Instance TOTAL First record 08.09.2008 08:25:26

Period 08.09.2008 -14.09.2008 Last record 14.09.2008 23:59:07

Task type All Period 6 Day(s) 15:33:41

please help

Re: delete lines from an internal table

Former Member — Mon, 22 Sep 2008 11:03:24 GMT

read table itab index 1.

delete itab from itab.

Re: delete lines from an internal table

Former Member — Mon, 22 Sep 2008 11:06:16 GMT

Do this way...

do 3 times...

delete itab index 2.

enddo

(or)

delete itab where itab-filed+2(8) = 'Instance'.

delete itab where itab-field+2(6) = 'Period'.

delete itab where itab-field+2(4) = 'Task'.

Re: delete lines from an internal table

valter_oliveira — Mon, 22 Sep 2008 11:07:51 GMT

DELETE itab FROM 2 TO 4. "deletes lines from row 2 to 4

Regards,

Valter Oliveira.

Re: delete lines from an internal table

Former Member — Wed, 07 Jan 2009 09:08:27 GMT

solved