Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Two table comparisions (logic problem)

Suppose I have a table itab1 with two cols

col1         col2
A            0001
A            0002
A            0004
B            0001
B            0002
B            0003
B            0004

second table itab2 has values

0001

0002

0003

0004

i want to delete all rows from itab1 based on itab 2 which does not hav all the values in itab1 from itab2 based on cl1 n col2 both

e.g in this case only this shud remain

B            0001
B            0002
B            0003
B            0004

Edited by: Karan Chopra on Jun 21, 2010 3:16 PM

Edited by: Karan Chopra on Jun 21, 2010 3:18 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question