I_AddressTP

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_AddressTP.
-- 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: IADDRTP

CREATE VIEW I_AddressTP AS
SELECT
  Address.AddressID AS AddressID,
  Address.AddressObjectType AS AddressObjectType,
  Address.CareOfName AS CareOfName,
  cast ( Address.StreetSuffixName2 as ad_lctn preserving type ) 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,
  cast( Address.AddresseeFullName as caaddr_fullname preserving type ) AS FullName,
  Address.CityName AS CityName,
  Address.DistrictName AS DistrictName,
  Address.DistrictName AS District,
  Address.CityNumber AS CityCode,
  Address.VillageName AS HomeCityName,
  Address.PostalCode AS PostalCode,
  Address.CompanyPostalCode AS CompanyPostalCode,
  Address.StreetName AS StreetName,
  Address.StreetPrefixName1 AS StreetPrefixName,
  Address.StreetPrefixName2 AS AdditionalStreetPrefixName,
  Address.StreetSuffixName1 AS StreetSuffixName,
  Address.HouseNumber AS HouseNumber,
  Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  Address.Building AS Building,
  Address.Floor AS Floor,
  Address.RoomNumber AS RoomNumber,
  cast( Address.Country as caaddr_country preserving type ) AS Country,
  Address.Region AS Region,
  Address.SecondaryRegionName AS SecondaryRegionName,
  Address.SecondaryRegionName AS County,
  Address.SecondaryRegion AS CountyCode,
  Address.FormOfAddress AS FormOfAddress,
  _OrganizationAddress.AddresseeName1 AS BusinessPartnerName1,
  _OrganizationAddress.AddresseeName2 AS BusinessPartnerName2,
  Address.AddressRepresentationCode AS Nation,
  cast ( _CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as caaddr_phonenr preserving type ) AS PhoneNumber,
  _CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber,
  Address.AddressSearchTerm1 AS SearchTerm1,
  cast( '' as ad_mc_strt) AS StreetSearch,
  cast( '' as ad_mc_city) AS CitySearch,
  _OrganizationAddress.AddresseeName3 AS BusinessPartnerName3,
  _OrganizationAddress.AddresseeName4 AS BusinessPartnerName4,
  Address.TaxJurisdiction AS TaxJurisdiction,
  Address.TransportZone AS TransportZone,
  Address.AddressPersonID AS Person,
  cast( '' as ad_adrtype ) AS AddressType,
  cast( '' as ad_objkey ) AS AddressOwnerObjectID,
  cast( '' as boolean) AS AddressIsChangedManually,
  cast( '' as ad_addrnum ) AS ActiveAddressID,
  cast( '' as boolean ) AS ActiveAddressIsManual,
  cast( '' as ad_appltab ) AS AddressOwnerTableName,
  cast( '' as ad_applfld ) AS AddressOwnerReferenceFieldName,
  cast( '' as ad_applfld ) AS AddressOwnerManualFieldName,
  cast( '' as ad_addrnum ) AS ReferenceAddressID,
  cast( '' as ad_objkey ) AS ReferenceObjectID,
  cast( '' as caaddr_e_type ) AS ReferenceAddressType,
  cast ( _CurrentDfltEmailAddress.EmailAddress as caaddr_smtpadr preserving type ) AS EmailAddress,
  cast ( 1 as vdm_lastchangedon ) AS LastChangeDateTime
FROM I_Address_2 AS Address
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON _LanguageText.Language = CorrespondenceLanguage AND _LanguageText.LanguageCode = CorrespondenceLanguage  -- association [0..1]
;