R_BANKSCRIPTEDADDRESSTP

CDS View

Bank Scripted Address

R_BANKSCRIPTEDADDRESSTP is a CDS View in S/4HANA. Bank Scripted Address. It contains 27 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 27 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_BankScriptedAddress_3 view_entity projection CONSUMPTION Scripted Addresses
C_BankScriptedAddressTP view_entity projection CONSUMPTION Consumption Bank Address TP
C_CashBankScriptedAddress view_entity from CONSUMPTION Cash Bank Scripted Address
I_BankScriptedAddressTP view_entity projection TRANSACTIONAL Bank International Address Versions - TP

Fields (27)

KeyField CDS FieldsUsed in Views
KEY AddressRepresentationCode AddressRepresentationCode 1
KEY BankCountry BankCountry 1
KEY BankInternalID BankInternalID 1
AddressID AddressID 1
AddressSearchTerm1 AddressSearchTerm1 1
AddressSearchTerm2 AddressSearchTerm2 1
Building Building 1
CareOfName CareOfName 1
CityName CityName 1
Country Country 1
DistrictName DistrictName 1
Floor Floor 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
LongBankBranch LongBankBranch 1
LongBankName LongBankName 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxLobbyName POBoxLobbyName 1
RoomNumber RoomNumber 1
SecondaryRegionName SecondaryRegionName 1
StreetName StreetName 1
StreetPrefixName1 StreetPrefixName1 1
StreetPrefixName2 StreetPrefixName2 1
StreetSuffixName1 StreetSuffixName1 1
StreetSuffixName2 StreetSuffixName2 1
TertiaryRegionName TertiaryRegionName 1
VillageName VillageName 1 
@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_OrganizationAddress 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRCURDFLTMOBILEPHONENUMBER",
"I_BANK_2",
"I_ORGANIZATIONADDRESS"
],
"ASSOCIATED":
[
"I_ADDRESSREPRESENTATION",
"I_COUNTRY",
"I_FORMOFADDRESS",
"I_LANGUAGE",
"I_REGION",
"R_BANKADDRESSTP",
"R_BANKTP"
],
"BASE":
[
"I_ORGANIZATIONADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More