topic Re: Delete entries from one internal table comparing another without loop. in Application Development and Automation Discussions

Delete entries from one internal table comparing another without loop.

former_member651928 — Mon, 18 Jan 2021 10:29:42 GMT

Hi All,

Is there any way, we can remove entries of one table comparing the entries from another?

For Example.

Table 1 (Ref)

DATA 1

DATA 2

DATA 3

DATA 4

Table 2 (Main)

DATA 2

DATA 3

My requirement is to remove the entry DATA 2 and DATA 3 from Table 1, with out using loop .

Is there any 7.4 based queries?

Thanks in Advance.

Re: Delete entries from one internal table comparing another without loop.

abo — Mon, 18 Jan 2021 10:40:08 GMT

You mean using FILTER ?

Re: Delete entries from one internal table comparing another without loop.

pfefferf — Mon, 18 Jan 2021 10:40:31 GMT

You can use a FILTER expression using a filter table.

Re: Delete entries from one internal table comparing another without loop.

former_member651928 — Mon, 18 Jan 2021 10:47:02 GMT

Yes Andrea, can we achieve using Filter?

Re: Delete entries from one internal table comparing another without loop.

former_member651928 — Mon, 18 Jan 2021 10:47:31 GMT

Thanks Florian, let me try.

Re: Delete entries from one internal table comparing another without loop.

former_member653925 — Mon, 18 Jan 2021 10:52:19 GMT


table1 TYPE SORTED TABLE OF XXX WITH UNIQUE KEY key1 key2 ....
SORT table1 BY key1.

LOOP AT table2 assigning field-symbol(<ls_table2>).
DELETE table1 WHERE key1 = <ls_table2>-key (key2 = <ls_table2>-key2) ....
ENDLOOP.

why don't you go for that? Would it not be the quickest way and most performant one?

Correct me if I am wrong 🙂

did anyone tracked the performance of filter?

Re: Delete entries from one internal table comparing another without loop.

abo — Mon, 18 Jan 2021 10:52:25 GMT

Sure, here is an example

Re: Delete entries from one internal table comparing another without loop.

former_member651928 — Mon, 18 Jan 2021 10:57:05 GMT

Thanks Igor, Agreed.

I was concerned about the performance, as we were querying on millions of data.

And am currently inside a child program -> loop -> perform - (here) - wanted to remove the loop here.

Re: Delete entries from one internal table comparing another without loop.

former_member653925 — Mon, 18 Jan 2021 11:02:18 GMT

is it not possible to reduce outside the first loop?

For me, ofter it is tough to find the real root for the problem. Sometimes it can be already solved before it comes to the complicated, logical part 🙂

Re: Delete entries from one internal table comparing another without loop.

former_member651928 — Mon, 18 Jan 2021 11:04:52 GMT

I will definitely try that.

Thanks for your time in helping.

Re: Delete entries from one internal table comparing another without loop.

former_member651928 — Mon, 18 Jan 2021 11:12:01 GMT

Thanks Andrea.

I think that will do the job.

Really appreciate your time.