how to fetch data from a tables between two systems

[Former Member]

HI,

i am new to ABAP programming language.. i am developing one report for data mismatch between two systems. can any one help me please i have struck in between the report while calling the RFC function module i am using table KNVK.

in one system they 1000 contact persons where as in another system they are only 300 contact persons in KNVK table

so how to find the data mismatch between two tables.

in knvk table we need to find the consistency based upon the deletion flag set.

can anyone help us

[roberto_forti]

Did you get it?

[DoanManhQuynh]

Its pure logic not about abap coding. Is it not simple to select data from table which have 1k contact and compare with table have 300 contact?

[roberto_forti]

Hi,

Is recommended reading SAP Open SQL documentation as well as how standard, sorted and hashed internal tables are specified/used and read table... with addition Binary Search for some technical scenarios within SAP.

About Legacy systems depends on technology and database. Example: Java, .Net etc., and DB Oracle, DB2 etc.

Regards,