How do you get the first and last name of multiple users at once?

Solution:

Use the table USER_ADDR to get the First name and the last name of multiple users.

The USER_ADDR table in SAP is a central transparent table used to store Address Data for Users. While basic user logon data is kept in the USR02 table, the more “human-readable” details—like the user’s full name, office location, and contact information—are stored here.

In modern SAP systems (specifically those using Business Address Services or BAS), this table serves as a bridge between the User ID and the more complex address management tables.

Key Fields and Structure

The table links a specific Username to a unique Address Number.

BNAME: The User Name in the SAP System (the primary key).
PERSNUMBER: The Person Number. This is a crucial link to the BAS tables.
ADDRNUMBER: The Address Number (usually representing the company address assigned to the user).
NAME_TEXT: The full name of the user (concatenated).
DEPARTMENT: The functional department (e.g., “Supply Chain” or “Finance”).
FUNCTION: The user’s job title or role description.

Technical Relationship (The BAS Architecture)

SAP doesn’t store all address details directly in USER_ADDR. Instead, it uses Business Address Services. If you need deep details (like mobile numbers or specific street addresses), you often have to join USER_ADDR with other tables:

ADRP (Person Table): Linked via PERSNUMBER. This contains the granular name components (First Name, Last Name, Title).
ADRC (Address Table): Linked via ADDRNUMBER. This contains the physical city, street, and postal code.
ADR2 / ADR6: These store telephone numbers and email addresses, respectively.

Common Use Cases

Custom Reports: If you are building an ALV report and need to show the “Full Name” of the person who created a document (e.g., ERNAM from VBAK), you join VBAK-ERNAM to USER_ADDR-BNAME.
Workflow Notifications: SAP Business Workflow often pulls the email address by looking up the PERSNUMBER from USER_ADDR to find the corresponding entry in ADR6.
Audit and Compliance: Security consultants use this table to verify that the “Description” or “Name” fields in the user master record are populated correctly for audit trails.
SAP Office/Business Workplace: The internal mailing system uses these address links to route internal messages and manage the organizational hierarchy.

Quick Tip for Queries

If you are using SQVI or OpenSQL, remember that USER_ADDR is generally faster for fetching a user’s full name than trying to join the complex ADRP tables manually, as SAP maintains the NAME_TEXT field in USER_ADDR specifically for ease of access.

Thanks, and Best Regards,

Ganesh Padala