topic Re: Comparing two Internal tables in Application Development and Automation Discussions

Comparing two Internal tables

Former Member — Thu, 12 May 2016 08:49:58 GMT

Hi Team,

Is it possible to delete the entries from two internal tables which are same with out using loop.Please suggest solution.

Note: Loop is causing performance pb.

Internal Table1 Internal Table2 Result required

Field1 Field1

A A C

B B D

Thanks and Regards,

Uma

Re: Comparing two Internal tables

chabbi_mustapha — Thu, 12 May 2016 09:02:29 GMT

Hello ,

You can you DELETE instruction in ABAP on internal table , you can see more details using the ABAP documentation , you just click on the instruction and press F1,

Hope this will be useful,

Regards

Re: Comparing two Internal tables

Former Member — Thu, 12 May 2016 09:17:06 GMT

Hi team,

Can any one suggest solution to the above issue.

Thanks and Regards,

Uma

Re: Comparing two Internal tables

Former Member — Thu, 12 May 2016 09:25:14 GMT

hi,

how do you intend to compare without using loops.

Re: Comparing two Internal tables

Former Member — Thu, 12 May 2016 09:28:12 GMT

Hi Abhishek,

I understand with out using Loop very difficult,but still I am searching for an alternate solution.If I am using loop program taking 8 hours to complete which contains more data.

Thanks and Reagrds,

Uma

Re: Comparing two Internal tables

Former Member — Thu, 12 May 2016 09:33:08 GMT

You could have used an inner join if they were physical tables, but with internal tables loop is the only option.

Regards,

Anupama

Re: Comparing two Internal tables

jay_kumar8 — Thu, 12 May 2016 09:37:16 GMT

Hi ,

you can do one thing.

Build range internal table and append entries of table 2.

then delete table 1 where entries in range table in one shot.

Regards

Raj

Re: Comparing two Internal tables

PeterJonker — Thu, 12 May 2016 09:49:01 GMT

Did you use binary search when comparing the tables ?

sort InternalTable1 by field1.

sort InternalTable2 by field 1.

* if there could be more of the same entries in the tables, then first make sure only 1 is left.

delete adjacent duplicates from internalTable1 comparing field1.

delete adjacent duplicates from internalTable2 comparing field1.

loop at InternalTable1 assigning <workarea>.

read internalTable2 with key field1 = <workarea>-field1 binary search.

if sy-subrc = 0.

delete internalTable2 index sy-tabix.

clear <workarea>-field1. "to be able to delete this entry from the source table after the loop.

endif.

endloop.

delete internalTable1 where field1 is initial.

Re: Comparing two Internal tables

jay_kumar8 — Thu, 12 May 2016 09:51:37 GMT

Hi,

Have you tried the Range table concept which I mentioned above.

Regards

Raj

Re: Comparing two Internal tables

pranay570708 — Thu, 12 May 2016 09:55:37 GMT

You can prepare a range table on field: field1 and then use below syntax:

Delete it_tab1 where field1 in r_fld1.

Re: Comparing two Internal tables

prajeshdesai — Thu, 12 May 2016 10:04:44 GMT

Try below,


SELECT *
   FROM VBRP
   INTO TABLE IST_VBRP
   UP TO 10 ROWS
   WHERE VBELN IN P_VBELN.

SELECT *
   FROM VBRP
   INTO TABLE IST_VBRP1
   UP TO 5 ROWS
   WHERE VBELN IN P_VBELN.

   APPEND LINES OF IST_VBRP1 TO IST_VBRP.

   SORT IST_VBRP BY VBELN.

   DELETE ADJACENT DUPLICATES FROM IST_VBRP COMPARING VBELN.

Hope this helps.

Re: Comparing two Internal tables

Former Member — Thu, 12 May 2016 10:11:25 GMT

Hi,

For comparing the two internal tables,Loop @ the first internal table and read the second internal table with key key and binary search.

Filter the differences in the way you want.

To avoid the performance in looping the internal table, Use Parallel Cursor Method.

I hope this answer will be helpful.

Re: Comparing two Internal tables

pranay570708 — Thu, 12 May 2016 10:14:20 GMT

'Delete adjacent duplicates' statement will keep one copy of duplicate records. But his requirement is to delete all duplicate occurring records.

Re: Comparing two Internal tables

matt — Thu, 12 May 2016 10:17:44 GMT


Peter Jonker wrote:

Did you use binary search when comparing the tables ?
.

Better would be (if possible) to define the internal tables as HASHED or SORTED in the first place. Or put a secondary index on the internal tables.

Binary search is so last millenium.

if you define your internal tables correctly, you should be able to process using loops very efficiently.

Re: Comparing two Internal tables

matt — Thu, 12 May 2016 10:20:33 GMT

Parallel cursor method is so last millenium. If the tables are correctly defined as HASHED or SORTED , or have secondary keys defined on them, then there is no need to use binary search or parallel cursor method.

HASHED and SORTED tables have been around for over 15 years. Secondary keys for over 5. I really don't understand why people persist on using techniques that have been superseded for so long.

Due to the wealth of obsolete advice on this thread, I've marked it as a discussion, not a question. At least that will deter those posting solely for points.

Re: Comparing two Internal tables

PeterJonker — Thu, 12 May 2016 10:54:08 GMT

Not everybody has the luxury to work on the latest release.

Re: Comparing two Internal tables

ThomasZloch — Thu, 12 May 2016 11:05:31 GMT

As long as people don't state their software release in the original post (which happens maybe 1% of the time), one must assume that a somewhat recent release is being used, which would maybe include secondary keys but would certainly include hashed and sorted tables.

Thomas

Re: Comparing two Internal tables

Former Member — Thu, 12 May 2016 11:15:16 GMT

Hi Pranay,

These are single values and not in sequence.Even sequence also I need to loop 50 lakhs records to place in range table.

Please suggest any other way.

Thanks and Regards,

Uma

Re: Comparing two Internal tables

matt — Thu, 12 May 2016 12:09:19 GMT

HASHED and SORTED have been available since 46c...

Re: Comparing two Internal tables

former_member185124 — Fri, 13 May 2016 06:32:11 GMT

HI Uma ,

Try this below syntax.It may be help's u.

Delete <ITAB> where <Condition>