USR21

Transparent Table Application Table
14 Fields 88 CDS Views

User Name/Address Key Assignment

USR21 is an SAP database table in S/4HANA. User Name/Address Key Assignment. It contains 14 fields. 88 CDS views read from this table.

CDS Views using this table (88)

ViewTypeJoinVDMDescription
/BSNAGT/P_USR21 view from USR21
/dmbe/i_User_Description view from Deal User Description
/SAM4U/BTL_L_USER view from User
ARS_V_FLP_USER view from API Snapshot: User
ARS_V_USER view from Wrapper view for USR21
ATOV_COL_USR view_entity from User
ATOV_EXTINV_USER view from Translates technical username
ATOV_USER view from Wrapper view for USR21
ESH_N_USER_USER view from SAP User
FACVD_CLRIT_05 view left_outer Open items of incoming payment for manual clearing
FACVD_CLRIT_06 view left_outer Open items of outgoing payment for manual clearing
Fclm_Bm_Bank_Docu view left_outer Change document for bank
Fclm_Bm_Hbank_Docu view left_outer Create and delete change document for house bank
Fclm_Bm_Hbank_Docu1 view left_outer update change document for house bank
fiscds_adr6_email view inner User Email Data
fiscds_adrp view from User Office Data
fiscds_bkpf_usr view left_outer Line Item Browser: DDL Source
GEN_RESULT_SET_W_O_MEM_COUNT view_entity left_outer Query Result Sets by Elements
GSEG_CDS_BUILDING_BLOCK_SRCH view_entity left_outer Search Building Blocks
GSEG_CDS_SEG_MODEL_SRCH view_entity left_outer Search Segmentation Models
I_ACMCreatedByUser view_entity from BASIC ACM Application Document created by user
I_BusinessUser view_entity inner COMPOSITE Business User
I_BusinessUserBasic view_entity inner BASIC Business User Basic
I_CmmdtyDrvtvOrderUserDetails view from BASIC Basic View for User Details
I_CmmdtyHedgeSpecUserDetails view from BASIC Commodity Hedge Spec User Details
I_DFS_MaintUserDetailsBasic view inner BASIC User Details Basic View
I_Draft_User view_entity from User Name View
I_GHOUserName view from BASIC User Resp for Chg Log of Prodn Ntwk Link
I_HDMUserContactCard view_entity from COMPOSITE User Contact Card
I_LCMUserAddressAssignment view from BASIC User Name/Address Key Assignment
I_MDCloudUserContactCard view_entity from COMPOSITE User Contact Card
I_Mpattachment view inner BASIC Master Project Attachment
I_MRPControllerEmail view left_outer BASIC MRP Controller Email Address
I_PMContactCardUser view from BASIC Contact Card User
I_PrmtHbCreatorContactCard view from BASIC Creator Data for Contact Card
I_RSHMaintScheduleUsers view from BASIC View to return all the user details
I_SADL_GW_CPLUSER view from User details in system
I_SystemUser view inner BASIC System Benutzer
I_TicketChangedByVH view from BASIC Ticket Changed By Value Help
I_TicketCreatedByVH view from BASIC Ticket Created By Value Help
I_TripCreatedByVH view from BASIC Trip created by user value help
I_User view from BASIC User
I_USER_ALL_VALID_F4 view_entity inner SUIM Value Help for all Valid Users
I_USER_F4 view_entity inner SUIM Simple Value Help for Dialog Users
I_UserAddressLink view_entity from BASIC Benutzer: Verknüpfung zur Adresse
I_UserContactCard view from COMPOSITE User Contact Card
I_UserDescription view from BASIC Beschreibung
m_v_m2s_pd_itm view left_outer View for Purchasing Document Item
m_v_m2s_pr_itm view left_outer CDS View for Purchase Requisition
N_SCLG_USER view from CLG: User
P_BPUsrAssignment view_entity inner BASIC Business User - User Assignment
P_BPUsrDetail view_entity from BASIC Business User - User Detail
P_BPUsrEEWASmtpSrch view_entity from BASIC Workplace Address Smtp Srch (BUM)
P_BPUsrEEWASmtpSrchInitial view_entity union_all BASIC Workplace Address SmtpSrch Initial (BUM)
P_BPUsrEEWASmtpSrchInitial view_entity from BASIC Workplace Address SmtpSrch Initial (BUM)
P_BPUsrEEWASmtpSrchNonUniSub view_entity inner BASIC Workplace Address SmtpSrch NonUnique SV
P_BUPA_BPU_BP001 view left_outer BASIC
P_Cfd_User_Name view from wrapper view for usr21
P_DDMRPController view left_outer BASIC
P_EIT_User_Name view from Extensibility Template: User Name
P_ON_DEMAND_PRICE_ORDER view left_outer BASIC
P_REASON_CODE_TRACE view left_outer BASIC
P_SBPM_EXT_BLD_USER view_entity from BASIC SAP Build Extensibility: User
P_Scbo_User view from User
P_SMTR_USERNAME view from Username
P_USER_ADDR view inner BASIC F4 Suchhilfe für Benutzer
P_USER_ADDR_EMAIL view inner BASIC F4 Search Help for Email Addresses
P_UserAddress view inner BASIC Allgemeiner CDS View für Adresse
P_Usercontactcard_Fs view from BASIC
P_UserDefaults view_entity left_outer User Defaults
P_USR02_USR21 view left_outer User from USR02 and USR21
Rv_P_User view from
S_Ccl_User view from Custom Code List User View
S_SCME_USER view from CME: User view
S_SCRL_User view from Wrapper view for usr21
SACMRT_ASPECT_USER_EXT view_entity from ACM RT: Aspect User Extensions
SAIS_USER_F4 view_entity inner BC-SEC Value Help for Users
SUIM_CHDOC_USR_CURR_ADR view_entity from SUIM|Current Address for UserID
SUIM_US_DOCU view_entity left_outer SUIM | Get User Documentation List
SUIM_USR_CURR_ADR view_entity from SUIM|Current Address for UserID
Swx_Sddl_Address view from Workflow Demo: User Address (CDS)
TSI_CONTACT_entry view from
VFCLM_BAM_DDL_USERFULLNAME view inner User full name view
VFCP_DDL_BCM view left_outer
VFCP_DDL_FI view inner
VFCP_DDL_MEMO view left_outer
VFCP_DDL_MEMO_BASE view left_outer
VFCP_DDL_TRM view left_outer

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bname XUBNAME User
persnumber AD_PERSNUM Person Number
addrnumber AD_ADDRNUM Address Number
kostl XUKOSTL Cost center
start_menu XUSTART Start menu
idadtype SUIDADTYPE Identity Add. Type
bpperson BU_PARTNER_GUID BP GUID
organization BU_PARTNER_GUID BP GUID
responsible SUIDRESPONSIBLE Responsible
techdesc SUIDTECHDESC Description
identity_guid SUID_GUID Identity GUID
template_orgtype SUID_ORGTYPE Organization Type
template_orgaddr AD_ADDRNUM Address Number

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- User Name/Address Key Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USR21 (
    MANDT,             -- Client [MANDT]
    BNAME,             -- User [XUBNAME]
    PERSNUMBER,        -- Person Number [AD_PERSNUM]
    ADDRNUMBER,        -- Address Number [AD_ADDRNUM]
    KOSTL,             -- Cost center [XUKOSTL]
    START_MENU,        -- Start menu [XUSTART]
    IDADTYPE,          -- Identity Add. Type [SUIDADTYPE]
    BPPERSON,          -- BP GUID [BU_PARTNER_GUID]
    ORGANIZATION,      -- BP GUID [BU_PARTNER_GUID]
    RESPONSIBLE,       -- Responsible [SUIDRESPONSIBLE]
    TECHDESC,          -- Description [SUIDTECHDESC]
    IDENTITY_GUID,     -- Identity GUID [SUID_GUID]
    TEMPLATE_ORGTYPE,  -- Organization Type [SUID_ORGTYPE]
    TEMPLATE_ORGADDR,  -- Address Number [AD_ADDRNUM]
    PRIMARY KEY (MANDT, BNAME)
);

Learn More