USR21
Zuordnung Benutzername Adressschlüssel
USR21 is an SAP database table in S/4HANA. Zuordnung Benutzername Adressschlüssel. It contains 14 fields. 99 CDS views read from this table.
CDS Views using this table (99)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /BSNAGT/P_USR21 | view | from | USR21 | |
| /SAM4U/BTL_L_USER | view | from | User | |
| A4C_A2G_GHA_SC_OPEN_TRANSPORT | view_entity | inner | Open transport request in repositories | |
| aps_businessuser_ddl | view | from | Business User | |
| Aps_Iam_Bupam_Ddl | view | left_outer | Persons without a user | |
| APS_IAM_MCAU | view | from | IAM: Customer Applications User | |
| aps_user_ddl | 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 | |
| CUAN_CDS_TARGET_GROUP_SRCH | view | left_outer | Search Target Groups | |
| cuan_cpg_team_member_search | view | inner | Campaign Search by Team Member | |
| CUAN_ME_ME_QR_AUTH_USER_SEARCH | view | inner | CUAN_ME_ME_QR_AUTH_USER_SEARCH | |
| CUAN_ME_QR_REUSE_USED_IN | view | left_outer | Messages that use reusable blocks | |
| CUAN_ME_QR_TOOLBOX_BLOCKS | view | left_outer | Toolbox blocks in message design view | |
| CUAN_MKTPL_TEAM_MEMBER_SEARCH | view | inner | Marketing Plan Search by Team Member | |
| CUAN_MKTPL_USR_BY_T_MBR_SEARCH | view | left_outer | Search User by Mktg Plan Team Member | |
| CUAN_MPO_CONSTRAINT_PLAN_SRCH | view | left_outer | DDL SQL View CUAN_MPO_CONS_PL | |
| CUAN_OFFER_MSG_PI_CONT_SEARCH | view | left_outer | Offer Integration in Content Studio | |
| CUAN_PGM_TEAM_MEMBER_SEARCH | view | inner | Marketing Program Assigned Team Member | |
| CUAN_PRED_INITIATIVES | view | left_outer | AT_SR_INITIATIVES | |
| CUAN_PREDICTIVE_MODEL | view | left_outer | AT_SEARCH_PREDICTIVE_MODEL | |
| CUAN_PREDICTIVE_SCENARIO | view | left_outer | AT_SEARCH_PRED_SCENARIO | |
| CUAN_TG_TEAM_MEMBER_SEARCH | view | from | AT_TG_TEAM_MEMBER_SEARCH | |
| CUAN_TG_WITH_NAMES_SEARCH | view | left_outer | AT_SEARCH_TARGET_GROUP_WITH_NAMES | |
| cuan_tpl_team_member_search | view | inner | Campaign Template Search by Team Member | |
| CUAN_USER_BY_INI_TEAM_MEMBER_S | view | left_outer | AT_SEARCH_USER_BY_INITIATIVE_TEAM_MEMBER | |
| cuan_user_search | view | from | User Search | |
| 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_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_Draft_User | view_entity | from | User Name View | |
| 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_MKT_User | view | from | BASIC | User |
| 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_RSAU_UGROUP | view | inner | Cross Client User Group Assignments | |
| 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_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 | Business User Management - SDM helper view for BP001 |
| P_Cfd_User_Name | view | from | wrapper view for usr21 | |
| P_DDMRPController | view_entity | left_outer | BASIC | MRP Controller Details |
| P_EIT_User_Name | view | from | Extensibility Template: User Name | |
| 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 | Private Factsheet - User Name |
| P_UserDefaults | view_entity | left_outer | User Defaults | |
| P_USR02_USR21 | view | left_outer | User from USR02 and USR21 | |
| Rv_P_User | view | from | User | |
| 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 | My Vendor Invoices: Contact | |
| VFCLM_BAM_DDL_USERFULLNAME | view | inner | User full name view |
Fields (14)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | mandt | mandt | |
| KEY | bname | xubname | |
| persnumber | ad_persnum | ||
| addrnumber | ad_addrnum | ||
| kostl | xukostl | ||
| start_menu | xustart | ||
| idadtype | suidadtype | ||
| bpperson | bu_partner_guid | ||
| organization | bu_partner_guid | ||
| responsible | suidresponsible | ||
| techdesc | suidtechdesc | ||
| identity_guid | suid_guid | ||
| template_orgtype | suid_orgtype | ||
| template_orgaddr | ad_addrnum |