Skip to Content
author's profile photo Former Member
Former Member

How to compare data between two tables?

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!

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2007 at 10:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2007 at 10:40 AM

    Hi,

    The FM BKK_COMPARE_TABLES may give you some ideas.

    John

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2007 at 10:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded