I_ADDRESSPERSONNAME

CDS View

Person Name

I_ADDRESSPERSONNAME is a CDS View in S/4HANA. Person Name. It contains 26 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 26 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_BusEvtLogUserCntctCardVH view inner CONSUMPTION Business Event Log User
I_AddrPersnNameDfltRprstn view_entity from BASIC Default Representation for Person Name
I_WorkforcePersonTP view_entity inner TRANSACTIONAL BUM - Workforce Person TP
V_Mmim_Ddl_Om_Or_Email view left_outer Output Management E-Mail
V_Mmim_Ddl_Om_Or_GR4PO_EMAIL view left_outer Output Management E-Mail GR4PO

Fields (26)

KeyField CDS FieldsUsed in Views
KEY AddressPersonID AddressPersonID 1
_AcademicTitle _AcademicTitle 1
_AcademicTitle2 _AcademicTitle2 1
_AddressRepresentationCode _AddressRepresentationCode 1
_FamilyNamePrefix _FamilyNamePrefix 1
_FamilyNameSecondPrefix _FamilyNameSecondPrefix 1
_FormOfAddress _FormOfAddress 1
_NameSupplement _NameSupplement 1
AcademicTitle AcademicTitle 1
AcademicTitle2 AcademicTitle2 1
AddressPersonSearchTerm1 AddressPersonSearchTerm1 1
AddressPersonSearchTerm2 AddressPersonSearchTerm2 1
AddressRepresentationCode AddressRepresentationCode 1
CorrespondenceLanguage CorrespondenceLanguage 1
FamilyName FamilyName,LastName 2
FamilyNamePrefix FamilyNamePrefix 1
FamilyNameSecondPrefix FamilyNameSecondPrefix 1
FormOfAddress FormOfAddress 1
GivenName FirstName,GivenName 2
NameInitials NameInitials 1
PersonBirthName PersonBirthName 1
PersonFullName FullName,FullNameOfPerson,PersonFullName 5
PersonMiddleName PersonMiddleName 1
PersonNameSupplementCode PersonNameSupplementCode 1
PersonNickname PersonNickname 1
SecondFamilyName SecondFamilyName 1 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Person Name'
//@Metadata.allowExtensions: true

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.representativeKey: 'AddressPersonID'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}

define view entity I_AddressPersonName
  as select from adrp
  association [0..1] to I_FormOfAddress    as _FormOfAddress          on $projection.FormOfAddress = _FormOfAddress.FormOfAddress

  association [0..1] to I_NameSupplement   as _NameSupplement         on $projection.PersonNameSupplementCode = _NameSupplement.PersonNameSupplementCode

  association [0..1] to I_FamilyNamePrefix as _FamilyNamePrefix       on $projection.FamilyNamePrefix = _FamilyNamePrefix.FamilyNamePrefix

  association [0..1] to I_FamilyNamePrefix as _FamilyNameSecondPrefix on $projection.FamilyNameSecondPrefix = _FamilyNameSecondPrefix.FamilyNamePrefix

  association [0..1] to I_AcademicTitle    as _AcademicTitle          on $projection.AcademicTitle = _AcademicTitle.AcademicTitle

  association [0..1] to I_AcademicTitle    as _AcademicTitle2         on $projection.AcademicTitle2 = _AcademicTitle2.AcademicTitle
  
  association [0..1] to I_AddressRepresentation as _AddressRepresentationCode  on  $projection.AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode
{
  key persnumber as AddressPersonID,
  @ObjectModel.foreignKey.association: '_AddressRepresentationCode'
  key nation     as AddressRepresentationCode,

      @ObjectModel.foreignKey.association: '_FormOfAddress'
      title      as FormOfAddress,
      name_first as GivenName,
      name_last  as FamilyName,
      name2      as PersonBirthName,
      namemiddle as PersonMiddleName,
      name_last2 as SecondFamilyName,
      @ObjectModel.foreignKey.association: '_AcademicTitle'
      title_aca1 as AcademicTitle,
      @ObjectModel.foreignKey.association: '_AcademicTitle2'
      title_aca2 as AcademicTitle2,
      @ObjectModel.foreignKey.association: '_FamilyNamePrefix'
      prefix1    as FamilyNamePrefix,
      @ObjectModel.foreignKey.association: '_FamilyNameSecondPrefix'
      prefix2    as FamilyNameSecondPrefix,
      @ObjectModel.foreignKey.association: '_NameSupplement'
      title_sppl as PersonNameSupplementCode,
      nickname   as PersonNickname,
      initials   as NameInitials,
      name_text  as PersonFullName,
      langu      as CorrespondenceLanguage,
      sort1      as AddressPersonSearchTerm1,
      sort2      as AddressPersonSearchTerm2,

      _FormOfAddress,
      _NameSupplement,
      _FamilyNamePrefix,
      _FamilyNameSecondPrefix,
      _AcademicTitle,
      _AcademicTitle2,
      _AddressRepresentationCode
 

}
where
  date_from = '00010101'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRP"
],
"ASSOCIATED":
[
"I_ACADEMICTITLE",
"I_ADDRESSREPRESENTATION",
"I_FAMILYNAMEPREFIX",
"I_FORMOFADDRESS",
"I_NAMESUPPLEMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More