R_BankAddressDepTP

DDL: R_BANKADDRESSDEPTP Type: view_entity TRANSACTIONAL Package: RAP_BF_BANK_DEP
58 Fields 2 Data Sources

Bank Address

R_BankAddressDepTP is a Transactional CDS View that provides data about "Bank Address" in SAP S/4HANA. It reads from 2 data sources (I_OrganizationAddress, I_Bank_2) and exposes 58 fields with key fields BankCountry, BankInternalID, AddressRepresentationCode. Part of development package RAP_BF_BANK_DEP.

Data Sources (2)

SourceAliasJoin Type
I_OrganizationAddress Addr inner
I_Bank_2 Bank from

Annotations (8)

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

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY BankCountry I_Bank_2 BankCountry Bank Ctry/Rgn. Key
KEY BankInternalID I_Bank_2 BankInternalID Bank Key
KEY AddressRepresentationCode I_OrganizationAddress AddressRepresentationCode Address Version
AddressID I_OrganizationAddress AddressID Ship-to address
AddressObjectType I_OrganizationAddress AddressObjectType Address Type
CorrespondenceLanguage I_OrganizationAddress CorrespondenceLanguage Language
PrfrdCommMediumType I_OrganizationAddress PrfrdCommMediumType Comm. Method
AddresseeFullName I_OrganizationAddress AddresseeFullName Full Name
BankNameInLocalScript
BankBranchInLocalScript
CityName I_OrganizationAddress CityName Name
DistrictName I_OrganizationAddress DistrictName District
VillageName I_OrganizationAddress VillageName Different City
PostalCode I_OrganizationAddress PostalCode Postal Code
CompanyPostalCode I_OrganizationAddress CompanyPostalCode Company Post Cd
StreetName I_OrganizationAddress StreetName Text
StreetAddrNonDeliverableReason I_OrganizationAddress StreetAddrNonDeliverableReason Undeliverable
StreetPrefixName1 I_OrganizationAddress StreetPrefixName1 Street 2
StreetPrefixName2 I_OrganizationAddress StreetPrefixName2 Street 3
StreetSuffixName1 I_OrganizationAddress StreetSuffixName1 Street 4
StreetSuffixName2 I_OrganizationAddress StreetSuffixName2 Street 5
HouseNumber I_OrganizationAddress HouseNumber House Number
HouseNumberSupplementText I_OrganizationAddress HouseNumberSupplementText Supplement
Building I_OrganizationAddress Building Building code
Floor I_OrganizationAddress Floor Floor
RoomNumber I_OrganizationAddress RoomNumber Room Number
Country I_OrganizationAddress Country Venue: Ctry/Reg
Region I_OrganizationAddress Region Venue Region
FormOfAddress I_OrganizationAddress FormOfAddress Title Key
AddresseeName1 I_OrganizationAddress AddresseeName1
AddresseeName2 I_OrganizationAddress AddresseeName2
AddresseeName3 I_OrganizationAddress AddresseeName3
AddresseeName4 I_OrganizationAddress AddresseeName4
TaxJurisdiction I_OrganizationAddress TaxJurisdiction Tax Jurisdiction
TransportZone I_OrganizationAddress TransportZone Transport Zone
POBox I_OrganizationAddress POBox PO Box
POBoxAddrNonDeliverableReason I_OrganizationAddress POBoxAddrNonDeliverableReason Undeliverable
POBoxIsWithoutNumber I_OrganizationAddress POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode I_OrganizationAddress POBoxPostalCode PO Box Postal Code
POBoxLobbyName I_OrganizationAddress POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName I_OrganizationAddress POBoxDeviatingCityName PO Box City
POBoxDeviatingRegion I_OrganizationAddress POBoxDeviatingRegion PO Region
POBoxDeviatingCountry I_OrganizationAddress POBoxDeviatingCountry PO Box C/R
CareOfName I_OrganizationAddress CareOfName c/o
DeliveryServiceTypeCode I_OrganizationAddress DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber I_OrganizationAddress DeliveryServiceNumber Delivery Service No.
AddressTimeZone I_OrganizationAddress AddressTimeZone Time Zone
SecondaryRegionName I_OrganizationAddress SecondaryRegionName County
TertiaryRegionName I_OrganizationAddress TertiaryRegionName Township
EmailAddress
BankMainIntlPhNmbr
InternationalPhoneNumber
_Region I_OrganizationAddress _Region
_Country I_OrganizationAddress _Country
_FormOfAddress I_OrganizationAddress _FormOfAddress
_AddressRepresentationCode I_OrganizationAddress _AddressRepresentationCode
_CorrespondenceLanguage I_OrganizationAddress _CorrespondenceLanguage
_Bank _Bank

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_BankAddressDepTP.
-- 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_BankAddressDepTP AS
SELECT
  Bank.BankCountry AS BankCountry,
  Bank.BankInternalID AS BankInternalID,
  Addr.AddressRepresentationCode AS AddressRepresentationCode,
  Addr.AddressID AS AddressID,
  Addr.AddressObjectType AS AddressObjectType,
  Addr.CorrespondenceLanguage AS CorrespondenceLanguage,
  Addr.PrfrdCommMediumType AS PrfrdCommMediumType,
  Addr.AddresseeFullName AS 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 AS CityName,
  Addr.DistrictName AS DistrictName,
  Addr.VillageName AS VillageName,
  Addr.PostalCode AS PostalCode,
  Addr.CompanyPostalCode AS CompanyPostalCode,
  Addr.StreetName AS StreetName,
  Addr.StreetAddrNonDeliverableReason AS StreetAddrNonDeliverableReason,
  Addr.StreetPrefixName1 AS StreetPrefixName1,
  Addr.StreetPrefixName2 AS StreetPrefixName2,
  Addr.StreetSuffixName1 AS StreetSuffixName1,
  Addr.StreetSuffixName2 AS StreetSuffixName2,
  Addr.HouseNumber AS HouseNumber,
  Addr.HouseNumberSupplementText AS HouseNumberSupplementText,
  Addr.Building AS Building,
  Addr.Floor AS Floor,
  Addr.RoomNumber AS RoomNumber,
  Addr.Country AS Country,
  Addr.Region AS Region,
  Addr.FormOfAddress AS FormOfAddress,
  Addr.AddresseeName1 AS AddresseeName1,
  Addr.AddresseeName2 AS AddresseeName2,
  Addr.AddresseeName3 AS AddresseeName3,
  Addr.AddresseeName4 AS AddresseeName4,
  Addr.TaxJurisdiction AS TaxJurisdiction,
  Addr.TransportZone AS TransportZone,
  Addr.POBox AS POBox,
  Addr.POBoxAddrNonDeliverableReason AS POBoxAddrNonDeliverableReason,
  Addr.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  Addr.POBoxPostalCode AS POBoxPostalCode,
  Addr.POBoxLobbyName AS POBoxLobbyName,
  Addr.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  Addr.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  Addr.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  Addr.CareOfName AS CareOfName,
  Addr.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  Addr.DeliveryServiceNumber AS DeliveryServiceNumber,
  Addr.AddressTimeZone AS AddressTimeZone,
  Addr.SecondaryRegionName AS SecondaryRegionName,
  Addr.TertiaryRegionName AS TertiaryRegionName,
  Addr._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  Addr._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS BankMainIntlPhNmbr,
  cast( Addr._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber as bf_bank_address_mobile ) AS InternationalPhoneNumber,
  Addr._Region AS _Region,
  Addr._Country AS _Country,
  Addr._FormOfAddress AS _FormOfAddress,
  Addr._AddressRepresentationCode AS _AddressRepresentationCode,
  Addr._CorrespondenceLanguage AS _CorrespondenceLanguage
FROM I_Bank_2 AS Bank
INNER JOIN I_OrganizationAddress AS Addr ON /* join condition not captured in parsed metadata */
;

Learn More