P_PersonAddress

DDL: P_PERSONADDRESS SQL: PPERSONADDR Type: view COMPOSITE Package: GLO_FIN_IS_RU

Address Info for Person

P_PersonAddress is a Composite CDS View that provides data about "Address Info for Person" in SAP S/4HANA. It reads from 1 data source (adrp) and exposes 44 fields. Part of development package GLO_FIN_IS_RU.

1 data source(s) 44 fields

Data Sources (1)

SourceAliasJoin Type
adrp adrp from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPERSONADDR view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (44)

KeyFieldSource TableSource FieldDescription
client adrp client
persnumber adrp persnumber
date_from adrp date_from
nation adrp nation
date_to adrp date_to
title adrp title
name_first adrp name_first
name_last adrp name_last
name2 adrp name2
namemiddle adrp namemiddle
name_last2 adrp name_last2
name_text adrp name_text
converted adrp converted
title_aca1 adrp title_aca1
title_aca2 adrp title_aca2
prefix1 adrp prefix1
prefix2 adrp prefix2
title_sppl adrp title_sppl
nickname adrp nickname
initials adrp initials
nameformat adrp nameformat
namcountry adrp namcountry
profession adrp profession
sex adrp sex
langu adrp langu
pers_group adrp pers_group
flaggroups adrp flaggroups
sort1 adrp sort1
sort2 adrp sort2
sort_phn adrp sort_phn
addr_comp adrp addr_comp
addr_pers adrp addr_pers
flperstel adrp flperstel
flperscomm adrp flperscomm
persorigin adrp persorigin
mc_namefir adrp mc_namefir
mc_namelas adrp mc_namelas
mc_name2 adrp mc_name2
langu_crea adrp langu_crea
adrp_uuid adrp adrp_uuid
uuid_belated adrp uuid_belated
id_category adrp id_category
_dataaging adrp _dataaging
namemiddle1asPersonName 
@AbapCatalog.sqlViewName: 'PPERSONADDR'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_PersonAddress as select from adrp {
  
  adrp.client, 
  adrp.persnumber, 
  adrp.date_from, 
  adrp.nation, 
  adrp.date_to, 
  adrp.title, 
  adrp.name_first, 
  adrp.name_last, 
  adrp.name2, 
  adrp.namemiddle, 
  adrp.name_last2, 
  adrp.name_text, 
  adrp.converted, 
  adrp.title_aca1, 
  adrp.title_aca2, 
  adrp.prefix1, 
  adrp.prefix2, 
  adrp.title_sppl, 
  adrp.nickname, 
  adrp.initials, 
  adrp.nameformat, 
  adrp.namcountry, 
  adrp.profession, 
  adrp.sex, 
  adrp.langu, 
  adrp.pers_group, 
  adrp.flaggroups, 
  adrp.sort1, 
  adrp.sort2, 
  adrp.sort_phn, 
  adrp.addr_comp, 
  adrp.addr_pers, 
  adrp.flperstel, 
  adrp.flperscomm, 
  adrp.persorigin, 
  adrp.mc_namefir, 
  adrp.mc_namelas, 
  adrp.mc_name2, 
  adrp.langu_crea, 
  adrp.adrp_uuid, 
  adrp.uuid_belated, 
  adrp.id_category, 
  adrp.adrp_err_status, 
  adrp._dataaging,
  
  rtrim(
    ltrim(
      concat_with_space( concat_with_space(adrp.name_last, adrp.name_first, 1), adrp.namemiddle, 1), 
    ' '), 
  ' ') as PersonName
  
}

Learn More