I_BankOrganizationAddress

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 I_BankOrganizationAddress.
-- 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 I_BankOrganizationAddress AS
SELECT
  AddressID,
  case when AddressID is not initial then cast('' as ad_persnum ) end AS AddressPersonID,
  AddressRepresentationCode,
  case when AddressID is not initial then cast('1' as ad_adrtype) end AS AddressObjectType,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  cast(concat_with_space(AddresseeName1, AddresseeName2, 1) as ad_namtext ) AS AddresseeFullName,
  CityNumber,
  CityName,
  DistrictName,
  VillageName,
  PostalCode,
  CompanyPostalCode,
  Street,
  StreetName,
  StreetAddrNonDeliverableReason,
  StreetPrefixName1,
  StreetPrefixName2,
  StreetSuffixName1,
  StreetSuffixName2,
  HouseNumber,
  HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  Country,
  Region,
  FormOfAddress,
  AddresseeName1,
  AddresseeName2,
  AddresseeName3,
  AddresseeName4,
  AddressSearchTerm1,
  AddressSearchTerm2,
  TaxJurisdiction,
  TransportZone,
  POBox,
  POBoxAddrNonDeliverableReason,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingCityCode,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  CareOfName,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  AddressTimeZone,
  SecondaryRegion,
  SecondaryRegionName,
  TertiaryRegion,
  TertiaryRegionName,
  RegionalStructureCheckStatus,
  AddressGroup,
  AddressCreatedByUser,
  AddressCreatedOnDateTime,
  AddressChangedByUser,
  AddressChangedOnDateTime
FROM I_AddrOrgNamePostalAddress
LEFT OUTER JOIN I_AddressEmailAddress_2 AS _EmailAddress ON _EmailAddress.AddressID = AddressID AND _EmailAddress.AddressPersonID = AddressPersonID  -- association [0..*]
LEFT OUTER JOIN I_AddrCurDefaultEmailAddress AS _CurrentDfltEmailAddress ON _CurrentDfltEmailAddress.AddressID = AddressID AND _CurrentDfltEmailAddress.AddressPersonID = AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _PhoneNumber ON _PhoneNumber.AddressID = AddressID AND _PhoneNumber.AddressPersonID = AddressPersonID  -- association [0..*]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr ON _CurrentDfltLandlinePhoneNmbr.AddressID = AddressID AND _CurrentDfltLandlinePhoneNmbr.AddressPersonID = AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber ON _CurrentDfltMobilePhoneNumber.AddressID = AddressID AND _CurrentDfltMobilePhoneNumber.AddressPersonID = AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _FaxNumber ON _FaxNumber.AddressID = AddressID AND _FaxNumber.AddressPersonID = AddressPersonID  -- association [0..*]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _CurrentDfltFaxNumber ON _CurrentDfltFaxNumber.AddressID = AddressID AND _CurrentDfltFaxNumber.AddressPersonID = AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddressURI AS _UniformResourceIdentifier ON _UniformResourceIdentifier.AddressID = AddressID AND _UniformResourceIdentifier.AddressPersonID = AddressPersonID  -- association [0..*]
LEFT OUTER JOIN I_AddressMainWebsiteURL AS _MainWebsiteURL ON _MainWebsiteURL.AddressID = AddressID AND _MainWebsiteURL.AddressPersonID = AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_AddressNonDeliverableReason AS _POBoxAddrNonDeliverableReason ON POBoxAddrNonDeliverableReason = _POBoxAddrNonDeliverableReason.AddressNonDeliverableReason  -- association [0..1]
LEFT OUTER JOIN I_AddressNonDeliverableReason AS _StreetAddrNonDeliverableRsn ON StreetAddrNonDeliverableReason = _StreetAddrNonDeliverableRsn.AddressNonDeliverableReason  -- association [0..1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON TransportZone = _TransportationZone.TransportZone AND Country = _TransportationZone.CountryCode  -- association [0..1]
LEFT OUTER JOIN I_Region AS _POBoxDeviatingRegion ON POBoxDeviatingRegion = _POBoxDeviatingRegion.Region AND POBoxDeviatingCountry = _POBoxDeviatingRegion.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _POBoxDeviatingCountry ON POBoxDeviatingCountry = _POBoxDeviatingCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_AddressCommunicationMethod AS _PrfrdCommMediumType ON PrfrdCommMediumType = _PrfrdCommMediumType.CommunicationMediumType  -- association [0..1]
LEFT OUTER JOIN I_AddressDeliveryServiceType AS _DeliveryServiceTypeCode ON DeliveryServiceTypeCode = _DeliveryServiceTypeCode.DeliveryServiceTypeCode  -- association [0..1]
LEFT OUTER JOIN I_Language AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_AddressRepresentation AS _AddressRepresentationCode ON AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode  -- association [0..1]
LEFT OUTER JOIN I_AddressObjectType AS _AddressObjectType ON AddressObjectType = _AddressObjectType.AddressObjectType  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON AddressTimeZone = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_SecondaryRegion AS _SecondaryRegion ON SecondaryRegion = _SecondaryRegion.SecondaryRegion AND Country = _SecondaryRegion.Country AND Region = _SecondaryRegion.Region  -- association [0..1]
LEFT OUTER JOIN I_TertiaryRegion AS _TertiaryRegion ON TertiaryRegion = _TertiaryRegion.TertiaryRegion AND SecondaryRegion = _TertiaryRegion.SecondaryRegion AND Country = _TertiaryRegion.Country AND Region = _TertiaryRegion.Region  -- association [0..1]
LEFT OUTER JOIN I_PostalCity AS _PostalCity ON CityNumber = _PostalCity.CityNumber AND Country = _PostalCity.Country  -- association [0..1]
LEFT OUTER JOIN I_PostalCity AS _POBoxDeviatingCityCode ON POBoxDeviatingCityCode = _POBoxDeviatingCityCode.CityNumber AND Country = _POBoxDeviatingCityCode.Country  -- association [0..1]
LEFT OUTER JOIN I_RegionalStructureCheckStatus AS _RegionalStructureCheckStatus ON RegionalStructureCheckStatus = _RegionalStructureCheckStatus.RegionalStructureCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_Street AS _Street ON Country = _Street.Country AND Street = _Street.Street  -- association [0..1]
LEFT OUTER JOIN I_AddressGroup AS _AddressGroup ON AddressGroup = _AddressGroup.AddressGroup  -- association [0..1]
LEFT OUTER JOIN I_AddressPersonName AS _AddressPersonName ON AddressPersonID = _AddressPersonName.AddressPersonID AND AddressRepresentationCode = _AddressPersonName.AddressRepresentationCode  -- association [0..1]
;