Skip to Content
0
Former Member
Sep 14, 2005 at 07:29 AM

Duplicate Entries in Internal Tables

398 Views

Hallo Friends,

It Would be nice if some one let me know, if there is a way in ABAP to select the duplicates records in an internal tables.

Lets say I have two internal tabels, itabA have following structure:

BNAME | WORKAREA | ROLES

abc | wa1 | ro1

cde | wa1 | ro1

cde | wa3 | rol..

abc | wa2 | rol2

xyz | wa1 | rol3

xyz | wa3 | rol2..

the itabB have the following structure:

WORKAREA | ROLES|

wa1 | rol1

wa2 | rol1

wa3 | rol1

wa4 | rol1

...

Now problem is, I need to select the common WorkAreas from itabA ( which is commom in all BNAME ) in above example it will be workarea wa1. as it is commom in all i.e ( abc ,cde and xyz). I need to select this commom workarea, and then mark it with some flage in itabB ( to display that this workarea is common among the users...)

Would be nice if some one let me know, is there any way I can select the duplicate rows in an internal table or I have to go one by one and then do some kind of comparision.

Many thanks,

Thx in advance....

Haider