I_InvgCsMAddress

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_InvgCsMAddress.
-- 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: IINVGCSADD

CREATE VIEW I_InvgCsMAddress AS
SELECT
  addrnumber AS AddressID,
  cast( date_from as crms4_icm_ad_date_fr ) AS InvgCsMAddrValidFromDate,
  Nation,
  po_box AS POBox,
  po_box_num AS POBoxIsWithoutNumber,
  post_code2 AS POBoxPostalCode,
  po_box_lobby AS POBoxLobbyName,
  po_box_loc AS POBoxDeviatingCityName,
  po_box_reg AS POBoxDeviatingRegion,
  po_box_cty AS POBoxDeviatingCountry,
  deli_serv_type AS DeliveryServiceTypeCode,
  deli_serv_number AS DeliveryServiceNumber,
  time_zone AS AddressTimeZone,
  langu AS CorrespondenceLanguage,
  deflt_comm AS PrfrdCommMediumType,
  post_code1 AS PostalCode,
  post_code3 AS CompanyPostalCode,
  street AS StreetName,
  house_num1 AS HouseNumber,
  house_num2 AS HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  title AS FormOfAddress,
  Country,
  Region,
  taxjurcode AS TaxJurisdiction,
  transpzone AS TransportZone,
  cast(substring(replace(concat(name1, concat(' &', name2)), '&', ''),1,80) as adfullname ) AS FullName,
  city1 AS CityName,
  location AS AdditionalStreetSuffixName,
  chckstatus AS CityFileTestStatus,
  dont_use_s AS AddressStreetUnusable,
  dont_use_p AS AddressPostBoxUnusable,
  city2 AS DistrictName,
  city2 AS District,
  city_code AS CityNumber,
  city_code AS CityCode,
  home_city AS HomeCityName,
  str_suppl1 AS StreetPrefixName,
  str_suppl2 AS AdditionalStreetPrefixName,
  str_suppl3 AS StreetSuffixName,
  county AS SecondaryRegionName,
  County,
  county_code AS CountyCode,
  township_code AS TownshipCode,
  township AS TownshipName,
  name1 AS BusinessPartnerName1,
  name2 AS BusinessPartnerName2,
  sort1 AS SearchTerm1,
  sort2 AS SearchTerm2,
  mc_street AS StreetSearch,
  mc_city1 AS CitySearch,
  name3 AS BusinessPartnerName3,
  name4 AS BusinessPartnerName4,
  city_code2 AS AddressCityPostBoxCode,
  house_num3 AS InvgCsMAddrHouseNumberRange,
  cityp_code AS InvgCsMAddrDistrictCode,
  cityh_code AS InvgCsMAddrDiffntCityName,
  date_to AS InvgCsMAddrValidToDate,
  name_text AS InvgCsMAddrNameText,
  cast(name_co as crms4_icm_ad_name_co ) AS InvgCsMAddrNameCareOfText,
  regiogroup AS InvgCsMAddrRegionGroup,
  pcode1_ext AS InvgCsMAddrPostlCodeExtn,
  pcode2_ext AS InvgCsMAddrPOBoxCodeExtn,
  pcode3_ext AS InvgCsMAddrCustPostCodeExtn,
  postalarea AS InvgCsMAddrPostDelivDstrctCode,
  streetcode AS InvgCsMAddrStCode,
  streetabbr AS InvgCsMAddrStAbbrCode,
  sort_phn AS InvgCsMAddrSortPhone,
  addrorigin AS InvgCsMAddrOrigin,
  extension1 AS InvgCsMAddrExtn1Text,
  extension2 AS InvgCsMAddrExtn2Text,
  address_id AS InvgCsMAddressID,
  langu_crea AS InvgCsMAddrRecdLangCrtnCode,
  xpcpt AS InvgCsMAddrBizPrpsIsCmpltd,
  _AddressText.InvgCsMAddrRemarkText AS InvgCsMAddrRemarkText
FROM adrc
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_CityCode AS _CityCode ON Country = _CityCode.Country AND Region = _CityCode.Region AND CityCode = _CityCode.CityCode  -- association [0..1]
LEFT OUTER JOIN I_SecondaryRegion AS _CountyCode ON Country = _CountyCode.Country AND Region = _CountyCode.Region  -- association [0..*]
;