topic Re: How to compare data between two tables? in Application Development and Automation Discussions

How to compare data between two tables?

Former Member — Fri, 28 Sep 2007 10:31:47 GMT

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!

Re: How to compare data between two tables?

Former Member — Fri, 28 Sep 2007 10:36:11 GMT

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.

Re: How to compare data between two tables?

Former Member — Fri, 28 Sep 2007 10:40:42 GMT

Hi,

The FM BKK_COMPARE_TABLES may give you some ideas.

John

Re: How to compare data between two tables?

Former Member — Fri, 28 Sep 2007 10:44:10 GMT

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