Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to compare data between two tables?

Former Member

‎2007 Sep 28 11:31 AM

0 Kudos
1,482

Hi,

My team is trying to develop a SAP data migration tool (DMT) using ABAP.

One of the functionalities in the DMT is to validate the data in the staging area against the loaded SAP data.

The tables in the stagin area are customer tables (i.e. user-defined tables starting with Y, Z).

How do I compare the data in the staging area against data that are loaded into SAP tables? Are there some built-in SAP functions to do this? Or, are there some better ways of doing this (e.g. instead of comparing against data in the SAP tables, we compare with some INTERNAL tables)?

Any help would be greatly appreciated, thanks!

3 REPLIES 3

Former Member

‎2007 Sep 28 11:36 AM

0 Kudos
122

one of the ways to compare dat ais to bring the data in to internal table s and compare those data using the loop on internal tables.

Former Member

‎2007 Sep 28 11:40 AM

0 Kudos
122

Hi,

The FM BKK_COMPARE_TABLES may give you some ideas.

John

Former Member

‎2007 Sep 28 11:44 AM

0 Kudos
122

Hi Kian,

Use <b>SCMP</b> transaction to compare data between two tables and you can not use this for comparing internal tables.

Thanks,

Vinay