SEPM_I_Employee

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 SEPM_I_Employee.
-- 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: SEPM_IEMPLOYEE

CREATE VIEW SEPM_I_Employee AS
SELECT
  snwd_employees.node_key AS EmployeeUUID,
  snwd_employees.parent_key AS CompanyUUID,
  snwd_employees.employee_id AS Employee,
  snwd_employees.first_name AS FirstName,
  snwd_employees.middle_name AS MiddleName,
  snwd_employees.last_name AS LastName,
  snwd_employees.initials AS Initials,
  sex AS GenderCode,
  snwd_employees.language AS PreferredLanguage,
  snwd_employees.employee_pic_url AS EmployeePictureURL,
  phone_number AS PhoneNumber,
  snwd_employees.email_address AS EmailAddress,
  snwd_employees.login_name AS SystemUser,
  cast( concat_with_space( snwd_employees.first_name , snwd_employees.last_name, 1 ) as sepm_full_name preserving type ) AS FullName,
  snwd_employees.val_start_date AS EmploymentStartDate,
  snwd_employees.val_end_date AS EmploymentEndDate,
  currency AS SalaryCurrency,
  snwd_employees.salary_amount AS SalaryAmount,
  snwd_employees.mobile_number AS MobilePhoneNumber
FROM snwd_employees
LEFT OUTER JOIN SEPM_I_Company AS _Company ON CompanyUUID = _Company.CompanyUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_GenderCode AS _GenderCode ON GenderCode = _GenderCode.GenderCode  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Language AS _PreferredLanguage ON PreferredLanguage = _PreferredLanguage.Language  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Address AS _HomeAddress ON HomeAddressUUID = _HomeAddress.AddressUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Currency AS _SalaryCurrency ON SalaryCurrency = _SalaryCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN SEPM_I_LeaveRequest AS _LeaveRequest ON EmployeeUUID = _LeaveRequest.EmployeeUUID  -- association [0..*]
LEFT OUTER JOIN SEPM_I_EmployeeOrgAssignment AS _EmployeeOrgAssignment ON EmployeeUUID = _EmployeeOrgAssignment.EmployeeUUID  -- association [0..*]
;