I_BusPartScriptedPersonAddress

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_BusPartScriptedPersonAddress.
-- 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.
-- SQL view name: IBPSCRPTPRSADDR

CREATE VIEW I_BusPartScriptedPersonAddress AS
SELECT
  BusinessPartnerAddress.partner AS BusinessPartner,
  BusinessPartnerAddress.addrnumber AS AddressNumber,
  ScriptedAddress.AddressRepresentationCode AS AddressRepresentationCode,
  BusinessPartnerAddress.addr_valid_from AS ValidityStartDateTime,
  BusinessPartnerAddress.addr_valid_to AS ValidityEndDateTime,
  bintohex( BusinessPartnerAddress.address_guid ) AS BusinessPartnerAddressUUID,
  ScriptedAddress.CareOfName AS CareOfName,
  ScriptedAddress.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  ScriptedAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  ScriptedAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  ScriptedAddress.POBox AS POBox,
  ScriptedAddress.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  ScriptedAddress.POBoxPostalCode AS POBoxPostalCode,
  ScriptedAddress.POBoxLobbyName AS POBoxLobbyName,
  ScriptedAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  ScriptedAddress.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  ScriptedAddress.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  ScriptedAddress.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  ScriptedAddress.DeliveryServiceNumber AS DeliveryServiceNumber,
  ScriptedAddress.AddressTimeZone AS AddressTimeZone,
  ScriptedAddress.CityFileTestStatus AS CityFileTestStatus,
  ScriptedAddress.AddressNonDeliverableReason AS AddressNonDeliverableReason,
  ScriptedAddress.PostBoxNonDeliverableReason AS PostBoxNonDeliverableReason,
  ScriptedAddress.FullName AS FullName,
  ScriptedAddress.CityName AS CityName,
  ScriptedAddress.District AS District,
  ScriptedAddress.District AS DistrictName,
  ScriptedAddress.HomeCityName AS HomeCityName,
  ScriptedAddress.PostalCode AS PostalCode,
  ScriptedAddress.CompanyPostalCode AS CompanyPostalCode,
  ScriptedAddress.StreetName AS StreetName,
  ScriptedAddress.StreetPrefixName AS StreetPrefixName,
  ScriptedAddress.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  ScriptedAddress.StreetSuffixName AS StreetSuffixName,
  ScriptedAddress.HouseNumber AS HouseNumber,
  ScriptedAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  ScriptedAddress.Building AS Building,
  ScriptedAddress.Floor AS Floor,
  ScriptedAddress.RoomNumber AS RoomNumber,
  ScriptedAddress.Country AS Country,
  ScriptedAddress.Region AS Region,
  ScriptedAddress.County AS County,
  ScriptedAddress.County AS BPCountyText,
  ScriptedAddress.TaxJurisdiction AS TaxJurisdiction,
  ScriptedAddress.TransportZone AS TransportZone,
  ScriptedAddress.Person AS Person,
  ScriptedAddress.FormOfAddress AS FormOfAddress,
  ScriptedAddress.SearchTerm1 AS SearchTerm1,
  ScriptedAddress.SearchTerm2 AS SearchTerm2,
  ScriptedAddress.FirstName AS FirstName,
  ScriptedAddress.LastName AS LastName,
  ScriptedAddress.BusinessPartnerBirthName AS BusinessPartnerBirthName,
  ScriptedAddress.MiddleName AS MiddleName,
  ScriptedAddress.AdditionalLastName AS AdditionalLastName,
  ScriptedAddress.PersonFullName AS PersonFullName,
  ScriptedAddress.AcademicTitle AS AcademicTitle,
  ScriptedAddress.AcademicTitle2 AS AcademicTitle2,
  ScriptedAddress.LastNamePrefix AS LastNamePrefix,
  ScriptedAddress.LastNameSecondPrefix AS LastNameSecondPrefix,
  ScriptedAddress.BusinessPartnerSupplementName AS BusinessPartnerSupplementName,
  ScriptedAddress.BusinessPartnerNicknameLabel AS BusinessPartnerNicknameLabel,
  ScriptedAddress.Initials AS Initials,
  ScriptedAddress.NameFormat AS NameFormat,
  ScriptedAddress.NameCountry AS NameCountry,
  ScriptedAddress.BPFirstNameSearchHelp AS BPFirstNameSearchHelp,
  ScriptedAddress.BPLastNameSearchHelp AS BPLastNameSearchHelp
FROM but020 AS BusinessPartnerAddress
INNER JOIN I_ScriptedPersonAddress AS ScriptedAddress ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ScriptedOrganizationAddress AS _ScriptedAddress ON BusinessPartnerAddress.addrnumber = _ScriptedAddress.AddressNumber AND AddressRepresentationCode = _ScriptedAddress.AddressRepresentationCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPProtectedAddress AS _BPProtectedAddress ON BusinessPartner = _BPProtectedAddress.BusinessPartner AND AddressNumber = _BPProtectedAddress.AddressID  -- association [0..1]
;