I_INS_ClmPrtcpntStdAddress

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_INS_ClmPrtcpntStdAddress.
-- 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_INS_ClmPrtcpntStdAddress AS
SELECT
  but020.BusinessPartner AS BusinessPartner,
  but020.AddressNumber AS AddressNumber,
  but020.ValidityStartDate AS ValidityStartDate,
  but020.ValidityEndDate AS ValidityEndDate,
  but020.BusinessPartnerAddressUUID AS BusinessPartnerAddressUUID,
  but020.CareOfName AS CareOfName,
  but020.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  but020.CorrespondenceLanguage AS CorrespondenceLanguage,
  but020.CityName AS CityName,
  but020.PostalCode AS PostalCode,
  but020.StreetName AS StreetName,
  but020.HouseNumber AS HouseNumber,
  but020.Country AS Country,
  but020.Region AS Region,
  but020.DistrictName AS DistrictName,
  but020.Floor AS Floor,
  but020.RoomNumber AS RoomNumber,
  but020.BPCountyText AS BPCountyText,
  but020.CityNumber AS CityNumber,
  but020.HomeCityName AS HomeCityName,
  but020.PrfrdCommMediumType AS PrfrdCommMediumType,
  but020.POBox AS POBox,
  but020.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  but020.POBoxPostalCode AS POBoxPostalCode,
  but020.POBoxLobbyName AS POBoxLobbyName,
  but020.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  but020.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  but020.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  but020.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  but020.DeliveryServiceNumber AS DeliveryServiceNumber,
  but020.AddressTimeZone AS AddressTimeZone,
  but020.CityFileTestStatus AS CityFileTestStatus,
  but020.AddressStreetUnusable AS AddressStreetUnusable,
  but020.AddressPostBoxUnusable AS AddressPostBoxUnusable,
  but020.FullName AS FullName,
  but020.CountyCode AS CountyCode,
  but020.TownshipCode AS TownshipCode,
  but020.TownshipName AS TownshipName,
  but020.FormOfAddress AS FormOfAddress,
  but020.BusinessPartnerName1 AS BusinessPartnerName1,
  but020.BusinessPartnerName2 AS BusinessPartnerName2,
  but020.Nation AS Nation,
  but020.PhoneNumber AS PhoneNumber,
  but020.AddressFaxNumber AS AddressFaxNumber,
  but020.SearchTerm1 AS SearchTerm1,
  but020.SearchTerm2 AS SearchTerm2,
  but020.StreetSearch AS StreetSearch,
  but020.CitySearch AS CitySearch,
  but020.BusinessPartnerName3 AS BusinessPartnerName3,
  but020.BusinessPartnerName4 AS BusinessPartnerName4,
  but020.TaxJurisdiction AS TaxJurisdiction,
  but020.TransportZone AS TransportZone,
  but020.AddressCityPostBoxCode AS AddressCityPostBoxCode,
  but020.Person AS AddressPersonID,
  _BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  case when _BusinessPartner.BusinessPartnerCategory = '1' then _CurrentDfltEmailAddress.EmailAddress else _OrgEmailAddress.EmailAddress end as EmailAddress AS EmailAddressendasEmailAddress
FROM I_BusinessPartnerAddress_2 AS but020
INNER JOIN I_BusinessPartner AS but000 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_AddressPhoneNumber_2 AS _CurrentDfltLandlinePhoneNmbr ON _CurrentDfltLandlinePhoneNmbr.AddressID = AddressNumber AND _CurrentDfltLandlinePhoneNmbr.PhNmbrIsCurrentOverallDefault = 'X' AND _CurrentDfltLandlinePhoneNmbr.PhoneNumberType = '1' AND _CurrentDfltLandlinePhoneNmbr.AddressPersonID = AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _CurrentDfltMobile ON _CurrentDfltMobile.AddressID = AddressNumber AND _CurrentDfltMobile.AddressPersonID = AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddressFaxNumber_2 AS _CurrentDfltFaxNumber ON _CurrentDfltFaxNumber.AddressID = AddressNumber AND _CurrentDfltFaxNumber.AddressPersonID = AddressPersonID AND _CurrentDfltFaxNumber.FaxNumberIsCurrentDefault = 'X'  -- association [0..1]
LEFT OUTER JOIN I_AddressEmailAddress_2 AS _CurrentDfltEmailAddress ON _CurrentDfltEmailAddress.AddressID = AddressNumber AND _CurrentDfltEmailAddress.AddressPersonID = AddressPersonID AND _CurrentDfltEmailAddress.EmailAddressIsCurrentDefault = 'X'  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _OrgDfltPhNmbr ON _OrgDfltPhNmbr.AddressID = AddressNumber AND _OrgDfltPhNmbr.AddressPersonID = ''  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _OrganizationDfltFaxNumber ON _OrganizationDfltFaxNumber.AddressID = AddressNumber AND _OrganizationDfltFaxNumber.AddressPersonID = ''  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultEmailAddress AS _OrgEmailAddress ON _OrgEmailAddress.AddressID = AddressNumber AND _OrgEmailAddress.AddressPersonID = ''  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _Mobile ON _Mobile.AddressID = AddressNumber AND _Mobile.AddressPersonID = ''  -- association [0..1]
;