comparing tables

[Former Member]

how to compare two tables between 2 systems/servers?

[Former Member]

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...

[Former Member]

Hi

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

[sreeramkumar_madisetty]

Hi

we have to check it manually field by field only.

There is no program/FM for this.

Regards,

Sreeram

[former_member784222]

Hi,

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

regs,

S. Chandra Mouli.

[Former Member]

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

[Former Member]

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