C_CustomerAddressIDValueHelp

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 C_CustomerAddressIDValueHelp.
-- 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: CCUSTADDRIDVH

CREATE VIEW C_CustomerAddressIDValueHelp AS
SELECT
  cast(Customer.AddressID as caaddr_addressid preserving type ) AS AddressID,
  cast(Customer.Customer as caaddr_customerid preserving type ) AS ReferenceObjectID,
  Address.FullName AS FullName,
  Address.BusinessPartnerName1 AS BusinessPartnerName1,
  Address.BusinessPartnerName2 AS BusinessPartnerName2,
  Address.StreetName AS StreetName,
  Address.HouseNumber AS HouseNumber,
  Address.PostalCode AS PostalCode,
  Address.CityName AS CityName,
  Address.District AS District,
  Address.Country AS Country,
  Address.Region AS Region,
  Customer.CustomerName AS CustomerName,
  Address.CareOfName AS CareOfName,
  Address.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  Address.PrfrdCommMediumType AS PrfrdCommMediumType,
  Address.POBox AS POBox,
  Address.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  Address.POBoxPostalCode AS POBoxPostalCode,
  Address.POBoxLobbyName AS POBoxLobbyName,
  Address.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  Address.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  Address.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  Address.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  Address.DeliveryServiceNumber AS DeliveryServiceNumber,
  Address.AddressTimeZone AS AddressTimeZone,
  Address.CityCode AS CityCode,
  Address.HomeCityName AS HomeCityName,
  Address.CompanyPostalCode AS CompanyPostalCode,
  Address.StreetPrefixName AS StreetPrefixName,
  Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  Address.StreetSuffixName AS StreetSuffixName,
  Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  Address.Building AS Building,
  Address.Floor AS Floor,
  Address.RoomNumber AS RoomNumber,
  Address.County AS County,
  Address.FormOfAddress AS FormOfAddress,
  Address.Nation AS Nation,
  Address.PhoneNumber AS PhoneNumber,
  Address.FaxNumber AS FaxNumber,
  Address.SearchTerm1 AS SearchTerm1,
  Address.StreetSearch AS StreetSearch,
  Address.CitySearch AS CitySearch,
  Address.BusinessPartnerName3 AS BusinessPartnerName3,
  Address.BusinessPartnerName4 AS BusinessPartnerName4,
  Address.TaxJurisdiction AS TaxJurisdiction,
  Address.TransportZone AS TransportZone,
  Address.Person AS Person,
  _DefaultEmailAddress.EmailAddress AS EmailAddress,
  Customer.Customer AS Customer,
  Customer.CustomerAccountGroup AS CustomerAccountGroup,
  Customer.AuthorizationGroup AS AuthorizationGroup,
  Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  Customer.DataControllerSet AS DataControllerSet,
  Customer.DataController1 AS DataController1,
  Customer.DataController2 AS DataController2,
  Customer.DataController3 AS DataController3,
  Customer.DataController4 AS DataController4,
  Customer.DataController5 AS DataController5,
  Customer.DataController6 AS DataController6,
  Customer.DataController7 AS DataController7,
  Customer.DataController8 AS DataController8,
  Customer.DataController9 AS DataController9,
  Customer.DataController10 AS DataController10
LEFT OUTER JOIN I_Address AS Address ON /* join condition not captured in parsed metadata */
;