USR21 is a standard User and Authorization Management Transparent Table in SAP Basis application, which stores Assign user name address key data. On this page, you can view the Table Structure, Columns(Fields), links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Tables, FMs, ABAP Reports, BW Datasources, and Authorization Objects for USR21. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

USR21 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Data Element Primary Key Data Type Length Check Table
    1 MANDT Client MANDT X CLNT 3
    2 BNAME Template name XUBNAME X CHAR 12 USR02
    3 PERSNUMBER Person number AD_PERSNUM CHAR 10 ADRP
    4 ADDRNUMBER Address number AD_ADDRNUM CHAR 10 ADRC
    5 KOSTL Cost Center XUKOSTL CHAR 8
    6 START_MENU Start Menu XUSTART CHAR 30
    7 IDADTYPE Address Type of the Identity SUIDADTYPE NUMC 2
    8 BPPERSON Business Partner GUID BU_PARTNER_GUID RAW 16
    9 ORGANIZATION CPE Caller - Organization BU_PARTNER_GUID RAW 16
    10 RESPONSIBLE Person Responsible SUIDRESPONSIBLE CHAR 12
    11 TECHDESC Description of the Technical User Account SUIDTECHDESC CHAR 80
    12 IDENTITY_GUID GUID of the Identity SUID_GUID RAW 16
    13 TEMPLATE_ORGTYPE Organization Type SUID_ORGTYPE CHAR 1
    14 TEMPLATE_ORGADDR Address number AD_ADDRNUM CHAR 10

SAP Help, Wiki, Q&A and other resources for USR21

Click the above link for the full list of resources and help pages, only the first few are posted below

  • User Tables: Consistency Checks - SAP Help Portal

    This program is available to administrators for checking the consistency of the following tables: Business Workplace tables, SAP user tables, and Business Address Service tables.

    "If the program finds any inconsistencies, the entries in the Business Workplace tables SOUC and SOUD are compared and missing entries can be inserted, existing entries can be modified and obsolete entries can be deleted. This program can only insert missing entries in the SAP user administration tables (USR02 and USR21) and in the Business Address Service tables (ADCP and ADRVP), no entries can be changed or deleted."

    https://help.sap.com/docs/SAP_NETWEAVER_740/180fb1a8df2046829bda0e34a49c6c31/4e394addf59c35a9e10000000a42189c.html

  • Integration of the BAS - SAP Help Portal

    Each user (or office user) has an address of the workplace address type (type 3). This address refers to a company address mapped in the BAS by means of address type 1 (company address).

    https://help.sap.com/docs/SAP_NETWEAVER_740/a10e348e95cd4b679cc727859578c3ac/4e46de5540051550e10000000a421937.html

  • Anbindung der BAS - SAP Help Portal

    Quelltabelle Zieltabelle(n) ...

    https://help.sap.com/viewer/fe2425b86c55101499da8b52f8f96122/7.02.18/de-DE/4e46de5540051550e10000000a421937.html

  • Anwendungstabellen | SAP Help Portal

    Zuordnung Benutzername – Adreßschlüssel (Adreß- u. Personennummer) (ab Release 4.0)

    https://help.sap.com/docs/SAP_NETWEAVER_702/fe2425b86c55101499da8b52f8f96122/4e48160efb95154fe10000000a421937.html?locale=de-DE

  • Anbindung der BAS | SAP Help Portal

    Jeder Benutzer (bzw. Bürobenutzer) besitzt eine Adresse vom Adreßtyp Arbeitsplatzadresse (Typ 3). Diese Adresse verweist auf eine Firmenadresse, die in den BAS über den Adreßtyp Organisationsadresse (Typ 1) abgebildet wird.

    https://help.sap.com/docs/SAP_NETWEAVER_702/fe2425b86c55101499da8b52f8f96122/4e46de5540051550e10000000a421937.html?locale=de-DE

  • Application Tables | SAP Help Portal

    Assignment of user name - address key (address and person number) (as of Release 4.0)

    https://help.sap.com/docs/SAP_NETWEAVER_750/a10e348e95cd4b679cc727859578c3ac/4e48160efb95154fe10000000a421937.html

  • Anwendungstabellen - SAP Help Portal

    Tabelle Bemerkung ...

    https://help.sap.com/viewer/109f72f96c531014bb73cca896fe2521/7.0.33/de-DE/4e48160efb95154fe10000000a421937.html

  • Application Tables - SAP Help Portal

    Table Comment ...

    https://help.sap.com/viewer/109f72f96c531014bb73cca896fe2521/7.0.33/en-US/4e48160efb95154fe10000000a421937.html

  • Output Stream (Output Mode Spool) - SAP Help Portal

    USR03 ...

    https://help.sap.com/viewer/a10e348e95cd4b679cc727859578c3ac/7.51.8/en-US/4e46de5540051550e10000000a421937.html

  • Integration of the BAS | SAP Help Portal

    Each user (or office user) has an address of the workplace address type (type 3). This address refers to a company address mapped in the BAS by means of address type 1 (company address).

    https://help.sap.com/docs/SAP_NETWEAVER_AS_ABAP_FOR_SOH_740/a10e348e95cd4b679cc727859578c3ac/4e46de5540051550e10000000a421937.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for USR21


