I_EmplHomeAddress

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_EmplHomeAddress.
-- 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: IEMPLHOMEADDRESS

CREATE VIEW I_EmplHomeAddress AS
SELECT
  bpaddress.addrnumber AS AddressID,
  employee.PersonnelNumber AS PersonnelNumber,
  employee.Employee AS Employee,
  bpaddress.partner AS EmployeeInternalID,
  bpaddress.addr_valid_from AS StartDate,
  bpaddress.addr_valid_to AS EndDate,
  paddress.Country AS Country,
  paddress.Region AS Region,
  paddress.District AS District,
  paddress.PostalCode AS PostalCode,
  paddress.CityName AS CityName,
  paddress.HomeCityName AS HomeCityName,
  paddress.StreetName AS StreetName,
  paddress.StreetPrefixName AS StreetPrefixName,
  paddress.StreetSuffixName AS StreetSuffixName,
  paddress.AdditionalStreetPrefixName AS AdditionalStreetPrefixName,
  paddress.AdditionalStreetSuffixName AS AdditionalStreetSuffixName,
  paddress.HouseNumber AS HouseNumber,
  paddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  paddress.CareOfName AS CareOfName,
  commdata.Person 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,
  paddress._Region AS _Region,
  paddress._Country AS _Country,
  '0060' AS AuthorizationGroup
FROM I_Employee AS employee
INNER JOIN but020 AS bpaddress ON /* join condition not captured in parsed metadata */
INNER JOIN P_Emplprivpostaddr AS paddress ON /* join condition not captured in parsed metadata */
INNER JOIN but021_fs AS addresstype ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_EmplPrivCommData AS commdata ON /* join condition not captured in parsed metadata */
;