topic Re: DELETE rows internal table from interal table in Application Development and Automation Discussions

DELETE rows internal table from interal table

mark_fryu — Fri, 07 May 2021 09:01:43 GMT

is there any way to delete all rows of an internal table from an internal table?

for example :

DELETE <table1> from <table2> where <table1-field> eq <table2-field>

even without where is fine, I need everything in table2 to delete everything in table1

abo — Fri, 07 May 2021 09:15:48 GMT

Something like this?

mark_fryu — Fri, 07 May 2021 13:08:51 GMT

from the link I did not understand how to do it, can you give me a practical example? thank you

Abinathsiva — Fri, 07 May 2021 13:52:21 GMT

Hi,

one way is looping table2 and delete table1 by comparing table2-field (will affect the performance based on table size.

load table2-field to single selection or equalant one and use

DELETE table1 where field in s_field.