Problem mit IN Klausel in SELECT Anweisung

Code: Alles auswählen.

SELECT group
  FROM group_map
  INTO CORRESPONDING FIELDS OF TABLE group_tab
  WHERE group NOT IN (
    SELECT group
    FROM group_map
    WHERE role NOT
   IN user_roles-name
  ).

Code: Alles auswählen.

DATA: range_user_roles LIKE RANGE OF userl_roles-name.

SELECT group
  FROM group_map
  INTO CORRESPONDING FIELDS OF TABLE group_tab
  WHERE role IN range_user_roles 
  ).

Code: Alles auswählen.

SELECT group
  FROM group_map
  INTO CORRESPONDING FIELDS OF TABLE group_tab
  FOR ALL ENTRIES IN user_roles
  WHERE role = user_roles-name 
  ).

Code: Alles auswählen.

group_map
------------------------
|Gruppe   |Rolle       |
------------------------  
|Sportler |Springen    |
|Sportler |Werfen      |
|Aufsicht |Pfeifen     |
|Gast     |Anfeuern    |
------------------------

user_role
--------------
|Rolle       |
--------------  
|Anfeuern    |
|Werfen      |
--------------