R_BankScriptedAddressTP

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