R_BankScriptedAddressTP

DDL: R_BANKSCRIPTEDADDRESSTP Type: view_entity TRANSACTIONAL Package: RAP_BF_BANK_BO

Bank Scripted Address

R_BankScriptedAddressTP is a Transactional CDS View that provides data about "Bank Scripted Address" in SAP S/4HANA. It reads from 1 data source (I_BankScriptedAddress) and exposes 60 fields with key fields BankCountry, BankInternalID, AddressRepresentationCode. Part of development package RAP_BF_BANK_BO.

1 data source(s) 60 fields

Data Sources (1)

SourceAliasJoin Type
I_BankScriptedAddress I_BankScriptedAddress from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank Scripted Address view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry
KEY BankInternalID BankInternalID
KEY AddressRepresentationCode AddressRepresentationCode
AddressID AddressID
AddressPersonID AddressPersonID
AddressObjectType AddressObjectType
CorrespondenceLanguage CorrespondenceLanguage
PrfrdCommMediumType PrfrdCommMediumType
AddresseeFullName AddresseeFullName
LongBankName LongBankName
LongBankBranch LongBankBranch
CityName CityName
DistrictName DistrictName
VillageName VillageName
PostalCode PostalCode
CompanyPostalCode CompanyPostalCode
StreetName StreetName
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason
StreetPrefixName1 StreetPrefixName1
StreetPrefixName2 StreetPrefixName2
StreetSuffixName1 StreetSuffixName1
StreetSuffixName2 StreetSuffixName2
HouseNumber HouseNumber
HouseNumberSupplementText HouseNumberSupplementText
Building Building
Floor Floor
RoomNumber RoomNumber
Country Country
Region Region
FormOfAddress FormOfAddress
TaxJurisdiction TaxJurisdiction
TransportZone TransportZone
AddressSearchTerm1 AddressSearchTerm1
AddressSearchTerm2 AddressSearchTerm2
POBox POBox
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason
POBoxIsWithoutNumber POBoxIsWithoutNumber
POBoxPostalCode POBoxPostalCode
POBoxLobbyName POBoxLobbyName
POBoxDeviatingCityName POBoxDeviatingCityName
POBoxDeviatingRegion POBoxDeviatingRegion
POBoxDeviatingCountry POBoxDeviatingCountry
CareOfName CareOfName
DeliveryServiceTypeCode DeliveryServiceTypeCode
DeliveryServiceNumber DeliveryServiceNumber
AddressTimeZone AddressTimeZone
SecondaryRegionName SecondaryRegionName
TertiaryRegionName TertiaryRegionName
EmailAddress
BankMainIntlPhNmbr _CurrentDfltLandlinePhoneNmbr PhoneAreaCodeSubscriberNumber
InternationalPhoneNumber _CurrentDfltLandlinePhoneNmbr InternationalPhoneNumber
InternationalMobilePhoneNumber
InternationalFaxNumber _CurrentDfltFaxNumber InternationalFaxNumber
_Region _Region
_Country _Country
_FormOfAddress _FormOfAddress
_AddressRepresentationCode _AddressRepresentationCode
_CorrespondenceLanguage _CorrespondenceLanguage
_Bank _Bank
_BankAddress _BankAddress 
@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