– usuarios que no tienen un rol
select BNAME
from p01.USR01
where MANDT = ’300′
and BNAME not in (
select UNAME
from p01.AGR_USERS
where MANDT = ’300′
and AGR_NAME = ‘ZCD_EXTRAS_COMUNES’)
order by 1
select BNAME
from p01.USR01
where MANDT = ’300′
and BNAME not in (
select UNAME
from p01.AGR_USERS
where MANDT = ’300′
and AGR_NAME = ‘ZCD_EXTRAS_COMUNES’)
order by 1