topic Re: compare 2 itab in Application Development and Automation Discussions

compare 2 itab

Former Member — Thu, 06 Dec 2007 07:47:51 GMT

hi.

Iam having 2 itab's, and i want to compare this 2 itab.

itab1 and itab2 is a structure of CAUFVD ( so approx 300 fields).

itab1 consist of old values and itab2 consist of new values. when iam comapring this two tables the fields the difference should be stored in a new table.

SO is there any function module for this.........

Thanking you.

regards.

Re: compare 2 itab

Former Member — Thu, 06 Dec 2007 07:50:59 GMT

Hi!

Try out this one:

CTVB_COMPARE_TABLES

However I think you might code it faster with a line-by-line comparison, within a LOOP.

Regards

Tamá

Re: compare 2 itab

Former Member — Thu, 06 Dec 2007 07:53:55 GMT

<b>IF itab2[] NE itab1[].

"Records are different

ENDIF.</b>

Re: compare 2 itab

Former Member — Thu, 06 Dec 2007 07:56:49 GMT

Hi Hemant

I am not sure about FM , but you can write a code , which compares line by line and if sy-subrc fails then move the record to internal table which is having similar structure as that of itab1 or 2

Regards

Hemant

Re: compare 2 itab

Former Member — Thu, 06 Dec 2007 08:26:39 GMT

hi,

try this code.

i had a similar application and this code worked fine.

loop at itab1.

read table itab2 with key...(fields which uniquely identify records like - field1 = itab1-field1...).

if sy-subrc <> 0.

move itab1 to itab_new.

append itab_new.

clear itab_new.

endif.

clear itab1.

clear itab2.

endloop.

itab2 is old table and itab1 contains some new/changed values.

hope this gives u some idea.

Re: compare 2 itab

kesavadas_thekkillath — Thu, 06 Dec 2007 08:32:17 GMT

sort itab1 by key fields.

Loop at itab1.

read table itab2 with key field.

if sy-subrc <> 0.

append itab1 to new_itab.

endif.

endloop.

hope thi helps you..

Re: compare 2 itab

Former Member — Thu, 06 Dec 2007 08:40:01 GMT

but my itab consist of 411 fields (columns) so how to comapre each fields.......is a structure of (CAUFVDB)

Re: compare 2 itab

Former Member — Thu, 06 Dec 2007 09:32:36 GMT

don't take all columns only those columns which identify each record...like primary key ...

Re: compare 2 itab

Former Member — Thu, 06 Dec 2007 09:42:08 GMT

HI,

U can take a temp. table and add rows which u need to compare which are from different tables.

then use DELETE ITAB COMPARING ALL FIELDS.

then describe table temp. if it has one row then fileds are same else they are different.

Re: compare 2 itab

Former Member — Mon, 02 Mar 2009 10:42:51 GMT

Thanks