Compare Tables

[Former Member]

Hi,

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

[Former Member]

Hi,

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi

Try transaction... SCMP

Regards,

Arun

[Former Member]

hi

good

Try the FM

CATSXT_COMPARE_STRUCTURES

CTVB_COMPARE_TABLES

thanks

mrutyun^

[Former Member]

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

[Former Member]

Thanks Balaji & Arun for information

[Former Member]

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.