I_AddressPersonName

DDL: I_ADDRESSPERSONNAME Type: view_entity BASIC
26 Fields 1 Data Sources 7 Associations

Person Name

I_AddressPersonName (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_AddressPersonName is a Basic CDS View that provides data about "Person Name" in SAP S/4HANA. It reads from 1 data source (adrp) and exposes 26 fields with key fields AddressPersonID, AddressRepresentationCode. It has 7 associations to related views.

SAP Help Documentation

CategoryCDS Views for Business Address Service
Purpose
This CDS view retruns the full name (first name and last name) and other additional name details of a person, such as the person's family name prefix (if any), nickname, and address representation code. This CDS view provides the data to answer the following business questions: What is the first name and last name of the person? What are the additional name details, such as family name prefix (if any), nickname, and so on? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view need to access it via another CDS view (privileged mode).

Structure
Important Fields Important fields in this view include the following: Field Name Description AddressPersonID AddressRepresentationCode FormOfAddress Person Number Version ID for International Addresses Form-of-Address Key GivenName FamilyName PersonBirthName PersonMiddleName SecondFamilyName AcademicTitle AcademicTitle2 FamilyNamePrefix FamilyNameSecondPrefix PersonNameSupplementCode PersonNickname NameInitials PersonFullName First Name Last Name Name of person at birth Middle name or second forename of a person Other Last Name of a Person Academic Title: Key Second academic title (key) Name Prefix (Key) 2nd name prefix (key) Name supplement, e.g. noble title (key) Nickname or name used "Middle Initial" or personal initials Full Name of Person CorrespondenceLanguage Language Key AddressPersonSearchTerm1 AddressPersonSearchTerm2 Search Term 1 Search Term 2 PersonFullNameFormattingCode PersonFullNameFormattingCntry Name format Country or Region for Name Format Rule AddressCreatedByUser AddressCreatedOnDateTime AddressChangedByUser AddressChangedOnDateTime Created By User Creation Date and Time Last Changed By User Last Changed Date and Time

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentBC-SRV-ADR
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
adrp adrp from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_FormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress
[0..1] I_NameSupplement _NameSupplement $projection.PersonNameSupplementCode = _NameSupplement.PersonNameSupplementCode
[0..1] I_FamilyNamePrefix _FamilyNamePrefix $projection.FamilyNamePrefix = _FamilyNamePrefix.FamilyNamePrefix
[0..1] I_FamilyNamePrefix _FamilyNameSecondPrefix $projection.FamilyNameSecondPrefix = _FamilyNameSecondPrefix.FamilyNamePrefix
[0..1] I_AcademicTitle _AcademicTitle $projection.AcademicTitle = _AcademicTitle.AcademicTitle
[0..1] I_AcademicTitle _AcademicTitle2 $projection.AcademicTitle2 = _AcademicTitle2.AcademicTitle
[0..1] I_AddressRepresentation _AddressRepresentationCode $projection.AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Person Name view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey AddressPersonID view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY AddressPersonID persnumber Person Number
KEY AddressRepresentationCode nation Version ID for International Addresses
FormOfAddress title Form-of-Address Key
GivenName name_first First Name
FamilyName name_last Last Name
PersonBirthName name2 Name of person at birth
PersonMiddleName namemiddle Middle name or second forename of a person
SecondFamilyName name_last2 Other Last Name of a Person
AcademicTitle title_aca1 Academic Title: Key
AcademicTitle2 title_aca2 Second academic title (key)
FamilyNamePrefix prefix1 Name Prefix (Key)
FamilyNameSecondPrefix prefix2 2nd name prefix (key)
PersonNameSupplementCode title_sppl Name supplement, e.g. noble title (key)
PersonNickname nickname Nickname or name used
NameInitials initials "Middle Initial" or personal initials
PersonFullName name_text Full Name of Person
CorrespondenceLanguage langu Primary lang.
AddressPersonSearchTerm1 sort1 Sort string 1
AddressPersonSearchTerm2 sort2 Sort string 2
_FormOfAddress _FormOfAddress
_NameSupplement _NameSupplement
_FamilyNamePrefix _FamilyNamePrefix
_FamilyNameSecondPrefix _FamilyNameSecondPrefix
_AcademicTitle _AcademicTitle
_AcademicTitle2 _AcademicTitle2
_AddressRepresentationCode _AddressRepresentationCode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_AddressPersonName.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_AddressPersonName AS
SELECT
  persnumber AS AddressPersonID,
  nation AS AddressRepresentationCode,
  title AS FormOfAddress,
  name_first AS GivenName,
  name_last AS FamilyName,
  name2 AS PersonBirthName,
  namemiddle AS PersonMiddleName,
  name_last2 AS SecondFamilyName,
  title_aca1 AS AcademicTitle,
  title_aca2 AS AcademicTitle2,
  prefix1 AS FamilyNamePrefix,
  prefix2 AS FamilyNameSecondPrefix,
  title_sppl AS PersonNameSupplementCode,
  nickname AS PersonNickname,
  initials AS NameInitials,
  name_text AS PersonFullName,
  langu AS CorrespondenceLanguage,
  sort1 AS AddressPersonSearchTerm1,
  sort2 AS AddressPersonSearchTerm2
FROM adrp
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_NameSupplement AS _NameSupplement ON PersonNameSupplementCode = _NameSupplement.PersonNameSupplementCode  -- association [0..1]
LEFT OUTER JOIN I_FamilyNamePrefix AS _FamilyNamePrefix ON FamilyNamePrefix = _FamilyNamePrefix.FamilyNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_FamilyNamePrefix AS _FamilyNameSecondPrefix ON FamilyNameSecondPrefix = _FamilyNameSecondPrefix.FamilyNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitle ON AcademicTitle = _AcademicTitle.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitle2 ON AcademicTitle2 = _AcademicTitle2.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_AddressRepresentation AS _AddressRepresentationCode ON AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode  -- association [0..1]
;

Learn More