Delete internal table rows without using loop statement

[Former Member]

i have an internal table which consists of 100 records.

i need to keep only first 5 records.

without using the loop statement i need to delete the rest of the records. how can we achieve this result.

i.e. delete itab1 where "recordno" > 5.

regards.

ZG

[MarcinPciak]

Hi,

Use

delete table itab from 6.  "delete all data where index > 5

Regards

Marcin

[Former Member]

Hi,

SORT itab BY "field name" DESCENDING.

DELETE itab FROM 6.

Thanks,

[Former Member]

Use as :

delete itab1 from 5.

[Former Member]

Hi,

Delete itab [FROM idx1] [TO idx2] {Where (log_exp)]

To delete several lines at once, you have to specify at least one of the additions FROM, TO, or WHERE. You can only use the additions FROM and TO with standard tables and sorted tables.

Delete itab [FROM idx1]

If you specify FROM, all the table rows from the table index idx1 onwards are included.

Delete itab [TO idx2]

If you specify TO, all the table rows from the table index idx2 onwards are included.

PARAMETERS: p_carrid TYPE sflight-carrid,

p_connid TYPE sflight-connid.

DATA: BEGIN OF seats,

fldate TYPE sflight-fldate,

seatsocc TYPE sflight-seatsocc,

seatsmax TYPE sflight-seatsmax,

seatsfree TYPE sflight-seatsocc,

END OF seats.

DATA seats_tab LIKE STANDARD TABLE OF seats.

SELECT fldate seatsocc seatsmax

FROM sflight

INTO TABLE seats_tab

WHERE carrid = p_carrid AND

connid = p_connid.

LOOP AT seats_tab INTO seats.

seats-seatsfree = seats-seatsmax - seats-seatsocc.

MODIFY seats_tab INDEX sy-tabix FROM seats.

ENDLOOP.

ENDLOOP.

SORT seats_tab BY seatsfree DESCENDING.

DELETE seats_tab FROM 5.

Thanks & Regards,

ShreeMohan

Edited by: ShreeMohan Pugalia on Jul 21, 2009 4:28 PM