C_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 C_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: CADDRRTP

CREATE VIEW C_AddressTP AS
SELECT
  Document.AddressID AS AddressID,
  Document.CareOfName AS CareOfName,
  Document.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  Document.CorrespondenceLanguage AS CorrespondenceLanguage,
  Document.PrfrdCommMediumType AS PrfrdCommMediumType,
  Document.POBox AS POBox,
  Document.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  Document.POBoxPostalCode AS POBoxPostalCode,
  Document.POBoxLobbyName AS POBoxLobbyName,
  Document.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  Document.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  Document.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  Document.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  Document.DeliveryServiceNumber AS DeliveryServiceNumber,
  Document.FullName AS FullName,
  Document.CityName AS CityName,
  Document.DistrictName AS DistrictName,
  Document.CityCode AS CityCode,
  Document.HomeCityName AS HomeCityName,
  Document.PostalCode AS PostalCode,
  Document.CompanyPostalCode AS CompanyPostalCode,
  Document.StreetName AS StreetName,
  Document.StreetPrefixName AS StreetPrefixName,
  Document.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  Document.StreetSuffixName AS StreetSuffixName,
  Document.HouseNumber AS HouseNumber,
  Document.HouseNumberSupplementText AS HouseNumberSupplementText,
  Document.Building AS Building,
  Document.Floor AS Floor,
  Document.RoomNumber AS RoomNumber,
  Document.Country AS Country,
  Document.Region AS Region,
  Document.SecondaryRegionName AS SecondaryRegionName,
  Document.CountyCode AS CountyCode,
  Document.FormOfAddress AS FormOfAddress,
  Document.TaxJurisdiction AS TaxJurisdiction,
  Document.TransportZone AS TransportZone,
  Document.PhoneNumber AS PhoneNumber,
  Document.FaxNumber AS FaxNumber,
  Document.EmailAddress AS EmailAddress,
  Document.AddressIsChangedManually AS AddressIsChangedManually,
  Document.ReferenceAddressID AS ReferenceAddressID,
  Document.ReferenceObjectID AS ReferenceObjectID,
  Document.ReferenceAddressType AS ReferenceAddressType
FROM I_AddressTP AS Document
LEFT OUTER JOIN C_SupplierAddressIDValueHelp AS _SupplierAddressIDValueHelp ON FullName = _SupplierAddressIDValueHelp.FullName  -- association [0..*]
LEFT OUTER JOIN C_PlantAddressIDValueHelp AS _PlantAddressIDValueHelp ON FullName = _PlantAddressIDValueHelp.FullName  -- association [0..*]
LEFT OUTER JOIN C_CustomerAddressIDValueHelp AS _CustomerAddressIDValueHelp ON FullName = _CustomerAddressIDValueHelp.FullName  -- association [0..*]
LEFT OUTER JOIN C_MM_CountryValueHelp AS _CountryValueHelp ON Country = _CountryValueHelp.Country  -- association [0..1]
LEFT OUTER JOIN C_MM_RegionValueHelp AS _RegionValueHelp ON Country = _RegionValueHelp.Country AND Region =_RegionValueHelp.Region  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_RegionText AS _RegionText ON Region = _RegionText.Region AND Country = _RegionText.Country  -- association [0..*]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
;