Comapre tables between to differnt systems

[Former Member]

Hi folks,

We have come across a situation. We have migrated from another system . The other system has 200 Z*tables. After extraction of data, we came to know that there is some tables entries missing.

I knew there is function called “RFC_READ_TABLE” , through which we can read the other system tables entries . If we have RFC connection and a valid user and password to access the data on the receiving system.

How we can we compare the entries on both system (source and destination), I mean for 200 Z*tables .And after that we only want to update the entries which are missing in source system .

Please give your input/suggestions.

Thanks

[Former Member]

Hi,

Use the Transaction code <b>SCMP</b> to compare the tables. you need RFC conection for the camparison server client ...

Prameters for thsi T.code is:

<b>View/Table:</b> Please give the Table name which you want to compare

<b>R/3 Conection:</b>: Give the RFC conection name (Use F4)

then there is some option, select the options to meet your requirment.

Hope you get

Regards

Sudheer

Message was edited by: Sudheer Junnuthula

[Former Member]

That’s great, but when i follow the step and see the EDIT - > "Adjust" its "grey" in my system . How can I update the difference?

Thanks

[Former Member]

Hi,

I think you have to get the access or you need to get the Authorization to do this one..

ask your basis people about this one, they will help you out

hope you will get

Regards

Sudheer

[Former Member]

Luckily, I am the basis security guy in this company, and I have full access and when i see Su53. I do not see any authorization object which is missing ...

Looks like it something to do with table settings, which I want to change. What you think?

[andreas_mann3]

Hi Saguib,

1) with maint.-view

use: sm30 - maintain - utilities - adjust - enter rfc connection - mark - adjust

2) other tables: compare internal tables with your fm or

fm TABLE_ENTRIES_GET_VIA_RFC and modify your db-table

regards Andreas

[Former Member]

Hi,

The contents of a table between two systems can be checked through the transaction OY19.

Thanks,

Naga