topic Re: Delete table records in Application Development and Automation Discussions

Delete table records

Former Member — Fri, 31 Aug 2007 01:13:12 GMT

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

Re: Delete table records

gopi_narendra — Fri, 31 Aug 2007 01:21:30 GMT

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

Re: Delete table records

former_member194669 — Fri, 31 Aug 2007 01:26:45 GMT

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