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_BankScriptedAddress
  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 BankCountry,
  key BankInternalID,
  key AddressRepresentationCode,

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

      AddressSearchTerm1,
      AddressSearchTerm2,

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

      cast ( _CurrentDfltEmailAddress.EmailAddress as cabnk_emailaddress )                                     as EmailAddress,
      _CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber                                              as BankMainIntlPhNmbr,
      _CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber,
      cast( _CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as bf_bank_address_mobile preserving type ) as InternationalMobilePhoneNumber,
      _CurrentDfltFaxNumber.InternationalFaxNumber,

      _Region,
      _Country,
      _FormOfAddress,
      _AddressRepresentationCode,
      _CorrespondenceLanguage,

      _Bank,
      _BankAddress
}

Learn More