A_ReturnsDeliveryAddress

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 A_ReturnsDeliveryAddress.
-- 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: ARETSDELIVERYAD

CREATE VIEW A_ReturnsDeliveryAddress AS
SELECT
  I_Address_2.AddressID AS AddressID,
  I_Address_2.StreetPrefixName2 AS AdditionalStreetPrefixName,
  I_Address_2.StreetSuffixName2 AS AdditionalStreetSuffixName,
  I_Address_2.AddressTimeZone AS AddressTimeZone,
  I_Address_2.Building AS Building,
  I_Address_2.OrganizationName1 AS BusinessPartnerName1,
  I_Address_2.OrganizationName2 AS BusinessPartnerName2,
  I_Address_2.OrganizationName3 AS BusinessPartnerName3,
  I_Address_2.OrganizationName4 AS BusinessPartnerName4,
  I_Address_2.CareOfName AS CareOfName,
  I_Address_2.CityNumber AS CityCode,
  I_Address_2.CityName AS CityName,
  cast(' ' as char25 preserving type ) AS CitySearch,
  I_Address_2.CompanyPostalCode AS CompanyPostalCode,
  I_Address_2.CorrespondenceLanguage AS CorrespondenceLanguage,
  I_Address_2.Country AS Country,
  I_Address_2.SecondaryRegionName AS County,
  I_Address_2.DeliveryServiceNumber AS DeliveryServiceNumber,
  I_Address_2.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  I_Address_2.DistrictName AS District,
  _CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber,
  I_Address_2.Floor AS Floor,
  I_Address_2.FormOfAddress AS FormOfAddress,
  I_Address_2.AddresseeFullName AS FullName,
  I_Address_2.VillageName AS HomeCityName,
  I_Address_2.HouseNumber AS HouseNumber,
  I_Address_2.HouseNumberSupplementText AS HouseNumberSupplementText,
  I_Address_2.AddressRepresentationCode AS Nation,
  I_Address_2.AddressPersonID AS Person,
  _CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  I_Address_2.POBox AS POBox,
  I_Address_2.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  I_Address_2.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  I_Address_2.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  I_Address_2.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  I_Address_2.POBoxLobbyName AS POBoxLobbyName,
  I_Address_2.POBoxPostalCode AS POBoxPostalCode,
  I_Address_2.PostalCode AS PostalCode,
  I_Address_2.PrfrdCommMediumType AS PrfrdCommMediumType,
  I_Address_2.Region AS Region,
  I_Address_2.RoomNumber AS RoomNumber,
  cast(' ' as char20 preserving type ) AS SearchTerm1,
  I_Address_2.StreetName AS StreetName,
  I_Address_2.StreetPrefixName1 AS StreetPrefixName,
  cast(' ' as char25 preserving type ) AS StreetSearch,
  I_Address_2.StreetSuffixName1 AS StreetSuffixName,
  I_Address_2.TaxJurisdiction AS TaxJurisdiction,
  I_Address_2.TransportZone AS TransportZone
FROM I_Address_2
;