I_AddressDefaultRepresentation

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_AddressDefaultRepresentation.
-- 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_AddressDefaultRepresentation 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._AddressGroup AS _AddressGroup,
  Address._AddressObjectType AS _AddressObjectType,
  Address._AddressPersonName AS _AddressPersonName,
  Address._AddressRepresentationCode AS _AddressRepresentationCode,
  Address._CorrespondenceLanguage AS _CorrespondenceLanguage,
  Address._Country AS _Country,
  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._FormOfAddress AS _FormOfAddress,
  Address._MainWebsiteURL AS _MainWebsiteURL,
  Address._OrganizationAddress AS _OrganizationAddress,
  Address._PersonAddress AS _PersonAddress,
  Address._PhoneNumber AS _PhoneNumber,
  Address._POBoxAddrNonDeliverableReason AS _POBoxAddrNonDeliverableReason,
  Address._POBoxDeviatingCityCode AS _POBoxDeviatingCityCode,
  Address._POBoxDeviatingCountry AS _POBoxDeviatingCountry,
  Address._POBoxDeviatingRegion AS _POBoxDeviatingRegion,
  Address._PostalCity AS _PostalCity,
  Address._PrfrdCommMediumType AS _PrfrdCommMediumType,
  Address._Region AS _Region,
  Address._RegionalStructureCheckStatus AS _RegionalStructureCheckStatus,
  Address._SecondaryRegion AS _SecondaryRegion,
  Address._Street AS _Street,
  Address._StreetAddrNonDeliverableRsn AS _StreetAddrNonDeliverableRsn,
  Address._TertiaryRegion AS _TertiaryRegion,
  Address._TimeZone AS _TimeZone,
  Address._TransportationZone AS _TransportationZone,
  Address._UniformResourceIdentifier AS _UniformResourceIdentifier
FROM I_Address_2 AS Address
LEFT OUTER JOIN I_Address_2 AS _AddrAdditionalRepresentation ON AddressID = _AddrAdditionalRepresentation.AddressID AND AddressPersonID = _AddrAdditionalRepresentation.AddressPersonID AND _AddrAdditionalRepresentation.AddressRepresentationCode is not initial  -- association [0..*]
;