P_Address_2

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@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: 'AddressID'

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view entity P_Address_2
  as select from I_PersonAddress
{
  key AddressID,
  key AddressPersonID,
  key AddressRepresentationCode,

      AddressObjectType,
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      PersonFullName           as AddresseeFullName,
      GivenName                as PersonGivenName,
      FamilyName               as PersonFamilyName,
      cast(' ' as ad_name1)    as OrganizationName1,
      cast(' ' as ad_name2)    as OrganizationName2,
      cast(' ' as ad_name3)    as OrganizationName3,
      cast(' ' as ad_name4)    as OrganizationName4,
      AddressPersonSearchTerm1 as AddressSearchTerm1,
      AddressPersonSearchTerm2 as AddressSearchTerm2,
      CityNumber,
      CityName,
      DistrictName,
      VillageName,
      PostalCode,
      CompanyPostalCode,
      Street,
      StreetName,
      @EndUserText.label: 'Street Address Non-Deliverable Reason'
      StreetAddrNonDeliverableReason,
      StreetPrefixName1,
      StreetPrefixName2,
      StreetSuffixName1,
      StreetSuffixName2,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      
      FormOfAddress,
      TaxJurisdiction,
      TransportZone,

      POBox,
      @EndUserText.label: 'PO Box Address Non-Deliverable Reason'
      POBoxAddrNonDeliverableReason,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingCityCode,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,

      CareOfName,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,

      SecondaryRegion,
      SecondaryRegionName,
      TertiaryRegion,
      TertiaryRegionName,
      RegionalStructureCheckStatus,
      AddressGroup,
      DistrictNumber,
      Village,
      RegionalStructureGroup,
      @Semantics.user.createdBy: true
      AddressCreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      @Analytics.hidden: true
      AddressCreatedOnDateTime,
      @Semantics.user.lastChangedBy: true
      AddressChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      @Analytics.hidden: true
      AddressChangedOnDateTime,

      _Region,
      _Country,
      _FormOfAddress,
      _StreetAddrNonDeliverableRsn,
      _POBoxAddrNonDeliverableReason,
      _TransportationZone,
      _POBoxDeviatingRegion,
      _POBoxDeviatingCountry,
      _PrfrdCommMediumType,
      _DeliveryServiceTypeCode,
      _CorrespondenceLanguage,
      _AddressObjectType,
      _AddressRepresentationCode,
      _SecondaryRegion,
      _TertiaryRegion,
      _PostalCity,
      _TimeZone,
      _RegionalStructureCheckStatus,
      _Street,
      _AddressGroup,
      _AddressPersonName,
      _POBoxDeviatingCityCode
}
union all

select from I_OrganizationAddress
{
  key AddressID,
  key AddressPersonID,
  key AddressRepresentationCode,

      AddressObjectType,
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      AddresseeFullName,
      cast(' ' as ad_namefir) as PersonGivenName,
      cast(' ' as ad_namelas) as PersonFamilyName,
      AddresseeName1          as OrganizationName1,
      AddresseeName2          as OrganizationName2,
      AddresseeName3          as OrganizationName3,
      AddresseeName4          as OrganizationName4,
      AddressSearchTerm1,
      AddressSearchTerm2,
      CityNumber,
      CityName,
      DistrictName,
      VillageName,
      PostalCode,
      CompanyPostalCode,
      Street,
      StreetName,
      StreetAddrNonDeliverableReason,
      StreetPrefixName1,
      StreetPrefixName2,
      StreetSuffixName1,
      StreetSuffixName2,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      FormOfAddress,
      TaxJurisdiction,
      TransportZone,

      POBox,
      POBoxAddrNonDeliverableReason,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingCityCode,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      CareOfName,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,

      SecondaryRegion,
      SecondaryRegionName,
      TertiaryRegion,
      TertiaryRegionName,
      RegionalStructureCheckStatus,
      AddressGroup,
      DistrictNumber,
      Village,
      RegionalStructureGroup,
      AddressCreatedByUser,
      AddressCreatedOnDateTime,
      AddressChangedByUser,
      AddressChangedOnDateTime,

      _Region,
      _Country,
      _FormOfAddress,
      _StreetAddrNonDeliverableRsn,
      _POBoxAddrNonDeliverableReason,
      _TransportationZone,
      _POBoxDeviatingRegion,
      _POBoxDeviatingCountry,
      _PrfrdCommMediumType,
      _DeliveryServiceTypeCode,
      _CorrespondenceLanguage,
      _AddressObjectType,
      _AddressRepresentationCode,
      _SecondaryRegion,
      _TertiaryRegion,
      _PostalCity,
      _TimeZone,
      _RegionalStructureCheckStatus,
      _Street,
      _AddressGroup,
      _AddressPersonName,
      _POBoxDeviatingCityCode
}