very very urjent comapring two tables delete extra records

62 Views

hi experts,

this is very very urjent issue can u please provide logic.

1. i am having two tables kondd and kotd001.

2. here kondd table having 27 records and kotd001 having 16 records.

3. the issue is what ever extra records(27-16=6) 6 diff records should be delete

in the table kondd and deleted records(6) should be display in list.

4. deleted records download in application sever and presentation server

5. both tables should be equal records(16).

can u please solve this issue.

REPORT ZCONDITION.

tables: kondd,kotd001.

types: BEGIN OF T_KONDD, 27

KNUMH TYPE KONDD-KNUMH, "key field

SMATN TYPE KONDD-SMATN,

MEINS TYPE KONDD-MEINS,

SUGRD TYPE KONDD-SUGRD,

PSDSP TYPE KONDD-PSDSP,

LSTACS TYPE KONDD-LSTACS,

END OF T_KONDD.

types: BEGIN OF T_KOTD001, 16

KAPPL TYPE KOTD001-KAPPL,

KSCHL TYPE KOTD001-KSCHL,

MATWA TYPE KOTD001-MATWA,

DATBI TYPE KOTD001-DATBI,

DATAB TYPE KOTD001-DATAB,

KNUMH TYPE KOTD001-KNUMH,

END OF T_KOTD001.