topic Re: Compare Tables in Application Development and Automation Discussions

Compare Tables

Former Member — Fri, 07 Mar 2008 03:20:18 GMT

Hi,

How to compare the same table table between two different clients?

Re: Compare Tables

Former Member — Fri, 07 Mar 2008 03:55:39 GMT

The table definition will be the same in both the clients. Only the underlying data changes in the two clients.

reward if it helps..

Thanks

krishna

Re: Compare Tables

Former Member — Fri, 07 Mar 2008 05:13:29 GMT

Hi,

In sap that u can't do, if u want to compare anyhow then just download to excel then compare.

any how in the two clients the structure is same for the tables but records are vary.

seshu.

Re: Compare Tables

Former Member — Fri, 07 Mar 2008 06:32:47 GMT

Hi Sourav,

Try logging into the underlying database. There look for the table you want to compare the data. Data belonging to all the clients can be viewed from this DB table. From here you can compare each and every clients data.

Reward if helpful.

Re: Compare Tables

Former Member — Fri, 07 Mar 2008 06:37:38 GMT

Try transaction... SCMP

Regards,

Arun

Re: Compare Tables

Former Member — Fri, 07 Mar 2008 13:21:49 GMT

good

Try the FM

CATSXT_COMPARE_STRUCTURES

CTVB_COMPARE_TABLES

thanks

mrutyun^

Re: Compare Tables

Former Member — Fri, 07 Mar 2008 17:43:53 GMT

The table definition will be the same in both the clients... so only data in the table across the 2 clients can be compared.

For comparing data in a custom across 2 clients,

Try OY19.

This works for Complete Table comparison or with a Full Key specified comparison only. If we try to compare using Partial key specification, it does not work. Also We cannot specify ranges or multiple key values in this transaction for comparison.

if OY19 does not suit your requirement try transaction SCMP.

Hope this helps.

Reward points for all helpful answers.

Thanks,

Balaji

Re: Compare Tables

Former Member — Fri, 26 Dec 2008 23:42:36 GMT

Thanks Balaji & Arun for information

Re: Compare Tables

Former Member — Wed, 31 Dec 2008 17:55:45 GMT

Hi Friend,

You can compare the same table in two different clients by comparing the versions.

GOTO -- Utilities -

Version -

Version Management------Remote comparison then see the client.

This way you can compare the same table between two clients.

Regards,

MD ZIAUDDIN.