R_BANKADDRESSDEPTP

CDS View

Bank Address

R_BANKADDRESSDEPTP is a CDS View in S/4HANA. Bank Address. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_BankAddress view_entity projection Bank Address
I_BANKADDRESSDEPTP view_entity projection Bank Address Projection - TP 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Bank Address'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
define view entity R_BankAddressDepTP
  as select from I_Bank_2              as Bank
    inner join   I_OrganizationAddress as Addr on Bank.AddressID = Addr.AddressID

  association        to parent R_BankDepTP as _Bank         on  $projection.BankCountry    = _Bank.BankCountry
                                                         and $projection.BankInternalID = _Bank.BankInternalID

{

  key Bank.BankCountry,
  key Bank.BankInternalID,
  key Addr.AddressRepresentationCode, //adrc-nation

      Addr.AddressID, //adrc-ADDRNUMBER

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


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

      cast( concat(Addr.AddresseeName1, Addr.AddresseeName2) as bf_bank_name_in_local_script )           as BankNameInLocalScript,
      cast( concat(Addr.AddresseeName3, Addr.AddresseeName4) as bf_bank_branch_in_local_script )         as BankBranchInLocalScript,

      Addr.CityName,
      Addr.DistrictName,
      Addr.VillageName,
      Addr.PostalCode,
      Addr.CompanyPostalCode,
      Addr.StreetName,
      Addr.StreetAddrNonDeliverableReason,
      Addr.StreetPrefixName1,
      Addr.StreetPrefixName2,
      Addr.StreetSuffixName1,
      Addr.StreetSuffixName2,
      Addr.HouseNumber,
      Addr.HouseNumberSupplementText,
      Addr.Building,
      Addr.Floor,
      Addr.RoomNumber,
      @ObjectModel.foreignKey.association: '_Country'
      Addr.Country,
      @ObjectModel.foreignKey.association: '_Region'
      Addr.Region,
      @ObjectModel.foreignKey.association: '_FormOfAddress'
      Addr.FormOfAddress,
      Addr.AddresseeName1,
      Addr.AddresseeName2,
      Addr.AddresseeName3,
      Addr.AddresseeName4,
      Addr.TaxJurisdiction,
      Addr.TransportZone,

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


      Addr._CurrentDfltEmailAddress.EmailAddress                                                         as EmailAddress,

      //  Addr._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as BkMainPhAreaCodeSubscriberNmbr,

      //  Addr._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber as BankMainPhoneExtensionNumber,

      //  Addr._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber as BankMainIntlPhNmbr,

      //Addr._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber as BankMainIntlPhNmbr,

      Addr._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber                                   as BankMainIntlPhNmbr,

      //  Addr._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber as PhoneAreaCodeSubscriberNumber,

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

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


      //  Addr._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber as FaxAreaCodeSubscriberNumber,

      //  Addr._CurrentDfltFaxNumber.FaxExtensionNumber as FaxExtensionNumbe,

      //  Addr._CurrentDfltFaxNumber.InternationalFaxNumber as InternationalFaxNumber,


      //  Addr._MainWebsiteURL.UniformResourceIdentifier as UniformResourceIdentifier,





      //    Addr._CurrentDfltEmailAddress as _BankMainEmailAddress,

      //    Addr._CurrentDfltLandlinePhoneNmbr as _BankMainPhoneNmbr,

      //    Addr._CurrentDfltMobilePhoneNumber as _BankMainMobilePhoneNmbr,

      //    Addr._CurrentDfltFaxNumber as _BankMainFaxNumber,

      //    Addr._MainWebsiteURL as _BankMainWebsiteURL,


      Addr._Region,
      Addr._Country,
      Addr._FormOfAddress,
      Addr._AddressRepresentationCode,
      Addr._CorrespondenceLanguage,

      _Bank

}
//where

//  Addr.AddressPersonID is initial;  //DEL DK01

Learn More