R_BankAddressTP

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
  Bank.BankCountry AS BankCountry,
  Bank.BankInternalID AS BankInternalID,
  case when ( Address.StreetName is null or Address.StreetName is initial ) then Bank.ShortStreetName else Address.StreetName end as StreetName AS StreetNameendasStreetName,
  Address.HouseNumber AS HouseNumber,
  Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  case when ( Address.CityName is null or Address.CityName is initial ) then Bank.ShortCityName else Address.CityName end as CityName AS CityNameendasCityName,
  Address.PostalCode AS PostalCode,
  Address.Country AS Country,
  case when ( Address.Region is null or Address.Region is initial ) then Bank.Region else Address.Region end as Region AS RegionendasRegion,
  Address.AddressObjectType AS AddressObjectType,
  Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  Address.AddresseeFullName AS AddresseeFullName,
  Address.DistrictName AS DistrictName,
  Address.VillageName AS VillageName,
  Address.CompanyPostalCode AS CompanyPostalCode,
  Address.StreetAddrNonDeliverableReason AS StreetAddrNonDeliverableReason,
  Address.StreetPrefixName1 AS StreetPrefixName1,
  Address.StreetPrefixName2 AS StreetPrefixName2,
  Address.StreetSuffixName1 AS StreetSuffixName1,
  Address.StreetSuffixName2 AS StreetSuffixName2,
  Address.Building AS Building,
  Address.Floor AS Floor,
  Address.RoomNumber AS RoomNumber,
  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.AddressRepresentationCode AS AddressRepresentationCode,
  Address.AddressID AS AddressID,
  Address.AddressPersonID AS AddressPersonID,
  Address._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  Address._CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry AS PhoneNumberCountry,
  Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber AS PhoneExtensionNumber,
  Address._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber AS InternationalPhoneNumber,
  Address._CurrentDfltMobilePhoneNumber.PhoneNumberCountry AS MobilePhoneCountry,
  Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobilePhoneNumber,
  cast( Address._CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as bf_bank_address_mobile preserving type ) AS InternationalMobilePhoneNumber,
  Address._CurrentDfltFaxNumber.FaxNumberCountry AS FaxNumberCountry,
  Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxAreaCodeSubscriberNumber,
  Address._CurrentDfltFaxNumber.FaxExtensionNumber AS FaxExtensionNumber,
  Address._CurrentDfltFaxNumber.InternationalFaxNumber AS InternationalFaxNumber,
  Address._Country AS _Country,
  Address._FormOfAddress AS _FormOfAddress,
  Address._AddressRepresentationCode AS _AddressRepresentationCode,
  Address._CorrespondenceLanguage AS _CorrespondenceLanguage,
  Address._AddressObjectType AS _AddressObjectType,
  Address._AddressPersonName AS _AddressPersonName,
  Address._CurrentDfltEmailAddress AS _CurrentDfltEmailAddress,
  Address._CurrentDfltFaxNumber AS _CurrentDfltFaxNumber,
  Address._CurrentDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr,
  Address._CurrentDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber,
  Address._DeliveryServiceTypeCode AS _DeliveryServiceTypeCode,
  Address._EmailAddress AS _EmailAddress,
  Address._FaxNumber AS _FaxNumber,
  Address._MainWebsiteURL AS _MainWebsiteURL,
  Address._PhoneNumber AS _PhoneNumber,
  Address._POBoxAddrNonDeliverableReason AS _POBoxAddrNonDeliverableReason,
  Address._POBoxDeviatingCountry AS _POBoxDeviatingCountry,
  Address._POBoxDeviatingRegion AS _POBoxDeviatingRegion,
  Address._PrfrdCommMediumType AS _PrfrdCommMediumType,
  Address._StreetAddrNonDeliverableRsn AS _StreetAddrNonDeliverableRsn,
  Address._TimeZone AS _TimeZone,
  Address._TransportationZone AS _TransportationZone,
  Address._UniformResourceIdentifier AS _UniformResourceIdentifier
FROM I_Bank_2 AS Bank
LEFT OUTER JOIN I_BankOrganizationAddress AS Address ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
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..*]
;