I_FormattedNameAndAddress

DDL: I_FORMATTEDNAMEANDADDRESS Type: view_entity BASIC Package: S_ADDRESS_VDM

Address, Person and Address types

I_FormattedNameAndAddress is a Basic CDS View that provides data about "Address, Person and Address types" in SAP S/4HANA. It reads from 1 data source (adrp) and exposes 7 fields with key fields AddressID, AddressPersonID, AddressPersonID. Part of development package S_ADDRESS_VDM.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
adrp rp left_outer

Annotations (8)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AddressID cp addrnumber
KEY AddressPersonID cp persnumber
comp_pers cp comp_pers
addrnumberasAddressID
KEY AddressPersonID
comp_pers
AddressType 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@EndUserText.label: 'Address, Person and Address types'

define view entity I_FormattedNameAndAddress
  as select distinct from adcp as cp
  left outer join adrp as rp on  cp.persnumber = rp.persnumber
                                     and cp.nation     = rp.nation
{
  key cp.addrnumber as AddressID,
  key cp.persnumber as AddressPersonID,
      cp.comp_pers,
      case
      when cp.comp_pers = 'P' then '2'
        else '3'
      end           as AddressType
}
where
  cp.date_from = '00010101'

union

select distinct from adrc as rc
{
  key rc.addrnumber as AddressID,
  key ''            as AddressPersonID,
      ''            as comp_pers,
      '1'           as AddressType
}
where
      rc.pers_addr is initial
  and rc.date_from = '00010101'

Learn More