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
Showing results for 
Search instead for 
Did you mean: 

How to compare data between two tables?

Former Member
0 Kudos
1,445

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
0 Kudos
85

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
0 Kudos
85

Hi,

The FM BKK_COMPARE_TABLES may give you some ideas.

John

Former Member
0 Kudos
85

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