topic Re: Compare two internal tables in Application Development and Automation Discussions

Compare two internal tables

Former Member — Thu, 21 Dec 2006 01:20:36 GMT

Iam having two internal tables

data: begin of itab,

matnr like mara-matnr,

maktx like makt-maktx,

charg like mch1-charg,

end of itab.

data: itab1 like itab occurs 0 with header line,

itab2 like itab occurs 0 with header line,

data:begin of jtab,

matnr like mara-matnr,

charg like makt-charg,

end of jtab.

data: itab3 like jtab occurs 0 with header line,

itab4 like jtab occurs 0 with header line.

<b>[ both itab1 and itab3 contains records.they can be different or same records. now i have compare both the tables with matnr and charg.For one matnr number we can have multiple charg numbers.

1.when compared if the record is found in itab1 and not in itab3 then we have to pull out that record into itab2.

2.if the record is not found in itab1 and found in itab3 then we have to pull that record into itab4

3. if they are same nothing to be done.]</b>

CAN ANY ONE POST WITH EXAMPLE.

Re: Compare two internal tables

RichHeilman — Thu, 21 Dec 2006 01:30:55 GMT

First loop at itab1 and read against itab3. Then reverse it.


Loop at itab1.
   
   read table itab3 with key matnr = itab1-matnr
                                       charg = itab1-charg.
   if sy-subrc <> 0.
     append itab1 to itab2.
   endif.

endloop.

Loop at itab3.
   
   read table itab1 with key matnr = itab3-matnr
                                       charg = itab3-charg.
   if sy-subrc <> 0.
     append itab3 to itab4.
   endif.

endloop.

Regards,

RIch Heilman

Re: Compare two internal tables

Former Member — Thu, 21 Dec 2006 02:36:38 GMT

Is there any function module which can compare two internal tables

Re: Compare two internal tables

Former Member — Thu, 21 Dec 2006 03:00:34 GMT

I don't think there are any function modules that can compare two tables.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: Compare two internal tables

Former Member — Thu, 21 Dec 2006 03:44:18 GMT

Hi satya,

sort : itab1 by matnr charg,

itab3 by matnr charg.

Loop at itab1.

read table itab3 with key matnr = itab1-matnr

charg = itab1-charg bynary search.

if sy-subrc <> 0.

append itab1 to itab2.

clear itab2.

endif.

endloop.

Loop at itab3.

read table itab1 with key matnr = itab3-matnr

charg = itab3-charg bynary search.

if sy-subrc <> 0.

append itab3 to itab4.

clear itab4.

endif.

endloop.

Pls. reward points for useful answers.

Re: Compare two internal tables

Former Member — Thu, 21 Dec 2006 04:02:02 GMT

you can try like this.

loop at itab1.

read table itab3 with key matnr = itab1-matnr charg = itab1-charg.

if sy-subrc ne 0.

move-corresponding itab1 to itab2.

append itab2.

else.

delete itab3 index sy-tabix.

endif.

endloop.

append lines of itab3 to itab4.

regards

shiba dutta

Re: Compare two internal tables

Former Member — Thu, 21 Dec 2006 18:14:27 GMT

SOLVED

Re: Compare two internal tables

former_member518598 — Tue, 18 Jan 2011 10:49:28 GMT

Hello

CTVB_COMPARE_TABLES --- function module to compare tables

Here u should give 2 internal tables as input and 3 as output

Inputs: comparing tables

Output: modifications/changes, Additions and error tables