ADDRNUMBER in USR21
Address Number (DE: Adressnummer)
ADDRNUMBER is a field in SAP table USR21 (Zuordnung Benutzername Adressschlüssel). It represents "Address Number". Data element: AD_ADDRNUM. Available in 51 CDS view(s) as AddressID, addrnumber, adrnr.
Business Meaning
| Description (EN) | Address Number |
|---|---|
| Beschreibung (DE) | Adressnummer |
| Data Element | AD_ADDRNUM |
| Key Field | No |
CDS Views & Technical Names (51)
USR21.ADDRNUMBER is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
AddressID
(24 views)
Address Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_CmmdtyDrvtvOrderUserDetails | direct | BASIC | Basic View for User Details | |
| I_CmmdtyHedgeSpecUserDetails | direct | BASIC | Commodity Hedge Spec User Details | |
| I_HDMUserContactCard | direct | COMPOSITE | User Contact Card | |
| I_LCMUserAddressAssignment | direct | BASIC | User Name/Address Key Assignment | |
| I_MDCloudUserContactCard | direct | COMPOSITE | User Contact Card | |
| I_User | direct | BASIC | User | |
| I_UserContactCard | direct | COMPOSITE | User Contact Card | |
| /DCO/I_UserContactCard | via 2 level | BASIC | Contact Card | |
| C_AllocChangedByUserVH | via 2 level | CONSUMPTION | Allocation Changed By User VH | |
| C_AllocCreatedByUserVH | via 2 level | CONSUMPTION | Allocation Created By User VH | |
| C_AllocLastExecByUserVH | via 2 level | CONSUMPTION | Allocation Last Execution By User VH | |
| C_AllocRunExecutedByUserVH | via 2 level | CONSUMPTION | Allocation Run Executed By User VH | |
| C_AllocTagChangedByUserVH | via 2 level | CONSUMPTION | Allocation Tag Change By User VH | |
| C_AllocTagCreatedByUserVH | via 2 level | CONSUMPTION | Allocation Tag Create By User VH | |
| C_WrntyUserContactCardVH | via 2 level | CONSUMPTION | Value Help for Warranty Claim Header | |
| I_AllocationImportValuesUserVH | via 2 level | COMPOSITE | Allocation Import Values User | |
| I_AllocImprtValsAppldByUsrVH | via 2 level | COMPOSITE | Allocation Import Values User | |
| I_BusEvtLogUserContactCard | via 2 level | COMPOSITE | Business Event Log User Contact Card | |
| I_EHSTskInstcePersnContactCard | via 2 level | COMPOSITE | EHS Task Instance Person Contact Card | |
| I_LCMUserContactCard | via 2 level | COMPOSITE | Basic view for LCM User Contact Card | |
| I_LglCntntMUserDetails | via 2 level | COMPOSITE | User Details | |
| I_ProdCmplncEvtCntctCard | via 2 level | COMPOSITE | I view for Person Contact Card | |
| I_PurchasingDocContactCard | via 2 level | COMPOSITE | Purchasing Document Contact Card | |
| C_BusEvtLogUserContactCard | via 3 levels | CONSUMPTION | Business Event Log User Contact Card |
addrnumber
(18 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /BSNAGT/P_USR21 | direct | USR21 | ||
| ESH_N_USER_USER | direct | SAP User | ||
| fiscds_adr2_mphone | direct | User Mobile Phone Numbers | ||
| fiscds_adr2_phone | direct | User Phone Numbers | ||
| fiscds_adr3_fax | direct | User Fax Data | ||
| fiscds_adr6_email | direct | User Email Data | ||
| P_UserAddress | direct | BASIC | Allgemeiner CDS View für Adresse | |
| Swx_Sddl_Address | direct | Workflow Demo: User Address (CDS) | ||
| TSI_CONTACT_entry | direct | My Vendor Invoices: Contact | ||
| /BSNAGT/I_USR21 | via 2 level | USR21 | ||
| FAP_TSI_INVC_entry | via 2 level | My Vendor Invoices: Invoice Set | ||
| Swx_Sddl_Costcenter | via 2 level | Workflow Demo: Costcenter (CDS view) | ||
| P_UserEmail | via 3 levels | COMPOSITE | BenutzerEMail | |
| P_UserFax | via 3 levels | COMPOSITE | BenutzerFax | |
| P_UserOrganization | via 3 levels | COMPOSITE | User Organization Data | |
| P_UserPersonName | via 3 levels | COMPOSITE | BenutzerPersonenName | |
| P_UserPhone | via 3 levels | COMPOSITE | BenutzerTelefon | |
| P_UserWorkplace | via 3 levels | COMPOSITE | BenutzerArbeitsplatz |
adrnr
(6 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| cuan_cpg_team_member_search | direct | Campaign Search by Team Member | ||
| CUAN_MKTPL_TEAM_MEMBER_SEARCH | direct | Marketing Plan Search by Team Member | ||
| CUAN_PGM_TEAM_MEMBER_SEARCH | direct | Marketing Program Assigned Team Member | ||
| CUAN_TG_TEAM_MEMBER_SEARCH | direct | AT_TG_TEAM_MEMBER_SEARCH | ||
| cuan_tpl_team_member_search | direct | Campaign Template Search by Team Member | ||
| cuan_user_search | direct | User Search |
UserAddressIdentifier
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_UserAddressLink | direct | BASIC | Benutzer: Verknüpfung zur Adresse | |
| I_UserAddress | via 2 level | COMPOSITE | Benutzeradresse |
AddressNumber
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_BPUsrAssignment | direct | BASIC | Business User - User Assignment |
Other Tables with Field ADDRNUMBER (36)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /BOFU/ADRCUUID | AD_ADDRNUM | Table for ADRC-UUID (Downport 7.10 to 7.0) | |
| /SAPAPO/LOCASGMT | AD_ADDRNUM | KEY | Location Assignment |
| /SAPAPO/TPSRC | AD_ADDRNUM | Contracts: External Procurement | |
| ADCP | AD_ADDRNUM | KEY | Zuordnung Person/Adresse (Business Address Services) |
| ADR12 | AD_ADDRNUM | KEY | FTP und URL (Business Address Services) |
| ADR2 | AD_ADDRNUM | KEY | Telefonnummern (Business Address Services) |
| ADR3 | AD_ADDRNUM | KEY | Faxnummern (Business Address Services) |
| ADR6 | AD_ADDRNUM | KEY | E-Mail-Adressen (Business Address Services) |
| ADRC | AD_ADDRNUM | KEY | Adressen (Business Address Services) |
| ADRCT | AD_ADDRNUM | KEY | Texte zu Adressen (Business Address Services) |
| ADRT | AD_ADDRNUM | KEY | Texte zu Kommunikationsdaten (Business Address Services) |
| ADRU | AD_ADDRNUM | KEY | Tabelle für Kommunikationsverwendungen |
| BUT_ADR12_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADR12 | |
| BUT_ADR2_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADR2 | |
| BUT_ADR3_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADR3 | |
| BUT_ADR6_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADR6 | |
| BUT_ADRC_IMOUT | AD_ADDRNUM | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for ADRC | |
| BUT020 | AD_ADDRNUM | KEY | GP: Adressen |
| BUT020_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for BUT020 | |
| BUT021_FS | AD_ADDRNUM | KEY | zeitabhängige Adressverwendungen |
| BUT021_FS_PRC | AD_ADDRNUM | Master Data Consolidation: Process Table for BUT021_FS | |
| BUT022 | AD_ADDRNUM | KEY | BP: Adressabhängige Attributes |
| BUT052 | AD_ADDRNUM | KEY | GP-Beziehung: Adressen |
| BUT052_PRC | AD_ADDRNUM | MDC: Process Table (BUT052) - BP Rel. Addresses | |
| CRMS4C_SRVC_ORG | AD_ADDRNUM | Enterprise Service Organization | |
| EDOINGSTRSLSREG | AD_ADDRNUM | eDocument India GST Returns: Sales Register | |
| EDPAR | AD_ADDRNUM | Convert External < > Internal Partner Number | |
| FITHA_PBUPL_D | AD_ADDRNUM | Thailand: Branch codes for Customers | |
| FITHA_PBUPL_K | AD_ADDRNUM | Thailand: Branch codes for Vendors | |
| GEOLOC | AD_ADDRNUM | Geo-Location (lon/lat/alt/...) | |
| ICLCCEVENTL | AD_ADDRNUM | KEY | Fallbündel-Schadenadresse-Zuordnung |
| MSR_D_EXECUTED | AD_ADDRNUM | Advanced Returns Management # Tracking of Executed Steps | |
| MSR_D_PLANNED | AD_ADDRNUM | Advanced Returns Management - Next Sequences | |
| SWXFORMABS | AD_ADDRNUM | Formular: Abwesenheitsmitteilung | |
| USCOMPANY | AD_ADDRNUM | Firma in der Adresse eines Benutzers |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA