topic Re: Comapre tables between to differnt systems in Application Development and Automation Discussions

Comapre tables between to differnt systems

Former Member — Wed, 14 Dec 2005 20:27:13 GMT

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

Re: Comapre tables between to differnt systems

Former Member — Wed, 14 Dec 2005 21:15:29 GMT

Hi,

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

Prameters for thsi T.code is:

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

R/3 Conection:: 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

Re: Comapre tables between to differnt systems

Former Member — Wed, 14 Dec 2005 22:01:45 GMT

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

Re: Comapre tables between to differnt systems

Former Member — Wed, 14 Dec 2005 22:27:18 GMT

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

Re: Comapre tables between to differnt systems

Former Member — Wed, 14 Dec 2005 22:33:09 GMT

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?

Re: Comapre tables between to differnt systems

andreas_mann3 — Thu, 15 Dec 2005 06:40:46 GMT

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

Re: Comapre tables between to differnt systems

Former Member — Sun, 18 Dec 2005 16:18:01 GMT

Hi,

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

Thanks,

Naga