Compare table entries within two 2 different system

[former_member814501]

Hi...

I need to fetch tables under particular TR and then store it ... And then I need to fetch and compare table entries of those table from source and destination system both and as a result I need to get extra entries from both the system.......

Basically I need to compare 2 different systems table(source and destination) and get the entries which are not same when compared.

Except rfc_get_table_entries function module

Can anyone help with this ASAP

[Former Member]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.
First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.
I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.
Now for some specific suggestions on how you might improve your question:
* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.
* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.
Should you wish, you can revise your question by selecting Actions, then Edit.
The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. As it stands, I don't know if there is enough information here for members to understand your issue. So please consider revising your question because I'd really like to see you get a solution to your problem!
I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[FredericGirod]

Check transaction SCMP

[Sandra_Rossi]

ishani_reddy

SCMP which maybe calls the program RSCMPADJ, which maybe calls SCT1_GET_DATA.

You may search the Web to see if there are any examples.

[former_member814501]

I want in code

[FredericGirod]

as sandra.rossi said :

SE38 - RSCMPADJ - CTRL + C

open your program, CTRL + V

[Sandra_Rossi]

frdric.girod I think it means please write full program for ishani_reddy. PS: not paid.

[abo]

and ASAP 🙂

[sanilbhandari]

Hi

The below blog might be useful

https://blogs.sap.com/2012/03/28/how-to-compare-table-content-or-configuration-settings-with-a-remot...

Thanks & Regards

Sanil Bhandari

[keremkoseoglu]

If you need direct database access, you can connect to the remote system via ADBC. There are many tutorials for that subject.

If you need to go over SAP Application Server, you can call the function RFC_READ_TABLE on the remote destination to read database tables.