topic Re: comparing tables in Application Development and Automation Discussions

comparing tables

Former Member — Wed, 09 May 2007 06:23:58 GMT

how to compare two tables between 2 systems/servers?

Re: comparing tables

Former Member — Wed, 09 May 2007 10:21:33 GMT

Make a function module in the sap system, set attributes to 'remote-enabled', make sure that it puts the content of your table in the export parameters, and call the FM from other system... In the other system, compare table content...

Re: comparing tables

Former Member — Wed, 09 May 2007 10:26:39 GMT

There is no ready made program/fun module for this purpose.

Manully/physically you have to check for this.

other wise get the data of the same table from other/second system using RFC fun module

and write a small program, fetch the data of that table in first system and compare.

Reward points if useful

Regards

Anji

Re: comparing tables

sreeramkumar_madisetty — Wed, 09 May 2007 10:29:06 GMT

we have to check it manually field by field only.

There is no program/FM for this.

Regards,

Sreeram

Re: comparing tables

former_member784222 — Wed, 09 May 2007 10:29:53 GMT

Hi,

Use fm RFC_READ_TABLE to get records. Make sure that you have sm59 entries for RFC connection.

regs,

S. Chandra Mouli.

Re: comparing tables

Former Member — Wed, 09 May 2007 10:34:00 GMT

Hi Balu,

Create a FM for that and make that as remoty enabled.so that u could call the FM as RFC in other server/system.

In source code of FM write query for fetching data of the table.

make Import & table parameters as PASS BY VALUE.

Now call this FM in other system Using destination to first server.

create destination in SM59 and pass the IP address of first server there.

syntax:

call function 'FM Name'

destination 'ser1'

exporting

..........

importing

............

exceptions

...............

Reward points if helpful.

Regards,

Hemant

Re: comparing tables

Former Member — Wed, 09 May 2007 10:35:49 GMT

Start transaction OY19

Choose Manual selection

Enter the name of the table that you want to compare

Choose Execute

in the next screen you have to give the description and RFC connection name which will make the link between two clients...

regards

shiba dutta