topic Re: Compare table data between 2 systems in Application Development and Automation Discussions

Compare table data between 2 systems

Former Member — Mon, 26 Apr 2010 10:43:35 GMT

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

Re: Compare table data between 2 systems

former_member907073 — Mon, 26 Apr 2010 11:56:53 GMT

FYI

RSTBSERV Compare a contents of a table between clients

Re: Compare table data between 2 systems

Former Member — Tue, 27 Apr 2010 01:02:03 GMT

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

Which system does it exist?

Re: Compare table data between 2 systems

Former Member — Tue, 27 Apr 2010 06:35:33 GMT

T.code :- OY19

Re: Compare table data between 2 systems

Former Member — Tue, 27 Apr 2010 08:45:33 GMT

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?

Re: Compare table data between 2 systems

Former Member — Tue, 03 Nov 2015 05:25:28 GMT

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.