Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to find users with out email-id

Former Member

‎01-12-2010 2:10 PM

0 Kudos

hi Guru's

We have some 8000 users in our system,we would like to pull out all the users who does not have email-id's..

is there any way for this...please let me know..

thnx in advance

3 REPLIES 3

jurjen_heeck
Active Contributor

‎01-12-2010 2:15 PM

0 Kudos

If you know your way around SQVI you can try a join between tables USR21 and ADR6, joined on PERSNUMBER, selecting records where ADR6.SMTP_ADDR = NULL.

Former Member
In response to jurjen_heeck

‎01-12-2010 4:18 PM

0 Kudos

...and to maintain the email addresses (if you have standard conventions) you can try using the program RSADRCK7

mvoros
Active Contributor
In response to jurjen_heeck

‎01-12-2010 10:49 PM

0 Kudos

Hi,

actually, you can use this report to pull that list. If you tick option Keep existing addresses and Test mode then the report will generate a list of all users without email address. Unfortunately, it does not use ALV.

Cheers