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

Compare two tables

UmaArjunan — Thu, 14 Feb 2008 10:08:05 GMT

Plz let me know if there is any transaction to compare the fields used in two tables or anyother way to do the same.

just to check the guid and partner id

Like we used to compare two programs in the same screen using SE 39

Re: Compare two tables

Former Member — Thu, 14 Feb 2008 10:10:51 GMT

Try the FM

CATSXT_COMPARE_STRUCTURES

CTVB_COMPARE_TABLES

Re: Compare two tables

Former Member — Thu, 14 Feb 2008 10:12:36 GMT

Hi,

We can have one choice that we can compare the contents in 2 internal tables using FM 'CTVB_COMPARE_TABLES'. Just extract the data from those 2 tables and use this function module this will return three internal tables with deleted entries, new entries and modified intries in new table.

Rgds,

Bujji

Re: Compare two tables

Former Member — Thu, 14 Feb 2008 10:14:43 GMT

Try T-Code SCMP or you can go into the specific table you want to compare (SM31) and select "Utilities" then "Comparison"

Thanks

Vasudha

Edited by: Vasudha L on Feb 14, 2008 11:15 AM

Re: Compare two tables

kiran_k8 — Thu, 14 Feb 2008 10:18:20 GMT

Uma,

IF it_1[] = it_2[]. " Tables contents are the same

ELSE.

" Tables contents are different

ENDIF.

If they have different structure, loop one of the tables, and then read the other in the loop, then compare field by field.

Or if you don't need the contents (just comparing) you can do like this, for example:

LOOP AT it_1 INTO wa_1.

READ TABLE it_2 WITH KEY field2 = wa_1-field2

field5 = wa_1-field5

TRANSPORTING NO FIELDS.

IF sy-subrc = 0.

Records are in both the tables (field2 and field5 are the fields which are common in both tables).

ENDIF.

ENDLOOP.

K.Kiran.

Re: Compare two tables

UmaArjunan — Thu, 14 Feb 2008 12:25:45 GMT

friends,

when i try to execute the FM CTVB_COMPARE_TABLES . i got the following error message.

I want to compare the fields used in two differeent tables..

and not the contents.

Thanks for all ur answers.

Error generating the test frame

Message no. FL819

Diagnosis

The system could not generate a syntactically correct test frame for function module CTVB_COMPARE_TABLES. You therefore cannot test the function module using the test environment. You have probably used an ABAP feature in the interface definition that is not yet supported in the test environment.

The error message is:

"ANY TABLE" expected, not "STANDARD TABLE".

System Response

Procedure

Check whether you can change the interface of the function module so that it is possible to generate the test frame. If this is not possible,you will have to write your own utility for testing the function module.

Procedure for System Administration

Re: Compare two tables

Former Member — Thu, 19 Jun 2008 08:58:19 GMT

Sorry,

I have the problem with function "CTVB_COMPARE_TABLES" that when I have "STRING"-Fields in my table, then it produce a shortdump ASSIGN_CASTING_ILLEGAL_CAST in include LBUSSF00.

(line 95)

**....Prepare key for selection.........................................

<b> **assign <lfs_table_old> to <lfs_table_x> casting. "UNICODE!**</b>

assign <lfs_table_x>(key_length) to <lfs_table_key> casting.

**....Select corresponding record in new table if it is changed.........

WHAT CAN I DO?

Re: Compare two tables

lucdealethea — Tue, 07 Jan 2020 12:09:35 GMT

DDIC tables and views:

Goto SE16 using view DD03VV and specify the two tables you want to compare in selection field TABNAME, then sort by FIELDNAME.

Re: Compare two tables

FredericGirod — Tue, 07 Jan 2020 12:32:02 GMT

You have answered a 12 years old question

Re: Compare two tables

former_member614707 — Fri, 21 Aug 2020 10:29:36 GMT

Thanks Luc, your answer on 12 years old question was helpful to me.