R_BankAddressTP

DDL: R_BANKADDRESSTP Type: view_entity TRANSACTIONAL Package: RAP_BF_BANK_BO
87 Fields 1 Data Sources 2 Associations

Bank Address

R_BankAddressTP is a Transactional CDS View that provides data about "Bank Address" in SAP S/4HANA. It reads from 1 data source (I_BankAddress) and exposes 87 fields with key fields BankCountry, BankInternalID. It has 2 associations to related views. Part of development package RAP_BF_BANK_BO.

Data Sources (1)

SourceAliasJoin Type
I_BankAddress I_BankAddress from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusPartTelCountryPrefix _TelCountryPrefix $projection.phonenumbercountry = _TelCountryPrefix.Country
[0..*] R_BankScriptedAddressTP _BankScriptVariant

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Bank 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 (87)

KeyFieldSource TableSource FieldDescription
KEY BankCountry BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID BankInternalID Bank Key
LongBankName LongBankName
LongBankBranch LongBankBranch
StreetName StreetName Text
HouseNumber HouseNumber House Number
HouseNumberSupplementText HouseNumberSupplementText Supplement
CityName CityName Name
PostalCode PostalCode Postal Code
Country Country Venue: Ctry/Reg
Region Region Venue Region
AddressObjectType AddressObjectType Address Type
CorrespondenceLanguage CorrespondenceLanguage Language
PrfrdCommMediumType PrfrdCommMediumType Comm. Method
AddresseeFullName AddresseeFullName Full Name
DistrictName DistrictName District
VillageName VillageName Different City
CompanyPostalCode CompanyPostalCode Company Post Cd
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason Undeliverable
StreetPrefixName1 StreetPrefixName1 Street 2
StreetPrefixName2 StreetPrefixName2 Street 3
StreetSuffixName1 StreetSuffixName1 Street 4
StreetSuffixName2 StreetSuffixName2 Street 5
Building Building Building code
Floor Floor Floor
RoomNumber RoomNumber Room Number
FormOfAddress FormOfAddress Title Key
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TransportZone TransportZone Transport Zone
AddressSearchTerm1 AddressSearchTerm1 Search Term 1
AddressSearchTerm2 AddressSearchTerm2 Search Term 2
POBox POBox PO Box
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason Undeliverable
POBoxIsWithoutNumber POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode POBoxPostalCode PO Box Postal Code
POBoxLobbyName POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName POBoxDeviatingCityName PO Box City
POBoxDeviatingRegion POBoxDeviatingRegion PO Region
POBoxDeviatingCountry POBoxDeviatingCountry PO Box C/R
CareOfName CareOfName c/o
DeliveryServiceTypeCode DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber DeliveryServiceNumber Delivery Service No.
AddressTimeZone AddressTimeZone Time Zone
SecondaryRegionName SecondaryRegionName County
TertiaryRegionName TertiaryRegionName Township
AddressRepresentationCode AddressRepresentationCode Address Version
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
EmailAddress
PhoneNumberCountry _CurrentDfltLandlinePhoneNmbr PhoneNumberCountry
PhoneNumber _CurrentDfltLandlinePhoneNmbr PhoneAreaCodeSubscriberNumber Telephone
PhoneExtensionNumber _CurrentDfltLandlinePhoneNmbr PhoneExtensionNumber Extension
InternationalPhoneNumber _CurrentDfltLandlinePhoneNmbr InternationalPhoneNumber Telephone no.
MobilePhoneCountry _CurrentDfltMobilePhoneNumber PhoneNumberCountry
MobilePhoneNumber _CurrentDfltMobilePhoneNumber PhoneAreaCodeSubscriberNumber Telephone
InternationalMobilePhoneNumber
FaxNumberCountry _CurrentDfltFaxNumber FaxNumberCountry Country/Region
FaxAreaCodeSubscriberNumber _CurrentDfltFaxNumber FaxAreaCodeSubscriberNumber Fax
FaxExtensionNumber _CurrentDfltFaxNumber FaxExtensionNumber Extension
InternationalFaxNumber _CurrentDfltFaxNumber InternationalFaxNumber Fax Number
_Region _Region
_Country _Country
_FormOfAddress _FormOfAddress
_AddressRepresentationCode _AddressRepresentationCode
_CorrespondenceLanguage _CorrespondenceLanguage
_AddressObjectType _AddressObjectType
_AddressPersonName _AddressPersonName
_CurrentDfltEmailAddress _CurrentDfltEmailAddress
_CurrentDfltFaxNumber _CurrentDfltFaxNumber
_CurrentDfltLandlinePhoneNmbr _CurrentDfltLandlinePhoneNmbr
_CurrentDfltMobilePhoneNumber _CurrentDfltMobilePhoneNumber
_DeliveryServiceTypeCode _DeliveryServiceTypeCode
_EmailAddress _EmailAddress
_FaxNumber _FaxNumber
_MainWebsiteURL _MainWebsiteURL
_PhoneNumber _PhoneNumber
_POBoxAddrNonDeliverableReason _POBoxAddrNonDeliverableReason
_POBoxDeviatingCountry _POBoxDeviatingCountry
_POBoxDeviatingRegion _POBoxDeviatingRegion
_PrfrdCommMediumType _PrfrdCommMediumType
_StreetAddrNonDeliverableRsn _StreetAddrNonDeliverableRsn
_TimeZone _TimeZone
_TransportationZone _TransportationZone
_UniformResourceIdentifier _UniformResourceIdentifier
_Bank _Bank
_BankScriptVariant _BankScriptVariant
_TelCountryPrefix _TelCountryPrefix

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_BankAddressTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_BankAddressTP AS
SELECT
  BankCountry,
  BankInternalID,
  LongBankName,
  LongBankBranch,
  StreetName,
  HouseNumber,
  HouseNumberSupplementText,
  CityName,
  PostalCode,
  Country,
  Region,
  AddressObjectType,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  AddresseeFullName,
  DistrictName,
  VillageName,
  CompanyPostalCode,
  StreetAddrNonDeliverableReason,
  StreetPrefixName1,
  StreetPrefixName2,
  StreetSuffixName1,
  StreetSuffixName2,
  Building,
  Floor,
  RoomNumber,
  FormOfAddress,
  TaxJurisdiction,
  TransportZone,
  AddressSearchTerm1,
  AddressSearchTerm2,
  POBox,
  POBoxAddrNonDeliverableReason,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  CareOfName,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  AddressTimeZone,
  SecondaryRegionName,
  TertiaryRegionName,
  AddressRepresentationCode,
  AddressID,
  AddressPersonID,
  cast ( _CurrentDfltEmailAddress.EmailAddress as cabnk_emailaddress ) AS EmailAddress,
  _CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry AS PhoneNumberCountry,
  _CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber AS PhoneExtensionNumber,
  _CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber AS InternationalPhoneNumber,
  _CurrentDfltMobilePhoneNumber.PhoneNumberCountry AS MobilePhoneCountry,
  _CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobilePhoneNumber,
  cast( _CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as bf_bank_address_mobile preserving type ) AS InternationalMobilePhoneNumber,
  _CurrentDfltFaxNumber.FaxNumberCountry AS FaxNumberCountry,
  _CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxAreaCodeSubscriberNumber,
  _CurrentDfltFaxNumber.FaxExtensionNumber AS FaxExtensionNumber,
  _CurrentDfltFaxNumber.InternationalFaxNumber AS InternationalFaxNumber
FROM I_BankAddress
LEFT OUTER JOIN I_BusPartTelCountryPrefix AS _TelCountryPrefix ON phonenumbercountry = _TelCountryPrefix.Country  -- association [0..1]
LEFT OUTER JOIN R_BankScriptedAddressTP AS _BankScriptVariant ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More