I_BusPartScriptedGroupAddress

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_BusPartScriptedGroupAddress.
-- 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: IBPSCRPTGRPADDR

CREATE VIEW I_BusPartScriptedGroupAddress 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.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.BusinessPartnerName1 AS BusinessPartnerName1,
  ScriptedAddress.BusinessPartnerName2 AS BusinessPartnerName2,
  ScriptedAddress.TaxJurisdiction AS TaxJurisdiction,
  ScriptedAddress.TransportZone AS TransportZone,
  ScriptedAddress.FormOfAddress AS FormOfAddress,
  ScriptedAddress.SearchTerm1 AS SearchTerm1,
  ScriptedAddress.SearchTerm2 AS SearchTerm2
FROM but020 AS BusinessPartnerAddress
INNER JOIN I_ScriptedOrganizationAddress 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]
;