R_BANKADDRESSTP

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Bank Address'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}

@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
define view entity R_BankAddressTP
  as select from I_BankAddress
  composition [0..*] of R_BankScriptedAddressTP   as _BankScriptVariant
  association        to parent R_BankTP                  as _Bank      on  $projection.BankCountry    = _Bank.BankCountry
                                                                       and $projection.BankInternalID = _Bank.BankInternalID
  association [0..1] to I_BusPartTelCountryPrefix as _TelCountryPrefix on  $projection.phonenumbercountry = _TelCountryPrefix.Country
{
  key BankCountry,
  key BankInternalID,

      LongBankName,
      LongBankBranch,
      StreetName,
      HouseNumber,
      HouseNumberSupplementText,
      CityName,
      PostalCode,
      @ObjectModel.foreignKey.association: '_Country'
      Country,
      @ObjectModel.foreignKey.association: '_Region'
      Region,
      AddressObjectType,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_CorrespondenceLanguage'
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      AddresseeFullName,
      DistrictName,
      VillageName,
      CompanyPostalCode,
      StreetAddrNonDeliverableReason,
      StreetPrefixName1,
      StreetPrefixName2,
      StreetSuffixName1,
      StreetSuffixName2,
      Building,
      Floor,
      RoomNumber,
      @ObjectModel.foreignKey.association: '_FormOfAddress'
      FormOfAddress,
      TaxJurisdiction,
      TransportZone,

      AddressSearchTerm1,
      AddressSearchTerm2,

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

      AddressRepresentationCode,
      AddressID,
      AddressPersonID,

      cast ( _CurrentDfltEmailAddress.EmailAddress as cabnk_emailaddress )                                      as EmailAddress,
      _CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry,
      _CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber                                              as PhoneNumber,
      _CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber,
      _CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber,
      _CurrentDfltMobilePhoneNumber.PhoneNumberCountry                                                         as MobilePhoneCountry,
      _CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber                                              as MobilePhoneNumber,
      cast( _CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as bf_bank_address_mobile preserving type ) as InternationalMobilePhoneNumber,
      _CurrentDfltFaxNumber.FaxNumberCountry,
      _CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber,
      _CurrentDfltFaxNumber.FaxExtensionNumber,
      _CurrentDfltFaxNumber.InternationalFaxNumber,

      _Region,
      _Country,
      _FormOfAddress,
      _AddressRepresentationCode,
      _CorrespondenceLanguage,

      _AddressObjectType,
      _AddressPersonName,
      _CurrentDfltEmailAddress,
      _CurrentDfltFaxNumber,
      _CurrentDfltLandlinePhoneNmbr,
      _CurrentDfltMobilePhoneNumber,
      _DeliveryServiceTypeCode,
      _EmailAddress,
      _FaxNumber,
      _MainWebsiteURL,
      _PhoneNumber,
      _POBoxAddrNonDeliverableReason,
      _POBoxDeviatingCountry,
      _POBoxDeviatingRegion,
      _PrfrdCommMediumType,
      _StreetAddrNonDeliverableRsn,
      _TimeZone,
      _TransportationZone,
      _UniformResourceIdentifier,

      _Bank,
      _BankScriptVariant,
      _TelCountryPrefix
}