PERSNUMBER in USR21

Table Field AD_PERSNUM

Person Number (DE: Personennummer)

PERSNUMBER is a field in SAP table USR21 (Zuordnung Benutzername Adressschlüssel). It represents "Person Number". Data element: AD_PERSNUM. Available in 48 CDS view(s) as Person, persnumber, PersonNumber.

Business Meaning

Description (EN)Person Number
Beschreibung (DE)Personennummer
Data ElementAD_PERSNUM
Key FieldNo

CDS Views & Technical Names (48)

USR21.PERSNUMBER 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.

Person (22 views)

ViewAccessVDMReleaseDescription
I_CmmdtyDrvtvOrderUserDetails direct BASIC Basic View for User Details
I_CmmdtyHedgeSpecUserDetails direct BASIC Commodity Hedge Spec User Details
I_LCMUserAddressAssignment direct BASIC User Name/Address Key Assignment
I_UserContactCard direct COMPOSITE User Contact Card
P_Usercontactcard_Fs direct BASIC
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
I_BankAccFullName1 via 2 level COMPOSITE Full Name for Create By User
I_BankAccFullName2 via 2 level COMPOSITE Full Name for Opened By 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

persnumber (15 views)

ViewAccessVDMReleaseDescription
/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
I_SADL_GW_CPLUSER direct User details in system
P_ON_DEMAND_PRICE_ORDER direct BASIC
P_REASON_CODE_TRACE direct BASIC
P_UserAddress direct BASIC Allegmeine CDS View für Adresse
Swx_Sddl_Address direct Workflow Demo: User Address (CDS)
TSI_CONTACT_entry direct
/BSNAGT/I_USR21 via 2 level USR21
FAP_TSI_INVC_entry via 2 level
Swx_Sddl_Costcenter via 2 level Workflow Demo: Costcenter (CDS view)

PersonNumber (5 views)

ViewAccessVDMReleaseDescription
I_RSHMaintScheduleUsers direct BASIC View to return all the user details
P_BPUsrAssignment direct BASIC Business User - User Assignment
Rv_P_User direct
I_DocumentInfoRecordUserVH via 2 level COMPOSITE Document Info Record User
I_DocumentInfoRecordUserStdVH via 3 levels COMPOSITE Document Info Record User Value Help

UserPersonalNumber (4 views)

ViewAccessVDMReleaseDescription
/dmbe/i_User_Description direct Deal User Description
/dmbe/C_Deal_Creator via 2 level Valid Deal Creators
/dmbe/C_Deal_Trader via 2 level Deal Capture Users
/dmbe/I_Authorized_User via 2 level Authorized Users

AddressPersonID (2 views)

Person Number

ViewAccessVDMReleaseDescription
I_User direct BASIC User
R_DCBTrader via 2 level COMPOSITE Deal Capture Backend Trader

Other Tables with Field PERSNUMBER (9)

TableData ElementKeyDescription
ADCP AD_PERSNUM KEY Zuordnung Person/Adresse (Business Address Services)
ADR12 AD_PERSNUM KEY FTP und URL (Business Address Services)
ADR2 AD_PERSNUM KEY Telefonnummern (Business Address Services)
ADR3 AD_PERSNUM KEY Faxnummern (Business Address Services)
ADR6 AD_PERSNUM KEY E-Mail-Adressen (Business Address Services)
ADRP AD_PERSNUM KEY Personen (Business Address Services)
ADRT AD_PERSNUM KEY Texte zu Kommunikationsdaten (Business Address Services)
ADRU AD_PERSNUM KEY Tabelle für Kommunikationsverwendungen
DFKKCOH AD_PERSNUM Korrespondenz - Korrespondenzkopf

Learn More