Delete table records

[Former Member]

Is it possible to loop through a table, examine each record and

delete the record if it meets a certain condition, all within the loop?

Like:

field-symbols <fs> like line of mytable.

loop at mytable assigning <fs>.

if <fs>-field_1 = someValue.

delete ......

endif.

endloop

[gopi_narendra]

You can not delete directly from standard SAP tables, there are some predefined tcodes or bapis or procedures to it.

If you are talking abt custom tables ie Z tables, you can do it by using the Delete statement.

Regards

Gopi

[former_member194669]

Hi,

For performance reasons do delete outside of the loop.

field-symbols <fs> like line of mytable.
loop at mytable assigning <fs>.
if <fs>-field_1 = someValue.
  append mytable_1
endif.
endloop

delete ......... from mytable_1

aRs