I_PersonAddress

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_PersonAddress.
-- 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_PersonAddress AS
SELECT
  I_AddressWorkplaceDetails.AddressID AS AddressID,
  I_AddressWorkplaceDetails.AddressPersonID AS AddressPersonID,
  I_AddressWorkplaceDetails.AddressRepresentationCode AS AddressRepresentationCode,
  cast('2' as ad_adrtype) AS AddressObjectType,
  _PersonName.CorrespondenceLanguage AS CorrespondenceLanguage,
  _PersonName.GivenName AS GivenName,
  _PersonName.FamilyName AS FamilyName,
  _PersonName.PersonBirthName AS PersonBirthName,
  _PersonName.PersonMiddleName AS PersonMiddleName,
  _PersonName.SecondFamilyName AS SecondFamilyName,
  _PersonName.AcademicTitle AS AcademicTitle,
  _PersonName.AcademicTitle2 AS AcademicTitle2,
  _PersonName.FamilyNamePrefix AS FamilyNamePrefix,
  _PersonName.FamilyNameSecondPrefix AS FamilyNameSecondPrefix,
  _PersonName.PersonNameSupplementCode AS PersonNameSupplementCode,
  _PersonName.PersonNickname AS PersonNickname,
  _PersonName.NameInitials AS NameInitials,
  _PersonName.PersonFullName AS PersonFullName,
  _PersonName.FormOfAddress AS FormOfAddress,
  _PersonName.AddressPersonSearchTerm1 AS AddressPersonSearchTerm1,
  _PersonName.AddressPersonSearchTerm2 AS AddressPersonSearchTerm2,
  _PersonName.PersonFullNameFormattingCode AS PersonFullNameFormattingCode,
  _PersonName.PersonFullNameFormattingCntry AS PersonFullNameFormattingCntry,
  _PersonName.converted AS converted,
  _OrgNamePostalAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  _OrgNamePostalAddress.CityNumber AS CityNumber,
  _OrgNamePostalAddress.CityName AS CityName,
  _OrgNamePostalAddress.DistrictName AS DistrictName,
  _OrgNamePostalAddress.VillageName AS VillageName,
  _OrgNamePostalAddress.PostalCode AS PostalCode,
  _OrgNamePostalAddress.CompanyPostalCode AS CompanyPostalCode,
  _OrgNamePostalAddress.Street AS Street,
  _OrgNamePostalAddress.StreetName AS StreetName,
  _OrgNamePostalAddress.StreetAddrNonDeliverableReason AS StreetAddrNonDeliverableReason,
  _OrgNamePostalAddress.StreetPrefixName1 AS StreetPrefixName1,
  _OrgNamePostalAddress.StreetPrefixName2 AS StreetPrefixName2,
  _OrgNamePostalAddress.StreetSuffixName1 AS StreetSuffixName1,
  _OrgNamePostalAddress.StreetSuffixName2 AS StreetSuffixName2,
  _OrgNamePostalAddress.HouseNumber AS HouseNumber,
  _OrgNamePostalAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  _OrgNamePostalAddress.Building AS Building,
  _OrgNamePostalAddress.Floor AS Floor,
  _OrgNamePostalAddress.RoomNumber AS RoomNumber,
  _OrgNamePostalAddress.Country AS Country,
  _OrgNamePostalAddress.Region AS Region,
  _OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  _OrgNamePostalAddress.TransportZone AS TransportZone,
  _OrgNamePostalAddress.POBox AS POBox,
  _OrgNamePostalAddress.POBoxAddrNonDeliverableReason AS POBoxAddrNonDeliverableReason,
  _OrgNamePostalAddress.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  _OrgNamePostalAddress.POBoxLobbyName AS POBoxLobbyName,
  _OrgNamePostalAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _OrgNamePostalAddress.POBoxDeviatingCityCode AS POBoxDeviatingCityCode,
  _OrgNamePostalAddress.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _OrgNamePostalAddress.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _OrgNamePostalAddress.CareOfName AS CareOfName,
  _OrgNamePostalAddress.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _OrgNamePostalAddress.DeliveryServiceNumber AS DeliveryServiceNumber,
  _OrgNamePostalAddress.AddressTimeZone AS AddressTimeZone,
  _OrgNamePostalAddress.SecondaryRegion AS SecondaryRegion,
  _OrgNamePostalAddress.SecondaryRegionName AS SecondaryRegionName,
  _OrgNamePostalAddress.TertiaryRegion AS TertiaryRegion,
  _OrgNamePostalAddress.TertiaryRegionName AS TertiaryRegionName,
  _OrgNamePostalAddress.RegionalStructureCheckStatus AS RegionalStructureCheckStatus,
  _OrgNamePostalAddress.AddressGroup AS AddressGroup,
  _OrgNamePostalAddress.DistrictNumber AS DistrictNumber,
  _OrgNamePostalAddress.Village AS Village,
  _OrgNamePostalAddress.RegionalStructureGroup AS RegionalStructureGroup,
  _OrgNamePostalAddress.AddressCreatedByUser AS AddressCreatedByUser,
  _OrgNamePostalAddress.AddressCreatedOnDateTime AS AddressCreatedOnDateTime,
  _OrgNamePostalAddress.AddressChangedByUser AS AddressChangedByUser,
  _OrgNamePostalAddress.AddressChangedOnDateTime AS AddressChangedOnDateTime
FROM I_AddressWorkplaceDetails
LEFT OUTER JOIN I_AddrOrgNamePostalAddress AS _OrgNamePostalAddress ON _OrgNamePostalAddress.AddressID = AddressID AND _OrgNamePostalAddress.AddressRepresentationCode = AddressRepresentationCode AND _OrgNamePostalAddress.AddressIsPersonAddress = 'X'  -- association [0..1]
LEFT OUTER JOIN I_AddressPersonName AS _PersonName ON _PersonName.AddressPersonID = AddressPersonID AND _PersonName.AddressRepresentationCode = AddressRepresentationCode  -- 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]
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_AddressObjectType AS _AddressObjectType ON AddressObjectType = _AddressObjectType.AddressObjectType  -- association [0..1]
LEFT OUTER JOIN I_AddressRepresentation AS _AddressRepresentationCode ON AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode  -- 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_TimeZone AS _TimeZone ON addresstimezone = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_NameSupplement AS _NameSupplement ON personnamesupplementcode = _NameSupplement.PersonNameSupplementCode  -- association [0..1]
LEFT OUTER JOIN I_FamilyNamePrefix AS _FamilyNamePrefix ON familynameprefix = _FamilyNamePrefix.FamilyNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_FamilyNamePrefix AS _FamilyNameSecondPrefix ON familynamesecondprefix = _FamilyNameSecondPrefix.FamilyNamePrefix  -- association [0..1]
LEFT OUTER JOIN I_RegionalStructureCheckStatus AS _RegionalStructureCheckStatus ON regionalstructurecheckstatus = _RegionalStructureCheckStatus.RegionalStructureCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitle ON academictitle = _AcademicTitle.AcademicTitle  -- association [0..1]
LEFT OUTER JOIN I_AcademicTitle AS _AcademicTitle2 ON academictitle2 = _AcademicTitle2.AcademicTitle  -- 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]
;