Skip to Content
Former Member
Jul 19, 2005 at 05:55 PM

Need User Address data but USR03 entries doesnt seem good.



SAP 4.6B,Oracle 8.1.7 , AIX 5.2

I have a need to list all users with address data such as full name and cost center details for all users. This should be done at oracle level. Table USR01 gives me the list of users but when i write a script to give me the list of users in USR01 and their corresponding valid address details from USR03, it gives me very few hits.

For eg USR01 has 300 entries and USR03 has 650 entries, but the script gives a hit of only 50 entries.

Would appreciate if any one could give me some pointers on how to get this done.

It has to be at an oracle level, and i have to write unix scripts to mail these to certain ppl. The scripting part of unix i'm aware of. Need help with the sqlscript.