I_AddrOrgNamePostalAddress

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_AddrOrgNamePostalAddress.
-- 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.

CREATE VIEW I_AddrOrgNamePostalAddress AS
SELECT
  addrnumber AS AddressID,
  nation AS AddressRepresentationCode,
  pers_addr AS AddressIsPersonAddress,
  langu AS CorrespondenceLanguage,
  deflt_comm AS PrfrdCommMediumType,
  city_code AS CityNumber,
  city1 AS CityName,
  city2 AS DistrictName,
  home_city AS VillageName,
  post_code1 AS PostalCode,
  post_code3 AS CompanyPostalCode,
  po_box AS POBox,
  dont_use_p AS POBoxAddrNonDeliverableReason,
  po_box_num AS POBoxIsWithoutNumber,
  post_code2 AS POBoxPostalCode,
  po_box_lobby AS POBoxLobbyName,
  po_box_loc AS POBoxDeviatingCityName,
  city_code2 AS POBoxDeviatingCityCode,
  po_box_reg AS POBoxDeviatingRegion,
  po_box_cty AS POBoxDeviatingCountry,
  streetcode AS Street,
  street AS StreetName,
  dont_use_s AS StreetAddrNonDeliverableReason,
  str_suppl1 AS StreetPrefixName1,
  str_suppl2 AS StreetPrefixName2,
  str_suppl3 AS StreetSuffixName1,
  location AS StreetSuffixName2,
  house_num1 AS HouseNumber,
  house_num2 AS HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  Country,
  Region,
  name_co AS CareOfName,
  title AS FormOfAddress,
  name1 AS AddresseeName1,
  name2 AS AddresseeName2,
  name3 AS AddresseeName3,
  name4 AS AddresseeName4,
  taxjurcode AS TaxJurisdiction,
  transpzone AS TransportZone,
  deli_serv_type AS DeliveryServiceTypeCode,
  deli_serv_number AS DeliveryServiceNumber,
  time_zone AS AddressTimeZone,
  county_code AS SecondaryRegion,
  county AS SecondaryRegionName,
  township_code AS TertiaryRegion,
  township AS TertiaryRegionName,
  sort1 AS AddressSearchTerm1,
  sort2 AS AddressSearchTerm2,
  chckstatus AS RegionalStructureCheckStatus,
  addr_group AS AddressGroup,
  cityp_code AS DistrictNumber,
  cityh_code AS Village,
  regiogroup AS RegionalStructureGroup,
  AddressCreatedByUser,
  AddressCreatedOnDateTime,
  AddressChangedByUser,
  AddressChangedOnDateTime
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_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON TransportZone = _TransportationZone.TransportZone AND Country = _TransportationZone.CountryCode  -- association [0..1]
LEFT OUTER JOIN I_AddressRepresentation AS _AddressRepresentationCode ON AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode  -- association [0..1]
;