R_BankScriptedAddressTP

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Bank Scripted 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_BankScriptedAddressTP
  as select from I_Bank_2                  as Bank
    inner join   I_BankOrganizationAddress as Address on Address.AddressID = Bank.AddressID
                                                 and Address.AddressPersonID is initial
                                                 and Address.AddressRepresentationCode is not initial

//  association to parent R_BankTP as _Bank         on $projection.BankCountry    = _Bank.BankCountry

//                                                 and $projection.BankInternalID = _Bank.BankInternalID

  association to R_BankTP as _Bank         on $projection.BankCountry    = _Bank.BankCountry
                                           and $projection.BankInternalID = _Bank.BankInternalID
  association to parent R_BankAddressTP as _BankAddress on  $projection.BankCountry    = _BankAddress.BankCountry
                                                        and $projection.BankInternalID = _BankAddress.BankInternalID
{
  key Bank.BankCountry,
  key Bank.BankInternalID,
  key Address.AddressRepresentationCode, 
//      Address.AddressRepresentationCode as AddressRepCodeForEdit, 

      Address.AddressID, 
      Address.AddressPersonID,     //Added because of _CurrentDfltEmailAddress and other communication fields


      Address.AddressObjectType,
        
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_CorrespondenceLanguage'      
      Address.CorrespondenceLanguage,
      Address.PrfrdCommMediumType,
      Address.AddresseeFullName,

      cast( concat(Address.AddresseeName1, Address.AddresseeName2) 
        as bf_bank_name_in_local_script preserving type )   as LongBankName,   //char80

      cast( concat(Address.AddresseeName3, Address.AddresseeName4) 
        as bf_bank_branch_in_local_script preserving type ) as LongBankBranch, //char80



      Address.CityName                       ,
      Address.DistrictName,
      Address.VillageName,
      Address.PostalCode,
      Address.CompanyPostalCode,
      Address.StreetName                     ,
      Address.StreetAddrNonDeliverableReason,
      Address.StreetPrefixName1,
      Address.StreetPrefixName2,
      Address.StreetSuffixName1,
      Address.StreetSuffixName2,
      Address.HouseNumber,
      Address.HouseNumberSupplementText,
      Address.Building,
      Address.Floor,
      Address.RoomNumber,
      @ObjectModel.foreignKey.association: '_Country'
      Address.Country,
      @ObjectModel.foreignKey.association: '_Region'
      Address.Region                          ,
      @ObjectModel.foreignKey.association: '_FormOfAddress'
      Address.FormOfAddress,
//      Address.AddresseeName1,

//      Address.AddresseeName2,

//      Address.AddresseeName3,

//      Address.AddresseeName4,

      Address.TaxJurisdiction,
      Address.TransportZone,
      
      Address.AddressSearchTerm1,
      Address.AddressSearchTerm2,

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


      Address._CurrentDfltEmailAddress.EmailAddress                                                         as EmailAddress,

      //  Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as BkMainPhAreaCodeSubscriberNmbr,

      //  Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber as BankMainPhoneExtensionNumber,

      //  Address._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber as BankMainIntlPhNmbr,

      //Address._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber as BankMainIntlPhNmbr,

      Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber                                   as BankMainIntlPhNmbr,

      //  Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber as PhoneAreaCodeSubscriberNumber,

      // cast( Address._CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as bf_bank_address_mobile ) as InternationalPhoneNumber,

      cast( Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber as bf_bank_address_mobile ) as InternationalPhoneNumber,


      //  Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber as FaxAreaCodeSubscriberNumber,

      //  Address._CurrentDfltFaxNumber.FaxExtensionNumber as FaxExtensionNumbe,

      //  Address._CurrentDfltFaxNumber.InternationalFaxNumber as InternationalFaxNumber,


      //  Address._MainWebsiteURL.UniformResourceIdentifier as UniformResourceIdentifier,





      //    Address._CurrentDfltEmailAddress as _BankMainEmailAddress,

      //    Address._CurrentDfltLandlinePhoneNmbr as _BankMainPhoneNmbr,

      //    Address._CurrentDfltMobilePhoneNumber as _BankMainMobilePhoneNmbr,

      //    Address._CurrentDfltFaxNumber as _BankMainFaxNumber,

      //    Address._MainWebsiteURL as _BankMainWebsiteURL,


      Address._Region,
      Address._Country,
      Address._FormOfAddress,
      Address._AddressRepresentationCode,
      Address._CorrespondenceLanguage,
      
      _Bank,
      _BankAddress
}