I_Address_2

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_Address_2.
-- 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_Address_2 AS
SELECT
  Address.AddressID AS AddressID,
  Address.AddressPersonID AS AddressPersonID,
  Address.AddressRepresentationCode AS AddressRepresentationCode,
  Address.AddressObjectType AS AddressObjectType,
  Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  Address.AddresseeFullName AS AddresseeFullName,
  Address.PersonGivenName AS PersonGivenName,
  Address.PersonFamilyName AS PersonFamilyName,
  Address.OrganizationName1 AS OrganizationName1,
  Address.OrganizationName2 AS OrganizationName2,
  Address.OrganizationName3 AS OrganizationName3,
  Address.OrganizationName4 AS OrganizationName4,
  Address.AddressSearchTerm1 AS AddressSearchTerm1,
  Address.AddressSearchTerm2 AS AddressSearchTerm2,
  Address.CityNumber AS CityNumber,
  Address.CityName AS CityName,
  Address.DistrictName AS DistrictName,
  Address.VillageName AS VillageName,
  Address.PostalCode AS PostalCode,
  Address.CompanyPostalCode AS CompanyPostalCode,
  Address.Street AS Street,
  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.POBox AS POBox,
  Address.POBoxAddrNonDeliverableReason AS POBoxAddrNonDeliverableReason,
  Address.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  Address.POBoxPostalCode AS POBoxPostalCode,
  Address.POBoxLobbyName AS POBoxLobbyName,
  Address.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  Address.POBoxDeviatingCityCode AS POBoxDeviatingCityCode,
  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.SecondaryRegion AS SecondaryRegion,
  Address.SecondaryRegionName AS SecondaryRegionName,
  Address.TertiaryRegion AS TertiaryRegion,
  Address.TertiaryRegionName AS TertiaryRegionName,
  Address.RegionalStructureCheckStatus AS RegionalStructureCheckStatus,
  Address.AddressGroup AS AddressGroup,
  Address.DistrictNumber AS DistrictNumber,
  Address.Village AS Village,
  Address.RegionalStructureGroup AS RegionalStructureGroup,
  Address.AddressCreatedByUser AS AddressCreatedByUser,
  Address.AddressCreatedOnDateTime AS AddressCreatedOnDateTime,
  Address.AddressChangedByUser AS AddressChangedByUser,
  Address.AddressChangedOnDateTime AS AddressChangedOnDateTime,
  Address._Region AS _Region,
  Address._Country AS _Country,
  Address._FormOfAddress AS _FormOfAddress,
  Address._StreetAddrNonDeliverableRsn AS _StreetAddrNonDeliverableRsn,
  Address._POBoxAddrNonDeliverableReason AS _POBoxAddrNonDeliverableReason,
  Address._TransportationZone AS _TransportationZone,
  Address._POBoxDeviatingRegion AS _POBoxDeviatingRegion,
  Address._POBoxDeviatingCountry AS _POBoxDeviatingCountry,
  Address._PrfrdCommMediumType AS _PrfrdCommMediumType,
  Address._DeliveryServiceTypeCode AS _DeliveryServiceTypeCode,
  Address._CorrespondenceLanguage AS _CorrespondenceLanguage,
  Address._AddressObjectType AS _AddressObjectType,
  Address._AddressRepresentationCode AS _AddressRepresentationCode,
  Address._SecondaryRegion AS _SecondaryRegion,
  Address._TertiaryRegion AS _TertiaryRegion,
  Address._PostalCity AS _PostalCity,
  Address._TimeZone AS _TimeZone,
  Address._RegionalStructureCheckStatus AS _RegionalStructureCheckStatus,
  Address._Street AS _Street,
  Address._AddressGroup AS _AddressGroup,
  Address._AddressPersonName AS _AddressPersonName,
  Address._POBoxDeviatingCityCode AS _POBoxDeviatingCityCode
FROM P_Address_2 AS Address
LEFT OUTER JOIN I_OrganizationAddress AS _OrganizationAddress ON _OrganizationAddress.AddressID = AddressID AND _OrganizationAddress.AddressRepresentationCode = AddressRepresentationCode AND _OrganizationAddress.AddressPersonID = AddressPersonID AND AddressObjectType = '1'  -- association [0..1]
LEFT OUTER JOIN I_PersonAddress AS _PersonAddress ON _PersonAddress.AddressID = AddressID AND _PersonAddress.AddressPersonID = AddressPersonID AND _PersonAddress.AddressRepresentationCode = AddressRepresentationCode AND AddressObjectType = '2'  -- association [0..1]
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]
;