I_EmployeeHomeAddress

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_EmployeeHomeAddress.
-- 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: IEMPLHOMEADDRSS

CREATE VIEW I_EmployeeHomeAddress AS
SELECT
  _Employee.PersonnelNumber AS PersonnelNumber,
  AddressAdmin.addr_valid_from AS ValidityStartDate,
  _Employee.EmployeeInternalID AS EmployeeInternalID,
  AddressAdmin.partner AS BusinessPartner,
  _Employee.Employee AS Employee,
  _Employee.FullName AS FullName,
  AddressAdmin.addr_valid_to AS ValidityEndDate,
  Address.Country AS Country,
  Address.Region AS Region,
  Address.CityName AS CityName,
  Address.HomeCityName AS HomeCityName,
  Address.District AS District,
  Address.PostalCode AS PostalCode,
  Address.StreetName AS StreetName,
  Address.StreetPrefixName AS StreetPrefixName,
  Address.StreetSuffixName AS StreetSuffixName,
  Address.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  Address.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  Address.HouseNumber AS HouseNumber,
  Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  Address.CareOfName AS CareOfName,
  AddrPointer.persnumber AS Person,
  commdata.DestinationLocationCountry AS DestinationLocationCountry,
  commdata.PhoneNumber AS PhoneNumber,
  commdata.PhoneNumberExtension AS PhoneNumberExtension,
  commdata.MblPhoneDestinationLocCountry AS MblPhoneDestinationLocCountry,
  commdata.MobilePhoneNumber AS MobilePhoneNumber,
  commdata.DefaultEmailAddress AS DefaultEmailAddress,
  '0060' AS AuthorizationGroup
FROM adcp AS AddrPointer
INNER JOIN I_Address AS Address ON /* join condition not captured in parsed metadata */
INNER JOIN but020 AS AddressAdmin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_EmplPrivCommData AS commdata ON Address.AddressID = commdata.AddressID AND AddrPointer.persnumber = commdata.Person  -- association [0..1]
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] to I_Employee as _Employee on Person = _Employee.Person association[0..1] to I_BusinessPartner as _BusinessPartner on AddressAdmin.partner = _BusinessPartner.BusinessPartner  -- association [0..1]
;