Compare table data between 2 systems

[Former Member]

Hi All.

I know there is a standard SAP transaction SCMP to compare table between 2 systems. But this uses RFC connection.

Is there any such way or transaction wherein we can upload the data from other system, and then compare?

Anyone faced and solved such requirement before?

Thanks in adv.

Aishi

[former_member907073]

FYI

RSTBSERV Compare a contents of a table between clients

[Former Member]

I cannot see this program either in 4.6c or in Netweaver 7.0.

Which system does it exist?

[Former Member]

T.code :- OY19

[Former Member]

Well, I am aware of SCU0, OY19 and SCMP. But they all require RFC connection.

My systems are not physically connected.

I saw 2 programs in 4.6c -> RSKEYS00 and RSTAB00.

But they only show overview of differences, not details. Further SAP has removed these programs in ECC versions.

Any other inputs please?

[Former Member]

I think that. To compare data of two systems is mandatory one RFC connection or access to databases.

Other inputs? yes.

1.- One program. for example. Download manually tables and this program reads files and compare.

2.- Download tables, open excel and concatenate al fields. Then you can add on the right of both columns with column with value found. Then you make vlookup from tableSystemA to tableSystemB and tableSystemB to tableSystemaA.