Related Tables

TABLE Description Functional Area
ADR6 E-Mail Addresses (Business Address Services) Basis - Address Management/Business Address
ADRP Persons (Business Address Services) Basis - Address Management/Business Address
USR02 Logon Data (Kernel-Side Use) Basis - Authentication and SSO
USR03 User address data Basis - User and Authorization Management
ADCP Person/Address Assignment (Business Address Services) Basis - Address Management/Business Address

Transaction Codes for SAP Table USR21

TCODE Description Functional Area
SU01 User Maintenance Basis - User and Authorization Management
SOUD BCS: User Management Basis - Use Subcomponents
BC01 Business Partner: Form of Address S - Geschäftspartner S
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SE38 ABAP Editor Basis - ABAP Editor
SQVI QuickViewer Basis - SAP Query

FMs for SAP Table USR21

FM Description Functional Area
BAPI_USER_GET_DETAIL Read User Details Basis - User and Authorization Management
SO_NEW_DOCUMENT_ATT_SEND_API1 SAPoffice: Send new document with attachments using RFC Basis - Use Subcomponents
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
SO_DOCUMENT_SEND_API1 SAPoffice: Send new document with attachments using RFC Basis - Use Subcomponents
SET_DOCUMENT Dokumentenattribute setzten Service - Solution Manager Implementation
SO_NEW_DOCUMENT_SEND_API1 SAPoffice: Send new document Basis - Use Subcomponents

ABAP Reports for SAP Table USR21

ABAP REPORT Description Functional Area
SAPLSUGS External Interfaces of Upgrade
RSXADR03 Basis part of the conversion of address tables SADR* -> ADR* Basis - Address Management/Business Address
SAPLTHFB Task Handler Function Module
SAPLSDNT xx
CL_ABAP_TYPEDESCR=============CP Include LDMEE1_ABACIH
RSSOUSCO_FOR_CC SAPoffice: Create consistency between SOUD, SOUC and addresses Basis - Use Subcomponents

BW Datasources for SAP Table USR21

BW DATASOURCE Description Functional Area
0VENDOR_ATTR Vendor Number MM - Materials Management
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
0CO_OM_OPA_6 Orders: Actual Costs Using Delta Extraction CO - Overhead Cost Orders
0CSM_USER_TEXT Case Management: User Texts -
0BWTC_C03 BW Statistics: Transact. Data OLAP, Detail Navigation Step -
0CO_OM_OPA_7 Orders: Commitment Line Items CO - Overhead Cost Orders

Authorization Objects for SAP Table USR21

AUTHORIZATION OBJECT Description Functional Area
S_TCODE Transaction Code Check at Transaction Start
S_DATASET Authorization for file access
P_PERNR HR: Master Data - Personnel Number Check
E_GRID Authorization Object for Grid
E_VARIANT Authorization Object for Variants
S_USER_GRP User Master Maintenance: User Groups

Most searched SAP Basis Components Tables