How do I query to get just Firstname, Lastname, and Username

Question: How do I query to get just Firstname, Lastname, and Username for a particular client?

Answer:
Table V_USERNAME in SE16.

Answer:
thanks!

Answer:
Or if you are using a database access toll that can't use views, which is what V_USERNAME is, you can get the same information from the database table USR03, fields BNAME and NAME1

Answer:
USR03 has not been used since version 2.2. the Address management System was introdued by SAP in version 3.0 and replaced the USR03 tables ( yes you may still have data in it but it is not kept up to dat and has been abandoned. there is a function module you can use in your reports to retreive the data from the address management system in the USR03 structure) .

V_USERNAME uses the USR21 link to the ADRP table to get the data you want. there is no ONE table that houses this you have to use a view or look at the two tables.

Answer:
What about table USER_ADDR?

this usually works for me

Answer:
Good catch, John. I didn't know that one but see via looking through OSS notes that this was introduced as of 4.0x. How do you find this type of information in order to stay current?

Answer:
I cut my teeth on version 2.2 and began writing the "missing" ABAPs SAP should have added back then, so some of the "discoveries" were "painful" in addition to an undying need to know what is behind the sceens not what is displayed to the user....